how/where is request.dtStamp being set? the combination of createODBCDate() and losing the single quotes should certainly resolve any issues with getting the date value into the database. Since it's not, I'm leaning towards thinking that maybe the date var isn't being set correctly?
On 11/25/05, ColdFusion <[EMAIL PROTECTED]> wrote: > Tried that both ways, with and without the single quotes with the same end > result > > I am sure it is something I am doing, just been at it too long I guess. > > -----Original Message----- > From: Dawson, Michael [mailto:[EMAIL PROTECTED] > Sent: Friday, November 25, 2005 5:49 PM > To: CF-Talk > Subject: RE: Access Error? CF7 > > Use the createODBCDateTime() function but *also* lose the single quotes. > > Valid timestamp = {ts '2005-11-25 14:44:00'} Valid string, but invalid > timestamp = '{ts '2005-11-25 14:44:00'}' > > M!ke > > -----Original Message----- > From: ColdFusion [mailto:[EMAIL PROTECTED] > Sent: Friday, November 25, 2005 4:47 PM > To: CF-Talk > Subject: RE: Access Error? CF7 > > Nope... > > Error Executing Database Query. > Syntax error in INSERT INTO statement. > The error occurred in E:\webs\mydomain.com\wwwroot\admin\actLogin.cfm: > line > 81 > > 79 : ( > 80 : <CFQUERYPARAM CFSQLTYPE="CF_SQL_INTEGER" > VALUE="#qValidateLogin.ID#">, > 81 : '#createODBCDateTime(REQUEST.dtStamp)#', > 82 : 'Login', > 83 : 'User Login' > > 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:225285 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
