note 104302 deleted from function.mssql-execute by danbrown

From: Date: Tue, 07 Jun 2011 17:31:27 +0000
Subject: note 104302 deleted from function.mssql-execute by danbrown
References: 1  Groups: php.notes 
Request: Send a blank email to php-notes+get-180316@lists.php.net to get a copy of this message
Note Submitter: immanuel at ftfdesigns dot com ---- 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); //... ?>

« previous php.notes (#180316) next »