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

Reply via email to