#47944 [NEW]: summary
| From: | bies22 at poczta dot onet dot pl | Date: | Fri, 10 Apr 2009 08:27:00 +0000 |
| Subject: | #47944 [NEW]: summary | ||
| Groups: | php.bugs | ||
| Request: | Send a blank email to php-bugs+get-135708@lists.php.net to get a copy of this message | ||
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