ID: 22391 Updated by: [EMAIL PROTECTED] Reported By: php at centaur dot mailshell dot com -Status: Open +Status: Closed Bug Type: MSSQL related Operating System: Windows XP SP1 PHP Version: 4.3.1 New Comment:
This bug has been fixed in CVS. In case this was a PHP problem, snapshots of the sources are packaged every three hours; this change will be in the next snapshot. You can grab the snapshot at http://snaps.php.net/. In case this was a documentation problem, the fix will show up soon at http://www.php.net/manual/. In case this was a PHP.net website problem, the change will show up on the PHP.net site and on the mirror sites in short time. Thank you for the report, and for helping us make PHP better. User reports the problem is fixed in snapshot. Previous Comments: ------------------------------------------------------------------------ [2003-03-06 05:02:37] php at centaur dot mailshell dot com Seems fixed. ------------------------------------------------------------------------ [2003-02-26 01:08:49] [EMAIL PROTECTED] 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 ------------------------------------------------------------------------ [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
