I believe the problem is with the word "action" itself. I've recently had a similar issure where I "action" was a field in my insert statement. Upon excluding it or changing the name, everything worked appriately. It may be that "action" is keyword in Access, because it doesn't seem to like it.
-----Original Message----- From: Bobby Hartsfield [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 07, 2005 9:37 AM To: CF-Talk Subject: RE: Access Error? CF7 Is actiondate a date field? Try without single quotes around #request.dtStamp# ...:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -----Original Message----- From: Benjamin Paige [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 07, 2005 8:24 AM To: CF-Talk Subject: Re: Access Error? CF7 Action >Anyone see a problem with this query? > >insert into accesslog >( memberid, actiondate, action, type ) >values >( <cfqueryparam cfsqltype="CF_SQL_INTEGER" value="#qValidateLogin.ID#">, > '#REQUEST.dtStamp#', > 'Login', > 'User Login' >) > > >The memberid does exists as well as request.dtstamp > >This is the error I get in CFMX 7: > >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 : '#REQUEST.dtStamp#', > >82 : 'Login', > >83 : 'User Login' > _____ > > >SQL INSERT INTO AccessLog ( MEMBERID, ACTIONDATE, ACTION, TYPE ) >VALUES ( (param 1) , '11/25/2005 2:00:59 PM', '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:226410 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
