ID: 9798
Updated by: sniper
Reported By: [EMAIL PROTECTED]
Old-Status: Duplicate
Status: Closed
Bug Type: MSSQL related
Assigned To:
Comments:
Previous Comments:
---------------------------------------------------------------------------
[2001-03-16 17:03:11] [EMAIL PROTECTED]
Select statement do return true if they succeed. The output of this script is "yesno":
<?php
$db = mssql_connect("host", "user", "password");
$query = 'SELECT * FROM table_name';
$result = mssql_query($query);
echo ($result) ? "yes" : "no";
$query = 'UPDATE table_name SET field_name = "text"';
$result = mssql_query($query);
echo ($result) ? "yes" : "no";
?>
---------------------------------------------------------------------------
[2001-03-16 17:00:24] [EMAIL PROTECTED]
<?php
$db = mssql_connect("host", "user", "password");
$query = 'UPDATE table_name SET field_name = "text"';
$result = mssql_query($query);
echo ($result) ? "yes" : "no";
?>
The output is "no", even though the update has actually occurred. This did not happen
with 4.0.3pl1. It began happening when I upgraded to 4.0.4pl1.
I used the "(CGI binary plus server API versions for Apache, AOLserver, ISAPI and
NSAPI. MySQL support built-in, many extensions included, packaged as zip)" Win32
binary.
---------------------------------------------------------------------------
ATTENTION! Do NOT reply to this email!
To reply, use the web interface found at http://bugs.php.net/?id=9798&edit=2
--
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]