ID: 9798
User Update by: [EMAIL PROTECTED]
Status: Open
Bug Type: MSSQL related
Description: Non-select statements always return false
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";
?>
Previous Comments:
---------------------------------------------------------------------------
[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.
---------------------------------------------------------------------------
Full Bug description available at: http://bugs.php.net/?id=9798
--
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]
