#31195 [Opn->Csd]: Query is correctly executed but FALSE is returned.
| From: | derick@php.net | Date: | Mon, 20 Dec 2004 10:26:12 +0000 |
| Subject: | #31195 [Opn->Csd]: Query is correctly executed but FALSE is returned. | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-70676@lists.php.net to get a copy of this message | ||
ID: 31195
Updated by: derick@php.net
Reported By: gtsakiris at dolnet dot gr
-Status: Open
+Status: Closed
Bug Type: MSSQL related
Operating System: Linux 2.4
PHP Version: 4.3.10
New Comment:
This bug has been fixed in CVS.
Snapshots of the sources are packaged every three hours; this change
will be in the next snapshot. You can grab the snapshot at
http://snaps.php.net/.
Thank you for the report, and for helping us make PHP better.
Previous Comments:
------------------------------------------------------------------------
[2004-12-20 10:59:33] gtsakiris at dolnet dot gr
Description:
------------
I upgraded php from 4.3.8 to 4.3.10 and then I noticed that the
mssql_query() function returned FALSE in queries that perform a write
in the database (or stored procedures that perform a write), even
though the queries were executed and the changes were written in the
tables.
I re-installed 4.3.8 again and I restored the expected behaviour of
mssql_query().
In SELECT queries nothing strange happened, I got a result handle as
expected.
Reproduce code:
---------------
$mssql = mssql_connect( "dbhost", "dbuser", "dbpass" );
mssql_select_db ("dbname" );
$res = mssql_query( "***a valid INSERT/UPDATE query***" );
if ($res === false)
{
echo "mssql_query returned false.\n";
}
else
{
echo "mssql_query returned true.\n";
}
Expected result:
----------------
If the query is correct, I would expect that true was returned.
Actual result:
--------------
Even though the query is correct I get the false message...
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=31195&edit=1