#22294 [Com]: Output parameter is not populated

[php at centaur dot mailshel dot com]

 ID:               22294
 Comment by:       php at centaur dot mailshel dot com
 Reported By:      rajesh dot gala at cgi dot com
 Status:           Open
 Bug Type:         MSSQL related
 Operating System: win32
 PHP Version:      4.3.1
 New Comment:

Output parameters seem to be populated after all result set are fetched
using mssql_next_result(). However, mssql_execute seems to only return
a valid result set resource on 'SELECT' queries, and not 'SELECT @param
= expr' queries. The $result in a similar case is just 1.


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

[2003-02-19 04:36:40] rajesh dot gala at cgi dot com

I use MS SQL 2000.

I have a simple Stored procedure to be executed. the code is as below

the Stored proc is 
Create  PROCEDURE [AuthLoginUser]
        @LoginUser      CHAR(10),
        @Password       CHAR(32),
        @ReturnVal      INT OUTPUT

AS

BEGIN

        SELECT  @ReturnVal = count(*)
        FROM    [User]  USR
        WHERE   USR.[User ID]   = @LoginUser
        AND     USR.[Password]  = @Password             
        AND     USR.[Status]='A'
        
END

The php code is as below

$stmt = mssql_init("AuthLoginUser", $conn);

$LoginUser=$strRegisteredUsername ;
$Password=$strRegisteredPassword ;

mssql_bind($stmt,"@LoginUser",$LoginUser,SQLVARCHAR);
mssql_bind($stmt,"@Password",$Password,SQLVARCHAR);
mssql_bind($stmt,"@ReturnVal",$ReturnVal,SQLINT4,True);

$result=mssql_execute($stmt);                   

echo '<br><b>Return Value'.$ReturnVal.'</b>';

The problem is that variable $ReturnVal does not get populated

I executed the Stored procedure in the query analyser and I get values
for the same.

Thanks,
Rajesh


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


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