RE: [PHP-DB] MSSQL error codes :/
| From: | Mark Roedel | Date: | Mon, 01 Oct 2001 18:48:53 +0000 |
| Subject: | RE: [PHP-DB] MSSQL error codes :/ | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-12886@lists.php.net to get a copy of this message | ||
> -----Original Message-----
> From: Charles Butler [mailto:cbutler@jtron.net]
> Sent: Monday, October 01, 2001 12:56 PM
> To: php-db@lists.php.net
> Subject: [PHP-DB] MSSQL error codes :/
>
>
> I'm getting funky error codes, even with doing
> addslashes($variable); but its not escaping the
> 's, I have even resorted to str_replace() and
> still nothing....
>
> below is error output.
> Warning: MS SQL message: Line 1: Incorrect syntax near 'b'.
> (severity 15) in
> \jtron\home\admin\functions.php on line 82
>
> Warning: MS SQL message: Unclosed quotation mark before
> the character string ')'. (severity 15) in
> \jtron\home\admin\functions.php on line 82
>
> Warning: MS SQL: Query failed in
> \jtron\home\admin\functions.php on line
> 82
I posted in another thread earlier today that the Sybase database engine
likes to have a single quote escaped by another single quote, not by a
slash.
Perhaps this is a case where MSSQL is showing its Sybase roots...do you
get the same errors if you change \' to ''?
---
Mark Roedel | "Blessed is he who has learned to laugh
Systems Programmer | at himself, for he shall never cease
LeTourneau University | to be entertained."
Longview, Texas, USA | -- John Powell