#22391 [Opn->Fbk]: empty result sets returned incorrectly from mssql_execute

From: Date: Wed, 26 Feb 2003 07:08:50 +0000
Subject: #22391 [Opn->Fbk]: empty result sets returned incorrectly from mssql_execute
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-34291@lists.php.net to get a copy of this message 
 ID:               22391
 Updated by:       sniper@php.net
 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

Thread (4 messages)

« previous php.bugs (#34291) next »