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:225274
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
