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 [EMAIL PROTECTED] :
> 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.
>
>
>
--
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]
