UPDATE a database errror
I am trying to run an update query and I am getting an error on the last cfqueryparam. The error is "There is an error in the syntax of the query. Does anyone see the problem with this query.
CODE:
<!---Insert record into table OAREI_results--->
<cfquery datasource="xxx" name="addResult">
INSERT INTO OAREI_results {poll_ID, question_ID, answer_text, votes)
VALUES (<cfqueryparam value="#FORM.QuestionID#" cfsqltype="cf_sql_varchar" />,
<cfqueryparam value="#FORM.QuestionID#" cfsqltype="cf_sql_varchar" />,
<cfqueryparam value="#FORM.Other#" cfsqltype="cf_sql_varchar" />,
<cfqueryparam value="1" cfsqltype="cf_sql_integer" />)
</cfquery>
