#21328 [Opn]: return values from stored procedures
| From: | pvy at novosoft dot ru | Date: | Thu, 02 Jan 2003 06:46:36 +0000 |
| Subject: | #21328 [Opn]: return values from stored procedures | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-28902@lists.php.net to get a copy of this message | ||
ID: 21328
User updated by: pvy@novosoft.ru
Reported By: pvy@novosoft.ru
Status: Open
Bug Type: MSSQL related
Operating System: windows 2000/sp3
PHP Version: 4.3.0
New Comment:
Of course, I use win32 version.
Previous Comments:
------------------------------------------------------------------------
[2003-01-02 00:41:02] pvy@novosoft.ru
Anyway, with CVS version of PHP I got 10 instead 12345
------------------------------------------------------------------------
[2003-01-02 00:32:00] 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:23:20] pvy@novosoft.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.
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=21328&edit=1