Hellow, It's a bug of PHP
see bugs #11475 (and #13475, #13735, #12074) There's a lot of problem to retrieve multi-result-set from store procedures (example : sp_help with rules or data types) So, the solution is to develop #12074 or test/apply the patchs from #11475 & #13735, #13475 alahaye : fais comme moi : attends :P @++ JC ----- Original Message ----- From: <[EMAIL PROTECTED]> Newsgroups: php.dev To: <[EMAIL PROTECTED]> Sent: Saturday, October 20, 2001 11:36 AM Subject: Bug #13763 Updated: SQL Compute > ID: 13763 > Updated by: sander > Reported By: [EMAIL PROTECTED] > Old Status: Open > Status: Bogus > Old Bug Type: Sybase (dblib) related > Bug Type: Sybase-ct (ctlib) related > Operating System: LINUX REDHAT 7 > PHP Version: 4.0.6 > New Comment: > > I think you're doing something wrong. I don't think it's a bug in PHP. > > Ask support questions on the appropriate mailinglist (see http://www.php.net/support.php). Hint: try print_r($row); somewhere in the while()-loop. > > Previous Comments: > ------------------------------------------------------------------------ > > [2001-10-20 04:50:44] [EMAIL PROTECTED] > > 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. > > ------------------------------------------------------------------------ > > [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]