PHP 4.0 Bug #9906 Updated: Problems with result-set from temporary tables

ID: 9906 Updated by: joey Reported By: nicolas@albisetti.com.ar Status: Open Bug Type: Sybase-ct (ctlib) related Assigned To: Comments: 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... Previous Comments: --------------------------------------------------------------------------- [2001-03-21 17:46:07] nicolas@albisetti.com.ar 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