It is being set as: <CFSET REQUEST.dtStamp = "#Dateformat(Now(), 'MM/DD/YYYY')# #TIMEFORMAT(Now(), 'h:MM:SS TT')#">
-----Original Message----- From: Dawson, Michael [mailto:[EMAIL PROTECTED] Sent: Friday, November 25, 2005 6:40 PM To: CF-Talk Subject: RE: Access Error? CF7 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' > ) > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225289 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
