Page 1 of 1

problem with special characters in stored procedure

Posted: Wed Nov 09, 2005 12:35 am
by annahleen
Hello everyone.

I encountered problems in calling MS SQL stored procedures with parameters that contains special characters.
I already user the str_replace function.

Error Message:

Warning: mssql_query() [function.mssql-query]: message: Line 1: Incorrect syntax near '\'. (severity 15) in /www/htdocs/x3m/Web/LoginConfirm.php on line 15

Warning: mssql_query() [function.mssql-query]: Query failed in /www/htdocs/x3m/Web/LoginConfirm.php on line 15

Warning: mssql_fetch_assoc(): supplied argument is not a valid MS SQL-result resource in /www/htdocs/x3m/Web/LoginConfirm.php on line 16


Please help. Thank you.

Posted: Wed Nov 09, 2005 1:16 am
by feyd
you have an error in your query string. We can't help further without seeing what you're doing. What we should see is the exact end result string being sent to MSSQL (all varibles parsed and whatnot)