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]