problem with special characters in stored procedure

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
annahleen
Forum Newbie
Posts: 1
Joined: Wed Nov 09, 2005 12:27 am

problem with special characters in stored procedure

Post 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.
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post 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)
Post Reply