|
|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
[2008-05-02 17:17 UTC] jrichardson at whisolutions dot com
Description: ------------ When passing XML as a parameter to a stored procedure; the mssql_query call now interrupts the "/" as a special character and produces a syntax error. If the slashes are removed from the XML the SP executes, but the XML parser inside the procedure will not be able to handle it. The same query will execute and return the proper results when executed from PHP5 or from mssql server directly. Reproduce code: --------------- $sSQL = "exec any_store_procedure NULL, NULL, '<status><id>5</id><id>6</id><id>8</id></status>', NULL, '01/01/2008', '04/29/2008', 25, 1"; $rc = mssql_query($sSQL,$Link_ID); $returnedrows = mssql_num_rows($rc); Expected result: ---------------- Depends on the Stored Procedure. But this will causes a syntax error. When running the same query in PHP4 or directly in mssql, it returns a result. Actual result: -------------- Warning: mssql_query() [function.mssql-query]: message: Line 3: Incorrect syntax near ','. (severity 15) in PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
|
|||||||||||||||||||||||||||||||||||||
Copyright © 2001-2024 The PHP GroupAll rights reserved. |
Last updated: Thu Apr 25 23:01:29 2024 UTC |
I'm not sure whenever this should be fixed on a php level, however as far I remember then MSSQL had an escape syntax like: SELECT col1_name FROM table1 WHERE col2_name LIKE '\/' {escape '\'} same syntax should apply to stored procedures. I'm marking this as bogus as I still don't think its a php level bug, but rather an SQL syntax issue :)