Charlie was asking where was request.dtStamp set *before* you run the cfquery.
In other words, do this: <cfoutput>#request.dtStamp#</cfoutput> And <cfoutput>#createODBCDateTime(request.dtStamp)#</cfoutput> Before your CFQUERY tag. The first cfoutput will output your exact variable. The second cfoutput will fail if it is not a valid date/time value. His/our guess is that the variable is not correctly set. M!ke -----Original Message----- From: ColdFusion [mailto:[EMAIL PROTECTED] Sent: Friday, November 25, 2005 5:15 PM To: CF-Talk Subject: RE: Access Error? CF7 It is being established as: > SQL INSERT INTO AccessLog ( MEMBERID, ACTIONDATE, ACTION, TYPE ) > VALUES ( (param 1) , '{ts '2005-11-25 14:44:00'}', 'Login', 'User Login' > ) > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:4:225288 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
