#36771 [Opn->Fbk]: Unable to set parameter (with correct names)

ID: 36771 Updated by: jani@php.net Reported By: jwagoner at seminolesheriff dot org -Status: Open +Status: Feedback Bug Type: MSSQL related Operating System: Windows XP Pro PHP Version: 5.1.2 New Comment: Please try using this CVS snapshot: http://snaps.php.net/php5.2-latest.tar.gz For Windows (zip): http://snaps.php.net/win32/php5.2-win32-latest.zip For Windows (installer): http://snaps.php.net/win32/php5.2-win32-installer-latest.msi Hint: You can install it on your own computer and run the script there using the command line binary (php). Previous Comments: ------------------------------------------------------------------------ [2006-03-17 15:00:01] jwagoner at seminolesheriff dot org 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 this bug report at http://bugs.php.net/?id=36771&edit=1