note 44009 added to function.mssql-execute
| From: | SQL dot User at Yandex dot Ru | Date: | Mon, 12 Jul 2004 13:38:07 +0000 |
| Subject: | note 44009 added to function.mssql-execute | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-73097@lists.php.net to get a copy of this message | ||
To receive output parameter from the procedure which returns one or several recordsets, try this
code:
...
mssql_bind($my_procedure, "@OutputParameter", SQLVARCHAR, true);
$result = mssql_execute($my_procedure);
while(mssql_next_recordset($result)) {
## do something
}
after listing last recordset output parameter will be available (strange...).
If you do not need output recordsets, just parameters, try this:
mssql_bind($my_procedure, "@OutputParameter", SQLVARCHAR, true);
$result = mssql_execute($my_procedure, true);
P.S. Tested on PHP 4.3.5.
----
Manual Page -- http://www.php.net/manual/en/function.mssql-execute.php
Edit -- http://master.php.net/manage/user-notes.php?action=edit+44009
Delete -- http://master.php.net/manage/user-notes.php?action=delete+44009&report=yes
Reject -- http://master.php.net/manage/user-notes.php?action=reject+44009&report=yes
Search -- http://master.php.net/manage/user-notes.php