Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.
Posted on 2006-10-26
So I thought I was getting the hang of this until I came across this annoying error:
Error Diagnostic Information
ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.
The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (11:1) to (11:44).
Here is what I am trying to do:
<CFQUERY NAME="CHUpdate" DATASOURCE="inout">
What is my problem? I need a quick answer here.