Tip: Store all dates as dates in the database and not as formatted date strings. Format the dates when you want to display them. It will provide consistency for all of your inserts and keep you from having to jump through possible extra hurdles if you want to change the formatting or do date math on those dates after grabbing them from the database.
My $.02 -Jeff -----Original Message----- From: ColdFusion [mailto:[EMAIL PROTECTED] Sent: Friday, November 25, 2005 20:35 To: CF-Talk Subject: RE: Access Error? CF7 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' > > ) > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:225301 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
