PDA

View Full Version : odbc_exec() SQL error



austenr
06-04-2007, 12:46 PM
Has anyone ever seen this error before?

Warning: odbc_exec() [function.odbc-exec (http://localhost/function.odbc-exec)]: SQL error: [Microsoft][ODBC Microsoft Access Driver] The INSERT INTO statement contains the following unknown field name: 'suffix'. Make sure you have typed the name correctly, and try the operation again., SQL state S0022 in SQLExecDirect in

If so how did you resolve it? Is this an execution error or just a warning?

Oorang
06-04-2007, 03:00 PM
Sounds like a syntax error. Try putting brackets around suffix and make sure that it is spelled that way in the target table.