note 68398 added to ref.pdo
| From: | paulius_k at yahoo dot com | Date: | Tue, 25 Jul 2006 15:42:58 +0000 |
| Subject: | note 68398 added to ref.pdo | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-115162@lists.php.net to get a copy of this message | ||
If you need to get Output variable from MSSQL stored procedure, try this :
-- PROCEDURE
CREATE PROCEDURE spReturn_Int @err int OUTPUT
AS
SET @err = 11
GO
$sth = $dbh->prepare("EXECUTE spReturn_Int ?");
$sth->bindParam(1, $return_value, PDO::PARAM_INT|PDO::PARAM_INPUT_OUTPUT);
$sth->execute();
print "procedure returned $return_value\n";
----
Server IP: 64.71.164.2
Probable Submitter: 216.146.90.3
----
X-Spam-Status: No, hits=3.8 required=5.0 tests=DATE_MISSING,FROM_NO_LOWER,
UPPERCASE_25_50 autolearn=no version=2.64
----
Manual Page -- http://www.php.net/manual/en/ref.pdo.php
Edit -- http://master.php.net/note/edit/68398
Del: integrated -- http://master.php.net/note/delete/68398/integrated
Del: useless -- http://master.php.net/note/delete/68398/useless
Del: bad code -- http://master.php.net/note/delete/68398/bad+code
Del: spam -- http://master.php.net/note/delete/68398/spam
Del: non-english -- http://master.php.net/note/delete/68398/non-english
Del: in docs -- http://master.php.net/note/delete/68398/in+docs
Del: other reasons-- http://master.php.net/note/delete/68398
Reject -- http://master.php.net/note/reject/68398
Search -- http://master.php.net/manage/user-notes.php