I don't know mysql, but in Oracle, the default option is only relevant when a field is created, not updated.
Also, I would try using the native function: DateTime = CURRENT_TIMESTAMP when you do the update. Unless your time on your CF server is set differently than the time on the mysql server, there's no need to pass it in as a variable. On 2/10/06, Bobby Hartsfield <[EMAIL PROTECTED]> wrote: > > It definitely SHOULD be if its default has been set. > > ..:.:.:.:.:.:.:.:.:.:.:.:. > Bobby Hartsfield > http://acoderslife.com > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231902 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
