#32189 [NEW]: mssql_query returns false

From: Date: Fri, 04 Mar 2005 10:20:41 +0000
Subject: #32189 [NEW]: mssql_query returns false
Groups: php.bugs 
Request: Send a blank email to php-bugs+get-74822@lists.php.net to get a copy of this message
From: nramsbottom at hotmail dot com Operating system: Windows 2000/IIS5 PHP version: 4.3.10 PHP Bug Type: MSSQL related Bug description: mssql_query returns false Description: ------------ This is a continuation of bug 31195 <http://bugs.php.net/bug.php?id=31195>. This bug still occurs when using the ISAPI module under IIS5, but appears to be fixed when running the CGI version. I am aware that this was corrected on the 20th December 2004, but only in the CGI - it occurs with the 15th December 2004 4.3.10 release and the 2nd March 2005 snapshot! Reproduce code: --------------- $mssql = mssql_connect( "<dbhost>", "<dblogin>", "<dbpwd>" ); mssql_select_db ("<dbname>" ); $res = mssql_query( "update cb_agent_details set username = 'neil' where agentid=1" ); if ($res === false) { echo "mssql_query returned false.\n"; } else { echo "mssql_query returned true.\n"; } Expected result: ---------------- The query should succeed and the positive message displayed. Actual result: -------------- This query succeeds (data is changed on the server) but the negative message is displayed. -- Edit bug report at http://bugs.php.net/?id=32189&edit=1 -- Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=32189&r=trysnapshot4 Try a CVS snapshot (php5.0): http://bugs.php.net/fix.php?id=32189&r=trysnapshot50 Try a CVS snapshot (php5.1): http://bugs.php.net/fix.php?id=32189&r=trysnapshot51 Fixed in CVS: http://bugs.php.net/fix.php?id=32189&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=32189&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=32189&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=32189&r=needscript Try newer version: http://bugs.php.net/fix.php?id=32189&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=32189&r=support Expected behavior: http://bugs.php.net/fix.php?id=32189&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=32189&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=32189&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=32189&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=32189&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=32189&r=dst IIS Stability: http://bugs.php.net/fix.php?id=32189&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=32189&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=32189&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=32189&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=32189&r=mysqlcfg

« previous php.bugs (#74822) next »