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
