re: MSAccess2000, SQL, and Escape Characters
| From: | James Cave | Date: | Mon, 22 Oct 2001 06:27:53 +0000 |
| Subject: | re: MSAccess2000, SQL, and Escape Characters | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-13590@lists.php.net to get a copy of this message | ||
> 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.
Try "insert into blah values(1, 'Bob', 'Bob''s stuff')".
I know it doesn't look right, but I'm pretty sure it is.
Regards
James