odbc_do()

From: Date: Tue, 20 Aug 2002 18:58:30 +0000
Subject: odbc_do()
Groups: php.general 
Request: Send a blank email to php-general+get-113379@lists.php.net to get a copy of this message
Not sure if this is the right place to ask. But here it goes. I'm using PHP 4.0.6 and trying to find a way to insert single quoted data. Some of the values in the INSERT statement are single, double quoted, or use backslashes. I cannot seem to use an escape character to input these special characters into an Access database using ODBC. Here's the resulting error: Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Syntax error in query expression ''[\']hello[\']', SQL state 37000 in SQLExecDirect in c:\inetpub\wwwroot\blah.php on line 23 INSERT INTO blah (id, title) VALUES (10,'[\']hello[\']') The original string was [']hello[']. If you can help I would greatly appreciate it, if not could you direct me to the appropriate place. Clayton Butler -- Aphex Imaging -- System Administrator -- 519.332.0160 | x291

« previous php.general (#113379) next »