note 18112 rejected from function.odbc-exec by irc-html

From: Date: Thu, 10 Jan 2002 22:08:47 +0000
Subject: note 18112 rejected from function.odbc-exec by irc-html
References: 1  Groups: php.notes 
Request: Send a blank email to php-notes+get-24641@lists.php.net to get a copy of this message
MS Access/ODBC problem. I'm trying to insert some ID's into a table that's related to a whole bunch of other tables and I keep getting Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement., SQL state 37000 in SQLExecDirect message. I read somewhere to try to rename my variables or table and field names but that didn't work. Does anyone have any idea how to solve this. One more thing, this query works perfectly in one part of my script, but it doesn't work in the other part.

« previous php.notes (#24641) next »