ID: 9798 User Update by: [EMAIL PROTECTED] Old-Status: Open Status: Duplicate Bug Type: MSSQL related Description: Non-select statements always return false Sorry, I see this is the same as bug #8402. 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. --------------------------------------------------------------------------- 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]