ID: 47944 Updated by: j...@php.net Reported By: bies22 at poczta dot onet dot pl -Status: Open +Status: Feedback Bug Type: MSSQL related Operating System: windows PHP Version: 5.2.9 New Comment:
Need proper summary and proper reproduce script. Neither compute right now.. Previous Comments: ------------------------------------------------------------------------ [2009-04-10 08:27:00] bies22 at poczta dot onet dot pl Description: ------------ When I execute SQL with function mssql_query, after 3 execute is error. The same SQL command executed with function odbc_do is correct. Reproduce code: --------------- $sql = "INSERT INTO cdn.EL_SS_ZSElemTmp VALUES (7,48,'PCW Okno Zendow Kolor x1',1.000,535.93,535.93,'A','ZLC/9/02700-TEST','ZLC/9/02700-TEST','3392/2009','14')"; $rst_mssql = mssql_query($sql,$conn); Actual result: -------------- Warning: mssql_query() [function.mssql-query]: message: Incorrect syntax near '&'. (severity 15) Warning: mssql_query() [function.mssql-query]: message: Unclosed quotation mark after the character string ')'. (severity 15) Warning: mssql_query() [function.mssql-query]: Query failed ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=47944&edit=1