note 106257 added to function.mssql-execute

SUBJECT: No OUTPUT parameter recieved on store procedure call. If you call a store procedure who binds data to an OUTPUT parameter on a SQL Server 7 or later no response will be produced, or an error perhaps. From the Free TDS documentation: Output Parameters I'm not getting my output parameters returned, but I seem to be doing everything right! That's not a question! Microsoft SQL Server 7 with SP3, and later versions, quietly changed (which is to say, broke) how they respond to queries that execute stored procedures with output parameters. Earlier servers let you send a query like EXECUTE A @P OUTPUT and fetch the output parameter as a special result row (technique varying by library). Newer servers simply don't send back that data. To elicit output parameters from them, you have to use the RPC protocols such as the DB-Library dbrpcparam. ---- Server IP: 69.147.83.197 Probable Submitter: 181.28.132.111 ---- Manual Page -- http://www.php.net/manual/en/function.mssql-execute.php Edit -- https://master.php.net/note/edit/106257 Del: integrated -- https://master.php.net/note/delete/106257/integrated Del: useless -- https://master.php.net/note/delete/106257/useless Del: bad code -- https://master.php.net/note/delete/106257/bad+code Del: spam -- https://master.php.net/note/delete/106257/spam Del: non-english -- https://master.php.net/note/delete/106257/non-english Del: in docs -- https://master.php.net/note/delete/106257/in+docs Del: other reasons-- https://master.php.net/note/delete/106257 Reject -- https://master.php.net/note/reject/106257 Search -- https://master.php.net/manage/user-notes.php