#36771 [NEW]: Unable to set parameter (with correct names)

From: jwagoner at seminolesheriff dot org Operating system: Windows XP Pro PHP version: 5.1.2 PHP Bug Type: MSSQL related Bug description: Unable to set parameter (with correct names) Description: ------------ I can't select the version I'm using, which is 5.1.1, and for the record, I cannot upgrade the server to a newer version. As in, the bosses say so, so don't say to upgrade -- If it's confirmed fixed in a newer version, I think I can get them to do so. Assuming a DB connection already. $groupKeys is a long list of names separated by commas. I cannot post the exact stored procedure, but it looks like: CREATE procedure dbo.proc_select_AllUserPerms @groupKeys varchar(8000) as Lots of stuff. GO Looks the same to me. I would like to point out, using a query 'exec dbo.proc_select_AllUserPerms \'' . $groupKeys . '\'' works fine, which is what I'll be forced to use until this is fixed. Reproduce code: --------------- // assuming DB connection already $dbConn = mssql_init('proc_select_AllUserPerms'); mssql_bind($dbConn, '@groupKeys', $groupKeys, SQLVARCHAR, false, false, 8000); $result = mssql_execute($dbConn); Expected result: ---------------- It work. Actual result: -------------- Unable to set parameter -- Edit bug report at http://bugs.php.net/?id=36771&edit=1 -- Try a CVS snapshot (PHP 4.4): http://bugs.php.net/fix.php?id=36771&r=trysnapshot44 Try a CVS snapshot (PHP 5.1): http://bugs.php.net/fix.php?id=36771&r=trysnapshot51 Try a CVS snapshot (PHP 6.0): http://bugs.php.net/fix.php?id=36771&r=trysnapshot60 Fixed in CVS: http://bugs.php.net/fix.php?id=36771&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=36771&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=36771&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=36771&r=needscript Try newer version: http://bugs.php.net/fix.php?id=36771&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=36771&r=support Expected behavior: http://bugs.php.net/fix.php?id=36771&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=36771&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=36771&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=36771&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=36771&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=36771&r=dst IIS Stability: http://bugs.php.net/fix.php?id=36771&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=36771&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=36771&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=36771&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=36771&r=mysqlcfg