Hi, I am trying to INSERT into a MSAccess database using PHP 4.3 - I have a problem when I enter a name like O'Donnell. In mysql I would normally just backslash the single quote but this doesn't work with MSAccess. is there a fix for this??
Thanks in adv.
Jason
Most DBs allow you to use '' to quote a single quote. So:
INSERT INTO table (name) VALUES ('O''Donnel');
Or you could do the obvious and use:
INSERT INTO table (name) VALUES ("O'Donnel");
But that doesn't work with, say Oracle. (mysql handles both quotes just fine)
-- paperCrane <Justin Patrin> -- Question Everything, Reject Nothing
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
