php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #36771 Unable to set parameter (with correct names)
Submitted: 2006-03-17 15:00 UTC Modified: 2007-07-17 01:00 UTC
Votes:1
Avg. Score:3.0 ± 0.0
Reproduced:1 of 1 (100.0%)
Same Version:0 (0.0%)
Same OS:0 (0.0%)
From: jwagoner at seminolesheriff dot org Assigned:
Status: No Feedback Package: MSSQL related
PHP Version: 5.1.2 OS: Windows XP Pro
Private report: No CVE-ID: None
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: jwagoner at seminolesheriff dot org
New email:
PHP Version: OS:

 

 [2006-03-17 15:00 UTC] 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

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2007-07-09 13:33 UTC] jani@php.net
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).
 [2007-07-17 01:00 UTC] php-bugs at lists dot php dot net
No feedback was provided for this bug for over a week, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Sat Dec 21 17:01:58 2024 UTC