note 18112 added to function.odbc-exec

From: Date: Thu, 10 Jan 2002 21:16:32 +0000
Subject: note 18112 added to function.odbc-exec
Groups: php.notes 
Request: Send a blank email to php-notes+get-24640@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. -- http://www.php.net/manual/en/function.odbc-exec.php http://master.php.net/manage/user-notes.php?action=edit+18112 http://master.php.net/manage/user-notes.php?action=delete+18112 http://master.php.net/manage/user-notes.php?action=reject+18112

« previous php.notes (#24640) next »