note 32295 added to function.mssql-query
| From: | Kelsey at rack1 dot php dot net | Date: | Thu, 22 May 2003 21:43:38 +0000 |
| Subject: | note 32295 added to function.mssql-query | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-48844@lists.php.net to get a copy of this message | ||
MS SQL escapes single ' characters with another ' character. So you may want to look at
the magic_quote_sybase configuration option that will automatically turn your ' characters into
''
If you use the default magic_quotes_gpc = on, then your ' characters will be escaped as \'
and your query will not work.
Note that if you use magic_quote_sybase, your " \ and NULs will have to be escaped manually.
Isn't MS SQL FUN!
----
Manual Page -- http://www.php.net/manual/en/function.mssql-query.php
Edit Note -- http://master.php.net/manage/user-notes.php?action=edit+32295
Delete Note -- http://master.php.net/manage/user-notes.php?action=delete+32295&report=yes
Reject Note -- http://master.php.net/manage/user-notes.php?action=reject+32295&report=yes