|
Help with ODBC Error Code = 37000 (Syntax error or access violation)
I am VERY rusty at this. Any help would be greatly appreciated.
Deb
Error Diagnostic Information
ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.
The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (20:3) to (20:47) in the template file c:\websites\wwprsd\cms\clubs\signup.cfm.
This is the code:
<body>
<!---Ensure proper format and instances of data--->
<CFPARAM Name="FORM.club" Default="None Entered">
<CFPARAM Name="FORM.studentid" Default="None Entered">
<CFPARAM Name="FORM.firstname" Default="None Entered">
<CFPARAM Name="FORM.lastname" Default="None Entered">
<CFPARAM Name="FORM.team" Default="None Entered">
<cflock name="InsertNewRecord" type="exclusive" timeout="30">
<cftransaction>
<cfquery name="Addrecord" datasource="CLUBS">
INSERT INTO #FORM.club#(studentid, firstname, lastname, team)
VALUES(#FORM.studentid#,'#FORM.firstname#','#FORM.lastname#','#FORM.team#')
</cfquery>
</cftransaction>
</cflock>
<!---Redirect back to complete page--->
<cfoutput>
<meta http-equiv="REFRESH" content="0;url="Complete.cfm">
</cfoutput>
</body>
|