I have a table for messages, and when a new message is inserted I want the
current date and time to be inserted into the MessageDated and MessageTimed
fields. I'm using MySQL 3.23.56 (?), with Chilisoft ASP, and using the
MySQL Control Center interface.
The problem is that no matter what I try, I seem to end up with
00000000000000 in the fields instead of the current date and time. For
example, I have two hidden fields in my insert form, called MessageDated and
MessageTimed, each set to <% = now() %>. I have the fields in the database
set to DATETIME and also with default value 'now()'. But this doesn't seem
How can I get the default value to be now()? The only way I've succeeded is
by setting the type of field to VARCHAR, but that's not ideal.
Thanks in advance for any help you can give me!