note 109783 modified in pdostatement.bindparam by danbrown
| From: | danbrown@php.net | Date: | Fri, 31 Aug 2012 15:49:45 +0000 |
| Subject: | note 109783 modified in pdostatement.bindparam by danbrown | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-190341@lists.php.net to get a copy of this message | ||
SQL Server 2008 R2 If this was in the documentation, I
didn't stumble across it. When using bound output parameters with a stored procedure, the
output parameters are updated AFTER the LAST rowset has been
processed. If your stored procedure does not return any rowsets
(no SELECT statements) then you are set, your output parameters will be ready as soon as the stored
procedure is processed. Otherwise you need to process the rows,
and then: <?php $stmt->nextRowset();
?> Once that is done for each returning rowset you will
have access to the output parameters.
--was--
SQL Server 2008 R2
If this was in the documentation, I didn't stumble across it. When using bound output
parameters with a stored procedure, the output parameters are updated AFTER the LAST rowset has been
processed.
If your stored procedure does not return any rowsets (no SELECT statements) then you are set, your
output parameters will be ready as soon as the stored procedure is processed.
Otherwise you need to process the rows, and then:
$stmt->nextRowset();
Once that is done for each returning rowset you will have access to the output parameters.
http://php.net/manual/en/pdostatement.bindparam.php