note 44009 added to function.mssql-execute

From: 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

« previous php.notes (#73097) next »