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--->
i'd focus some attention on the dynamic table name issue. For example, you have <cfparam name="form.club" default="Not Entered">
My guess is based on form values dictates which table to insert into? With that, there needs to be a more failsafe method of determining which table needs to be in the INSERT statement based on passed form values.
Maybe something like the following:
<cfif IsDefined("form.club") AND form.club neq "" AND Len(form.club)>
<!---- run your code here for the rest of the form values and insert.---->
<!---- Maybe add a conditional that aids in the selection of the table for the insert statement to work with based on passed form values.----->
<cfelse>
<--- error message about the insert failing ---->
</cfif>
let me know if I can be of any additional assistance.