From: webmaster at groupphotographers dot com Operating system: Windows Server 2003 PHP version: 4.3.4 PHP Bug Type: MSSQL related Bug description: mssql_bind not working with stored proc return value
Description: ------------ mssql_bind function does not seem to be working when trying to bind return value (RETVAL) from stored procedure. Reproduce code: --------------- // OPEN CONNECTION, ETC... $customer_id = <INTEGER GOES HERE>; $subject_id = <INTEGER GOES HERE>; mssql_bind($query, "RETVAL", &$retval, SQLINT1); mssql_bind($query, "@iCustomerID", &$customer_id, SQLINT4); mssql_bind($query, "@iSubjectID", &$subject_id, SQLINT4); $result = mssql_execute($query); mssql_close($dbc); Expected result: ---------------- I expect to have $retval equall something else than '0' in many cases--but it always equalls '0'. The same code gives the expected results in PHP 4.2.1 on MS Windows Server. -- Edit bug report at http://bugs.php.net/?id=27615&edit=1 -- Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=27615&r=trysnapshot4 Try a CVS snapshot (php5): http://bugs.php.net/fix.php?id=27615&r=trysnapshot5 Fixed in CVS: http://bugs.php.net/fix.php?id=27615&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=27615&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=27615&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=27615&r=needscript Try newer version: http://bugs.php.net/fix.php?id=27615&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=27615&r=support Expected behavior: http://bugs.php.net/fix.php?id=27615&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=27615&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=27615&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=27615&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=27615&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=27615&r=dst IIS Stability: http://bugs.php.net/fix.php?id=27615&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=27615&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=27615&r=float