problem with special characters in stored procedure
Posted: Wed Nov 09, 2005 12:35 am
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.
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.