php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #9906 Problems with result-set from temporary tables
Submitted: 2001-03-21 17:46 UTC Modified: 2001-07-26 02:19 UTC
From: nicolas at albisetti dot com dot ar Assigned:
Status: Closed Package: Sybase-ct (ctlib) related
PHP Version: 4.0.3pl1 OS: Linux RedHat 7.0
Private report: No CVE-ID: None
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: nicolas at albisetti dot com dot ar
New email:
PHP Version: OS:

 

 [2001-03-21 17:46 UTC] nicolas at albisetti dot com dot 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.


Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2001-03-22 10:36 UTC] joey@php.net
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-06-26 17:07 UTC] joey@php.net
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.
 [2001-07-26 02:19 UTC] andy@php.net
no feedback...
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Sun Dec 22 01:01:30 2024 UTC