[PHP-DEV] Bug #9906 Updated: Problems with result-set from temporary tables From: joey <email protected>
Date: 06/26/01

ID: 9906
Updated by: joey
Reported By: nicolas <email protected>
Old-Status: Open
Status: Feedback
Bug Type: Sybase-ct (ctlib) related
Operating system:
PHP Version: 4.0.3pl1
Assigned To:
Comments:

Have you tried my example? If so, what results do you
have? It may very well be that I simply didn't create
a complex enough example, or something, but I don't
see a bug, so this'll be closed if you don't have
anything further to add.

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

[2001-03-22 10:36:57] joey <email protected>
I have a hard time believing that this is a PHP bug.

#1: Try upgrading to a newer release.
#2: Here is what I tried to test your bug:
 create proc phpb
 as
 begin
   create table #phpb (id int, foo varchar(255))
   insert into #phpb values (1, "a")
   insert into #phpb values (1, "a")
   insert into #phpb values (1, "a")
   insert into #phpb values (1, "a")
   insert into #phpb values (1, "a")
   insert into #phpb values (1, "a")
   insert into #phpb values (1, "a")
   insert into #phpb values (1, "a")

    select * from #phpb

end

PHP script looks like:
<?php

$db = sybase_connect(...);

$qu = sybase_query("phpb");

while ($a = sybase_fetch_array($qu)) {
        var_dump($a);
}
?>

I got the exact same result from both PHP and isql...

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

[2001-03-21 17:46:07] nicolas <email protected>
I have some stored procedures that return a result from a temporary table. When via ct-lib i try to get the rows it didnīt return anything.
I try with the function sybase_query , and when i get the resource handler none of this functions give me any result:
sybase_num_rows, sybase_fetch_array,sybase_fetch_row.

the reproduction is easy just create a stored procedure that create, fill and select a temporary table.

if you use the php ct-lib functions they didnīt return any result.

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

ATTENTION! Do NOT reply to this email!
To reply, use the web interface found at http://bugs.php.net/?id=9906&edit=2 

-- 
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: php-dev-unsubscribe <email protected>
For additional commands, e-mail: php-dev-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>