ID: 40901 Updated by: [EMAIL PROTECTED] Reported By: lh at moranti dot com -Status: Open +Status: Feedback Bug Type: MSSQL related Operating System: ubuntu PHP Version: 5.2.1 New Comment:
Thank you for this bug report. To properly diagnose the problem, we need a short but complete example script to be able to reproduce this bug ourselves. A proper reproducing script starts with <?php and ends with ?>, is max. 10-20 lines long and does not require any external resources such as databases, etc. If the script requires a database to demonstrate the issue, please make sure it creates all necessary tables, stored procedures etc. Please avoid embedding huge scripts into the report. Previous Comments: ------------------------------------------------------------------------ [2007-03-23 10:29:27] lh at moranti dot com Description: ------------ I have a problem executing a stored procedure. It fails on my ubuntu installation with php 5.2.1 but when i run it with php 5.1.6 no problem. Reproduce code: --------------- mssql_select_db("dbname", $conn); $sp = mssql_init("procedurename", $conn); // stored proc name $compId=1000; $SessionId = substr(session_id(),0,8); mssql_bind($sp, "@CompID",$compId,SQLVARCHAR); mssql_bind($sp, "@SessionID",$SessionId,SQLVARCHAR); mssql_bind($sp, "@BasketAmount",$BasketAmount,SQLVARCHAR,TRUE); mssql_bind($sp, "@BasketTotalItem",$BasketTotalItem,SQLVARCHAR,TRUE); $query = mssql_execute($sp) or die("could not perform insert"); Actual result: -------------- Warning: mssql_execute() [function.mssql-execute]: stored procedure execution failed in /home/www/sitename/test_init.php on line 14 ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=40901&edit=1