I tried the default value on the field for Now(), thus Every time a record is added to the database it sets that field to:
1/1/0000 The query is not the one who is inserting the NOW parameters, trying to set it on the database itself. I have the field defined as: DateTime. Any ideas? -----Original Message----- From: JediHomer [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 04, 2005 11:32 AM To: CF-Community Subject: Re: MySQL question Try wrapping it in a CreateODBCDateTime(Now()) or lookup the format of the field on the mySQL site and DateFormat() or see if mySQL has an inbuilt version of Now() if all you are going to store is now() HTH On Tue, 4 Jan 2005 11:19:06 -0500, Adkins, Randy <[EMAIL PROTECTED]> wrote: > Does anyone know the proper default value for a DateTime Field in > mySQL? > > I tried using Now() and it converts it to: 0:00:00 0:00:00 Which is > illegal value or call or something like that. > > I want that to be triggered as the default datetime when A record is > added to the table rather than setting the field's value within the > query itself. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:5:141503 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/5 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:5 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.5 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
