note 87159 added to function.db2-next-result
| From: | matthewv at ca dot ibm dot com | Date: | Sat, 22 Nov 2008 00:35:32 +0000 |
| Subject: | note 87159 added to function.db2-next-result | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-146816@lists.php.net to get a copy of this message | ||
Some not so obvious but imported notes:
1) You must always use the original statement return when fetching the next result set.
2) You can not remove a reference to a previous result set if you wish to access another result set.
----------------WILL NOT WORK-------------------------
<?php
$originalStatementReturn = db2_exec($conn, 'CALL multiResults()');
$firstResultHolder = db2_next_result($originalStatementReturn);
$secondResultHolder = db2_next_result($firstResultHolder);
if ($secondResultHolder) {
while ($row = db2_fetch_array($secondResultHolder)) {
print_r($row);
}
}
?>
-----------------------------------------------------------------
----------------WILL NOT WORK-------------------------
<?php
$originalStatementReturn = db2_exec($conn, 'CALL multiResults()');
$resultHolder = db2_next_result($originalStatementReturn);
$resultHolder = db2_next_result($originalStatementReturn);
if ($resultHolder) {
while ($row = db2_fetch_array($resultHolder)) {
print_r($row);
}
}
?>
-----------------------------------------------------------------
----------------WILL WORK--------------------------------
<?php
$originalStatementReturn = db2_exec($conn, 'CALL multiResults()');
$firstResultHolder = db2_next_result($originalStatementReturn);
$secondResultHolder = db2_next_result($originalStatementReturn);
if ($secondResultHolder) {
while ($row = db2_fetch_array($secondResultHolder)) {
print_r($row);
}
}
?>
-----------------------------------------------------------------
----
Server IP: 216.235.15.211
Probable Submitter: 199.246.40.54
----
Manual Page -- http://www.php.net/manual/en/function.db2-next-result.php
Edit -- https://master.php.net/note/edit/87159
Del: integrated -- https://master.php.net/note/delete/87159/integrated
Del: useless -- https://master.php.net/note/delete/87159/useless
Del: bad code -- https://master.php.net/note/delete/87159/bad+code
Del: spam -- https://master.php.net/note/delete/87159/spam
Del: non-english -- https://master.php.net/note/delete/87159/non-english
Del: in docs -- https://master.php.net/note/delete/87159/in+docs
Del: other reasons-- https://master.php.net/note/delete/87159
Reject -- https://master.php.net/note/reject/87159
Search -- https://master.php.net/manage/user-notes.php