Also, the information on the form is a drop-down list that the user selects from. I try to get the form to submit but I keep getting the error Syntax Error(missing operator) in query expression.
Thanks for the reply. This is what I have setup so far:
'Admin Page'
<FORM action="insert.cfm" method="post">
<select type="text" name="section1">
<option>less than 15 minutes</option>
<option>less than 30 minutes</option>
<option>less than 45 minutes</option>
<option>less than 60 minutes</option>
<option>more than 60 minutes</option>
</select>
<select type="text" name="section2">
<option>less than 15 minutes</option>
<option>less than 30 minutes</option>
<option>less than 45 minutes</option>
<option>less than 60 minutes</option>
<option>more than 60 minutes</option>
</select>
etc... to four sections
<CFQUERY NAME="insert2"
datasource="dbname">
insert into table2 (table2value, table2time, table2date)
values (#form.section2#, #form.time#, #form.date#)
</CFQUERY>
etc... for the four values of the form
Then the Insert Page spits out the entered values as verification on the page.
But alas I encounter and error...
ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'less than 15 minutes'.
The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (2:1) to (3:23).
JHoarty,
Thanks for the help!
I have added the single quote as you suggested. I am now returning another error:
Error Diagnostic Information
ODBC Error Code = 07001 (Wrong number of parameters)
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 3.
Hint: The cause of this error is usually that your query contains a reference to a field which does not exist. You should verify that the fields included in your query exist and that you have specified their names correctly.
The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (2:1) to (3:23).
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.