From: bies22 at poczta dot onet dot pl Operating system: windows PHP version: 5.2.9 PHP Bug Type: MSSQL related Bug description: summary
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 bug report at http://bugs.php.net/?id=47944&edit=1 -- Try a CVS snapshot (PHP 5.2): http://bugs.php.net/fix.php?id=47944&r=trysnapshot52 Try a CVS snapshot (PHP 5.3): http://bugs.php.net/fix.php?id=47944&r=trysnapshot53 Try a CVS snapshot (PHP 6.0): http://bugs.php.net/fix.php?id=47944&r=trysnapshot60 Fixed in CVS: http://bugs.php.net/fix.php?id=47944&r=fixedcvs Fixed in CVS and need be documented: http://bugs.php.net/fix.php?id=47944&r=needdocs Fixed in release: http://bugs.php.net/fix.php?id=47944&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=47944&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=47944&r=needscript Try newer version: http://bugs.php.net/fix.php?id=47944&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=47944&r=support Expected behavior: http://bugs.php.net/fix.php?id=47944&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=47944&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=47944&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=47944&r=globals PHP 4 support discontinued: http://bugs.php.net/fix.php?id=47944&r=php4 Daylight Savings: http://bugs.php.net/fix.php?id=47944&r=dst IIS Stability: http://bugs.php.net/fix.php?id=47944&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=47944&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=47944&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=47944&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=47944&r=mysqlcfg
