DateTime is a datatype in Access and reserved in Access... Don't know about MySQL (it's probably fine.. just worth checking into)
I'd actually lose the cfqueryparam and just make it createodbcdatetime(now()). It's always taken care of formatting the date/time like it needs to be for me and whatever date/time type the database is using. Also, MySQL has MANY date functions. You could use those as well if the above doesnt work for you. Does 'set datetime = CURRENT_TIMESTAMP()' work?? I dont guess I've ever even TRIED to use those functions in an UPDATE query. http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html Good luck! ..:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -----Original Message----- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Thursday, February 09, 2006 9:18 PM To: CF-Talk Subject: RE: What's wrong with this? I tried taking off the CreateODBCDateTime part earlier...still got the same error message. I was a little struck by the fact that the TimeStamp field isn't updating without any reference in the update query...usually it does. The default is set to "CURRENT_TIMESTAMP"...that's the default setting it inserted automatically when the field was created. But since the TimeStamp field wasn't updating to the current time, I thought I'd try to force it... If I remove that line from the query, I don't get an error, but don't get an updated datetime, either.... ? Rick > -----Original Message----- > From: Aaron Rouse [mailto:[EMAIL PROTECTED] > Sent: Thursday, February 09, 2006 9:03 PM > To: CF-Talk > Subject: Re: What's wrong with this? > > > I never have worked with MySQL but I know with other databases I > would strip > off the CreateODBCDateTime() and it works fine. Does MySQL not have a > function for the system date/time? I usually make that the default value > for any timestamps and then if updating to it I just set to the function. > > On 2/9/06, Rick Faircloth <[EMAIL PROTECTED]> wrote: > > > > DateTime=<cfqueryparam cfsqltype="CF_SQL_TIMESTAMP" > > Value="#CreateODBCDateTime(Now())#"> > > > > I'm getting a data conversion error...the MySQL DB field is > > a timestamp field and > > this line is from an update query... > > > > Rick > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231856 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
