Saving current date/time upon comment submission - help!


#1

I’m having trouble storing the date/time with my comments - I’m getting
the MySQL error “posted_at is null”.

How do I setup my code to automatically store the current date/time in
the ‘posted_at’ column of my ‘comments’ table?


#2

Rename the column created_at instead of posted_at and this behavior
will automatically be turned on (make sure column is DATETIME not
TIMESTAMP). Otherwise have a look at this article on how to extend
ActiveRecord to use custom “magic” timestamp columns: http://
wiki.rubyonrails.com/rails/pages/ExtendingActiveRecordExample

sebastian