Heh didnt even catch it... you can wrap it in [action] in the future but changing it was the best thing you could do. ..:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com
-----Original Message----- From: Benjamin Paige [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 07, 2005 9:45 AM To: CF-Talk Subject: RE: Access Error? CF7 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' ) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:226412 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
