ID: 22391 Updated by: [EMAIL PROTECTED] Reported By: php at centaur dot mailshell dot com -Status: Open +Status: Feedback Bug Type: MSSQL related Operating System: Windows XP SP1 PHP Version: 4.3.1 New Comment:
Please try using this CVS snapshot: http://snaps.php.net/php4-STABLE-latest.tar.gz For Windows: http://snaps.php.net/win32/php4-win32-STABLE-latest.zip Previous Comments: ------------------------------------------------------------------------ [2003-02-24 05:28:30] php at centaur dot mailshell dot com 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 this bug report at http://bugs.php.net/?id=22391&edit=1
