MSAccess2000, SQL, and Escape Characters
| From: | Ari M. Roth | Date: | Mon, 22 Oct 2001 05:29:48 +0000 |
| Subject: | MSAccess2000, SQL, and Escape Characters | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-13589@lists.php.net to get a copy of this message | ||
Hey all...
Does anyone know how Microsoft Access 2000 handles escaping apostrophes in SQL statements? I tried
back-slashing (\') them out, but that didn't work (i.e, "insert into blah values(1,
'Bob', 'Bob\'s stuff')"). And since that didn't work,
addslashes(), of course, didn't work either.
Thanks.
Later...
-Ari