php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Bug #21328 return values from stored procedures
Submitted: 2003-01-02 00:23 UTC Modified: 2003-01-09 12:10 UTC
Votes:2
Avg. Score:5.0 ± 0.0
Reproduced:0 of 0 (0.0%)
From: pvy at novosoft dot ru Assigned:
Status: Closed Package: MSSQL related
PHP Version: 4.3.0 OS: windows 2000/sp3
Private report: No CVE-ID: None
View Add Comment Developer Edit
 [2003-01-02 00:23 UTC] pvy at novosoft dot ru 
Hello! 
Happy new year!

I have next MSSQL procedure:
create procedure test1
as begin

	return 12345
end

and have next test script:
<?
mssql_connect($server,$user,$password);
mssql_select_db($db);
$a=10;
$s=mssql_init("test1");
mssql_bind($s,'RETVAL',&$a,SQLINT4);
mssql_execute($s);
echo $a;
?>

in PHP-4.2.3 I got 12345 as output in $a
in PHP-4.3.0 I got 10 as output in $a

Congratulations, MSSSQL working with Stored procedures is fully broken. or documentation missmath with 4.3.0?

Regards,
vladimir,
Novosibirsk,
Russia.

Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2003-01-02 00:32 UTC] derick@php.net 
Please try using this CVS snapshot:

  http://snaps.php.net/php4-latest.tar.gz
 
For Windows:
 
  http://snaps.php.net/win32/php4-win32-latest.zip
 [2003-01-02 00:41 UTC] pvy at novosoft dot ru 
Anyway, with CVS version of PHP I got 10 instead 12345
 [2003-01-02 00:46 UTC] pvy at novosoft dot ru 
Of course, I use win32 version.
 [2003-01-07 04:45 UTC] hwulampe at gmx dot de 
Hy!

I have the same Probleme with Windows 2000 Server and MSSQL 7.0 and the latest snapshot is no solution :-)
Is there a Bug-Fix in sight?

sincerely yours,

Henning Lampe
Bremen
Germany
 [2003-01-09 12:10 UTC] fmk@php.net 
This bug has been fixed in CVS.

In case this was a PHP problem, snapshots of the sources are packaged
every three hours; this change will be in the next snapshot. You can
grab the snapshot at http://snaps.php.net/.
 
In case this was a documentation problem, the fix will show up soon at
http://www.php.net/manual/.

In case this was a PHP.net website problem, the change will show
up on the PHP.net site and on the mirror sites in short time.
 
Thank you for the report, and for helping us make PHP better.
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved. 		Last updated: Thu Apr 18 09:01:27 2024 UTC