Mike
|
Posted: 07/14/2004, 12:31 PM |
|
I am unable to update or add to a MS Access 97 database using cold fusion 4.5. I get a syntax error that does not expain the problem. The records display properly. Pages generated by application builder. One table used, one autonumber field (key), 10 text fields and 1 text area or memo field in record.
The message:
The error has occured :
[Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.
Anyone have this problem?
Mike
|
|
|
peterr
Posts: 5971
|
Posted: 07/14/2004, 9:20 PM |
|
Try debugging the SQL to see how it looks like. See http://docs.codecharge.com/studio/html/ProgrammingTechn...yingOutput.html
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
E43509
Posts: 283
|
Posted: 07/15/2004, 5:45 AM |
|
Also try turning on debug for CF and grab the sql statement and paste it into MS access and run it. That will usually give you more info on why the statement is bad
|
|
|
|