Bug #17601: Stored Procedure Fetch Array
| From: | dwhitaker at dgsystems dot com | Date: | Tue, 04 Jun 2002 21:37:22 +0000 |
| Subject: | Bug #17601: Stored Procedure Fetch Array | ||
| Groups: | php.bugs | ||
| Request: | Send a blank email to php-bugs+get-9500@lists.php.net to get a copy of this message | ||
From: dwhitaker@dgsystems.com
Operating system: Solaris
PHP version: 4.1.2
PHP Bug Type: Sybase-ct (ctlib) related
Bug description: Stored Procedure Fetch Array
PHP 4.1.2
Solaris
Sybase
We are not able to return more than one row when doing a
sybase_fetch_array on a stored procedure.
Here is an example of my code:
$query = sybase_query("EXEC ops_select_mfr @mf_id=$mf_idx",$db);
while ($row = sybase_fetch_array($query)) {
$mf_id = $row['mf_id'];
$display .= "<tr><td>$mf_id</td></tr>";
}
This is echoed in a table, of course.
The first row is returned but nothing else.
We have checked our data using SQL Advantage so there are multiple rows.
Does sybase_fetch_array work correctly? If so what are we doing wrong?
--
Edit bug report at http://bugs.php.net/?id=17601&edit=1
--
Fixed in CVS: http://bugs.php.net/fix.php?id=17601&r=fixedcvs
Fixed in release: http://bugs.php.net/fix.php?id=17601&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=17601&r=needtrace
Try newer version: http://bugs.php.net/fix.php?id=17601&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=17601&r=support
Expected behavior: http://bugs.php.net/fix.php?id=17601&r=notwrong
Not enough info: http://bugs.php.net/fix.php?id=17601&r=notenoughinfo
Submitted twice: http://bugs.php.net/fix.php?id=17601&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=17601&r=globals