The reason for the DateFormat is that it is Being used as Display on some pages as well.
But I will change it to createodbcdate and when I need to display it, I will format it then. Let me give that a shot. -----Original Message----- From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: Friday, November 25, 2005 8:10 PM To: CF-Talk Subject: Re: Access Error? CF7 just do <cfset request.dtStamp = now() /> no reason to do a dateformat on it to store it in a database. On 11/25/05, ColdFusion <[EMAIL PROTECTED]> wrote: > 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' > > ) > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225297 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