note 104302 added to function.mssql-execute

From: Date: Tue, 07 Jun 2011 17:29:09 +0000
Subject: note 104302 added to function.mssql-execute
Groups: php.notes 
Request: Send a blank email to php-notes+get-180315@lists.php.net to get a copy of this message
Thank you berk0081 ! FURTHER OBSERVATION: This "stored procedure execution failed" error in relation to execution on Linux server does NOT only occur when trying to run a mssql_execute right after running a "simple" mssql_query. It will also show up when you run two mssql_execute back to back. Using mssql_free_statement(), you will need to release previous statement before executing another. <?php //... // Execute first procedure $proc = mssql_init('some_proc', $conn); mssql_bind($proc, '@ContactID', $cid, SQLINT4...; $proc_result = mssql_execute($proc); // Release the statement resource mssql_free_statement($proc); // Execute next procedure $proc_two = mssql_init('some_proc', $conn); $proc_result = mssql_execute($proc_two); //... ?> ---- Server IP: 69.147.83.197 Probable Submitter: 68.147.237.185 ---- Manual Page -- http://www.php.net/manual/en/function.mssql-execute.php Edit -- https://master.php.net/note/edit/104302 Del: integrated -- https://master.php.net/note/delete/104302/integrated Del: useless -- https://master.php.net/note/delete/104302/useless Del: bad code -- https://master.php.net/note/delete/104302/bad+code Del: spam -- https://master.php.net/note/delete/104302/spam Del: non-english -- https://master.php.net/note/delete/104302/non-english Del: in docs -- https://master.php.net/note/delete/104302/in+docs Del: other reasons-- https://master.php.net/note/delete/104302 Reject -- https://master.php.net/note/reject/104302 Search -- https://master.php.net/manage/user-notes.php

« previous php.notes (#180315) next »