#35920 [Opn->Fbk]: mssql_bind(): Unable to set parameter

From: Date: Fri, 06 Jan 2006 15:48:21 +0000
Subject: #35920 [Opn->Fbk]: mssql_bind(): Unable to set parameter
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-91630@lists.php.net to get a copy of this message 
 ID:               35920
 Updated by:       sniper@php.net
 Reported By:      eaboyle at gemstonewd dot com
-Status:           Open
+Status:           Feedback
 Bug Type:         MSSQL related
 Operating System: window XP pro
 PHP Version:      4.4.1
 New Comment:

Please try using this CVS snapshot:

  http://snaps.php.net/php5.1-latest.tar.gz
 
For Windows:
 
  http://snaps.php.net/win32/php5.1-win32-latest.zip




Previous Comments:
------------------------------------------------------------------------

[2006-01-06 16:19:06] eaboyle at gemstonewd dot com

Description:
------------
I'm trying to get output from an mssql stored procedure.

I get "mssql_bind(): Unable to set parameter warning on line  6. 

I have "allow_call_time_pass_reference = On" in my php.ini.



Reproduce code:
---------------
1 $db = new clsDBsqlRags();
2 $db->connect();
3 $stmt=mssql_init("sp_NEXT_ACT_NUM ",$db->Link_ID); 
4 $act_base = 1;
5 mssql_bind($stmt,"@ACT_BASE", $act_base, SQLINT4);
6 mssql_bind($stmt, "RTNVAL", &$act_num, SQLINT4);
7
8 $result=mssql_execute($stmt, FALSE);

Stored procedure:



CREATE PROCEDURE sp_NEXT_ACT_NUM     
  @ACT_BASE int
AS

  DECLARE 
    @Act int                 --FETCHED CLIENT.ACCOUNT VALUE

  --GET SET OF ACCOUTS FROM CLIENT TABLE
  DECLARE Crsr_Act CURSOR
  FOR 
    SELECT C.ACCOUNT
    FROM CLIENT C
    WHERE C.ACCOUNT >= @ACT_BASE
    ORDER BY ACCOUNT

  OPEN Crsr_Act

  FETCH Crsr_Act INTO @Act

  --TRAVERSE Crsr_Act
  WHILE (@@FETCH_STATUS = 0)
  BEGIN

    IF @ACT_BASE < @Act 
      BREAK
    ELSE IF @ACT_BASE = @Act
      SELECT @ACT_BASE = @ACT_BASE + 1

    FETCH Crsr_Act INTO @Act

  END

  CLOSE Crsr_Act
  DEALLOCATE Crsr_Act

  RETURN @ACT_BASE


GO


Expected result:
----------------
expect $act_num to be set to the return value of the mssql stored
procedure.

Actual result:
--------------
mssql_bind(): Unable to set parameter warning on line  6. 


------------------------------------------------------------------------


-- 
Edit this bug report at http://bugs.php.net/?id=35920&edit=1

Thread (6 messages)

« previous php.bugs (#91630) next »