ID: 13763
User updated by: [EMAIL PROTECTED]
Reported By: [EMAIL PROTECTED]
Old Status: Feedback
Status: Open
Bug Type: Sybase (dblib) related
Operating System: LINUX REDHAT 7
PHP Version: 4.0.6
New Comment:
Here an exemple :
sybase_connect(SERVER,LOGIN,PASSWORD);
sybase_select_db(DATABASE);
$query = "EXEC MYPROC";
$result = sybase_query($query);
while ($row = sybase_fetch_array($result))
{
print $row["COLUMN1"];
print $row["COLUMN3"];
print $row["COLUMN3"];
}
If in this sybase procedure there is not compute all is ok, all the record are return.
But if there is a compute all the record are return and when php arrive in the compute
line is don't display it.
This bug is encountred when the proc return more than 1 recorset like (in the proc)
SELECT LIB1, LIB2 FROM LIBELLE
SELECT NAME, FNAME FROM PEOPLE
In this exemple this proc is use to make a delivery order, in the same proc, whe make
a select to retrive the customer information (name, adress, phone...) and the second
select to retrive information about a command of this customer.
Thanks for your help
PS : The library is SYBASE_CT.
Previous Comments:
------------------------------------------------------------------------
[2001-10-19 15:36:19] [EMAIL PROTECTED]
Can you provide a sample script?
------------------------------------------------------------------------
[2001-10-19 14:57:27] [EMAIL PROTECTED]
When i launch a sybase stored procedure with a compute inside, i can't get this
resultset in my outpout array.
------------------------------------------------------------------------
Edit this bug report at http://bugs.php.net/?id=13763&edit=1
--
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
