ID: 22294 Updated by: [EMAIL PROTECTED] Reported By: rajesh dot gala at cgi dot com Status: Feedback Bug Type: MSSQL related Operating System: win32 -PHP Version: 4.3.1 +PHP Version: 4.3.2-dev New Comment:
forget my last comment, I didn't notice that you already had tried the snapshot.. Previous Comments: ------------------------------------------------------------------------ [2003-03-06 23:19:45] [EMAIL PROTECTED] Please try using this CVS snapshot: http://snaps.php.net/php4-STABLE-latest.tar.gz For Windows: http://snaps.php.net/win32/php4-win32-STABLE-latest.zip There have been some fixes for mssql stuff in it.. ------------------------------------------------------------------------ [2003-03-06 23:12:25] rajesh dot gala at cgi dot com The version of PHP is use is 4.3.1 windows binary downloaded from the php.net site. The zip file date is 18-Feb-2003. SQL Server 2000 OS Win 2000 Webserver Apache 4.0.44 ------------------------------------------------------------------------ [2003-03-06 23:08:14] rajesh dot gala at cgi dot com This too does not Work PHPCode $UserID = 'ADMIN'; $conn = mssql_connect("SERVER", "UID", "PASS"); mssql_select_db("DBANAME",$conn); $stmt = mssql_init("SELUser",$conn); mssql_bind($stmt,"@UserID",$UserID,SQLCHAR,false); mssql_bind($stmt,"@ReturnVal",$ReturnVal,SQLINT4,True); $result=mssql_execute($stmt); mssql_fetch_array($result); echo $ReturnVal; Stored Procedure CREATE PROCEDURE [SELUser] @UserID CHAR(10), @ReturnVal INT OUTPUT AS BEGIN SELECT * FROM [User] USR WHERE USR.[User ID] = @UserID SET @ReturnVal=@@ROWCOUNT END I get the data in the resultset but not in the Output paramenter. I have used the Output parameter in different ways across the application. How can we get the output parameter populated. Thanks ------------------------------------------------------------------------ [2003-03-06 04:44:01] php at centaur dot mailshell dot com In addition to my previous comment: Windows XP SP1 MSSQL 2000 PHP Version => 4.3.2-dev Build Date => Feb 26 2003 02:23:31 Server API => Apache 2.0 Filter ------------------------------------------------------------------------ [2003-03-06 04:39:30] php at centaur dot mailshel dot com 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. ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/22294 -- Edit this bug report at http://bugs.php.net/?id=22294&edit=1