#43707 [Opn]: PDOStatement->nextRowset() doesn't work
| From: | lunter at interia dot pl | Date: | Sun, 30 Dec 2007 12:36:03 +0000 |
| Subject: | #43707 [Opn]: PDOStatement->nextRowset() doesn't work | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-120939@lists.php.net to get a copy of this message | ||
ID: 43707
User updated by: lunter at interia dot pl
Reported By: lunter at interia dot pl
Status: Open
Bug Type: PDO related
Operating System: WinXP
PHP Version: 5.3CVS-2007-12-29 (CVS)
New Comment:
This is rather important bug, becouse it doesn't permite to full use
stored procedured by MySQL, MS SQL etc. programmers.
Previous Comments:
------------------------------------------------------------------------
[2007-12-29 20:44:11] lunter at interia dot pl
Description:
------------
PDOStatement->nextRowset() doesn't work
Reproduce code:
---------------
<?
$h=new PDO('mysql:host=localhost;dbname=root','root','root');
// $q=$h->query('CALL some_proc()');
$q=$h->query('SELECT 1 AS col;SELECT 2 AS col;');
$r=$q->fetchAll(PDO::FETCH_ASSOC);
print_r($r);
$q->nextRowset();
$r=$q->fetchAll(PDO::FETCH_ASSOC);
print_r($r);
?>
Expected result:
----------------
Array ( [0] => Array ( [col] => 1 ) )
Array ( [0] => Array ( [col] => 2 ) )
Actual result:
--------------
Array ( [0] => Array ( [col] => 1 ) )
Array ( )
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=43707&edit=1