Re: Bug N°13763 Update with example

This bug is completely unrelated to your COMPUTE statement, it's because you are returning more than 1 result set from your stored procedure. There is a known weakness in the PHP sybase_ct implementation right now, in that you can only get at the first result set that any query returns. Nick Marden (IIRC) has a proposed patch for this...as soon as I get some time, I will look over it and commit it...unless someone else beats me to it. To see this in action outside of the COMPUTE statement, just run "sp_help" from PHP, and see what happens... The bug has already been bogusified. On Thu, 25 Oct 2001, Arnaud L wrote the following to sander@php.net : > Here a complete example (php and sybase) with the problem of compute sql statement. > PHP stop when he encountred the compute. > > PHP : > > sybase_query=("EXEC MYPROC"); > > $result = sybase_query($query); > while ($row = sybase_fetch_array($result)) > { > print $row["COLUMN1"]; > print $row["COLUMN3"]; > print $row["COLUMN3"]; > } > > > SYBASE PROC : > > SELECT DISTINCT doc1,";", conste+concen > +conqtm+conord+coni1+coni2,";", numchg,"; > ", rais1d,";", cpd,";", intcomd,";", > dpliv,";", tcaht, ";", qtet,";", crgro, ";" > FROM fantasio..f_mtf > > WHERE datchg>=@debut > AND datchg<=@fin > AND unit='6' > ORDER BY dpliv, rais1d, intcomd, cpd > COMPUTE SUM(tcaht), SUM(qtet) > BY dpliv, rais1d, intcomd, cpd > > PHP stop on COMPUTE... Then it's a bug of PHP > This error is encountred when i try to return two select. > > >