|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
[2006-10-15 18:11 UTC] wez@php.net
|
|||||||||||||||||||||||||||
Copyright © 2001-2025 The PHP GroupAll rights reserved. |
Last updated: Sat Nov 08 13:00:01 2025 UTC |
Description: ------------ If I try to open a 2nd statement handle against prepared statement on SQL 2000 and windows the 2nd attempt will fail. I can create a new object per statement and it is fine. The problem is only happening on prepared stored procedures. If I prepare a sql statement it seems fine. Reproduce code: --------------- $stmt = $dbh->prepare("exec pdo_test"); $stmt->execute(); echo $x . " " . var_dump($stmt->fetch()) . "<br>"; // $stmt = null; $stmt2 = $dbh->prepare("exec pdo_test"); $stmt2->execute(); echo $x . " " . var_dump($stmt2->fetch()) . "<br>"; Here is the sql to create SP: create procedure pdo_test as select 'Hello' msg Expected result: ---------------- Hoping both statements would print the array with Hello in it Actual result: -------------- The second result will print false. If I uncomment the $stmt = null; then everything works great.