I was still having the same problems even with PDO, but doing my own replace:
$body = str_replace("'", "\"", $body);
fixed the problem. Thanks again!
Regards,
Bruce
>>> Richard Davey <[EMAIL PROTECTED]> 5/07/2007 12:34:29 p.m. >>>
Hi Bruce,
Thursday, July 5, 2007, 1:26:01 AM, you wrote:
> Thanks. Sorry, I should have mentioned I'm using MS Sql Server and
> I don't see a mssql equivalent to that function.
MSSQL treats '' as an escaped ', not \' like MySQL does.
So you can't addslashes it. Perform your own ' to '' conversion.
Also check to see if you've got RUNTIME Magic Quotes on, because that
will auto-escape data (\'), which is pointless for MSSQL.
Cheers,
Rich
--
Zend Certified Engineer
http://www.corephp.co.uk
"Never trust a computer you can't throw out of a window"
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
