Bug N°13763 Update with example
| From: | Arnaud L | Date: | Thu, 25 Oct 2001 21:40:01 +0000 |
| Subject: | Bug N°13763 Update with example | ||
| Groups: | php.dev | ||
| Request: | Send a blank email to php-dev+get-69019@lists.php.net to get a copy of this message | ||
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.