Req #57593 [Asn->Csd]: PDO_DBLIB does not implement nextRowset

Edit report at https://bugs.php.net/bug.php?id=57593&edit=1 ID: 57593 Updated by: ssufficool@php.net Reported by: urkle@php.net Summary: PDO_DBLIB does not implement nextRowset -Status: Assigned +Status: Closed Type: Feature/Change Request -Package: PDO_DBLIB +Package: *General Issues Operating System: CentOS 4 i386 PHP Version: 5.1.6 Assigned To: fmk Block user comment: N Private report: N New Comment: This bug has been fixed in SVN. Snapshots of the sources are packaged every three hours; this change will be in the next snapshot. You can grab the snapshot at http://snaps.php.net/. For Windows: http://windows.php.net/snapshots/ Thank you for the report, and for helping us make PHP better. Previous Comments: ------------------------------------------------------------------------ [2007-03-27 17:33:31] urkle@php.net Description: ------------ The php-mssql extension implements the nextRowset feature to advance to the next result set from a query. the current PDO_DBLIB does not provide this functionality. Reproduce code: --------------- $db = new PDO("dblib:host=host:1433;dbname=tempdb","user","pass"); $sql = <<<EOSQL SELECT 1; SELECT 2; SELECT 3; EOSQL; $res = $db->prepare($sql); $res->execute(); $row = $res->fetch(PDO::FETCH_NUM); while ($row = $res->fetch(PDO::FETCH_NUM) || ($res->nextRowset() && $row = $res->fetch(PDO::FETCH_NUM))) { echo $res->columnCount().':'; echo implode(',',$row)."\n"; } Expected result: ---------------- 1:1 1:2 1:3 Actual result: -------------- PDOStatement::nextRowset(): SQLSTATE[IM001]: Driver does not support this function: driver does not support multiple rowsets in nextresult-pdo.php on line 34 ------------------------------------------------------------------------ -- Edit this bug report at https://bugs.php.net/bug.php?id=57593&edit=1