#22391 [NEW]: empty result sets returned incorrectly from mssql_execute

From: php at centaur dot mailshell dot com Operating system: Windows XP SP1 PHP version: 4.3.1 PHP Bug Type: MSSQL related Bug description: empty result sets returned incorrectly from mssql_execute Windows XP SP1 MSSQL 2000 Apache 2.0.44 PHP 4.3.1 Procedure definition: CREATE PROCEDURE foo @filter VARCHAR(255) AS SELECT id FROM bar WHERE baz LIKE @filter GO; Script: <?php $con = mssql_connect('localhost', $user, $password); mssql_select_db($dbname); $sp = mssql_init('foo'); mssql_bind($sp, '@filter', $filter, SQLVARCHAR); $result = mssql_execute($sp); print "[".$result."]\n"; // point A while ($row = mssql_fetch_object($result)) { // do something with $row }?> If there are no records in bar that satisfy $filter, [1] is printed at point A, and then mssql_fetch_object (and other functions that expect a resource ID, e.g. mssql_next_result) fails. -- Edit bug report at http://bugs.php.net/?id=22391&edit=1 -- Try a CVS snapshot: http://bugs.php.net/fix.php?id=22391&r=trysnapshot Fixed in CVS: http://bugs.php.net/fix.php?id=22391&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=22391&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=22391&r=needtrace Try newer version: http://bugs.php.net/fix.php?id=22391&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=22391&r=support Expected behavior: http://bugs.php.net/fix.php?id=22391&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=22391&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=22391&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=22391&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=22391&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=22391&r=dst IIS Stability: http://bugs.php.net/fix.php?id=22391&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=22391&r=gnused