|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
[2009-04-25 14:39 UTC] jani@php.net
[2009-05-03 01:00 UTC] php-bugs at lists dot php dot net
[2023-03-08 21:23 UTC] tbare83 at gmail dot com
|
|||||||||||||||||||||||||||||||||||||
Copyright © 2001-2025 The PHP GroupAll rights reserved. |
Last updated: Wed Dec 03 18:00:01 2025 UTC |
Description: ------------ If I call a stored proced that creates a temp table and inserts values and returns a record set then pdo_odbc gets confused by the multiple record sets unless I set nocount to on. I am doing this against a MS_SQL 2000 sp4 database Reproduce code: --------------- Here is a sample sql sp: alter procedure pdo_test as CREATE TABLE #tmptbl ( ItemId int ) insert into #tmptbl VALUES (1) select 'Hello' msg Here is sample php: $stmt = $dbh->prepare("exec pdo_test"); $stmt->execute(); echo "Number of columns: " . $stmt->columnCount() . "<br>"; $row = $stmt->fetch(); echo "Value of column: " . var_dump($row) . "<br>"; $stmt->nextRowset(); echo "Number of columns: " . $stmt->columnCount() . "<br>"; $row = $stmt->fetch(); echo "Value of column: " . var_dump($row) . "<br>"; Expected result: ---------------- with the other db layers it is ignoring the first record set. I think it is proper that pdo_odbc sees the number of records modified but it does not return any data and I can not navigate to the actual dataset Actual result: -------------- empty dataset If I add 'set nocount on' to the SP then everything works fine alter procedure pdo_test as set nocount on CREATE TABLE #tmptbl ( ItemId int ) insert into #tmptbl VALUES (1) select 'Hello' msg