ID: 13763 Updated by: [EMAIL PROTECTED] Reported By: [EMAIL PROTECTED] Status: Bogus Bug Type: Sybase-ct (ctlib) related Operating System: LINUX REDHAT 7 PHP Version: 4.0.6 New Comment:
Still needed with 4.2.1 PS : please change status from Bogus to Open Previous Comments: ------------------------------------------------------------------------ [2002-04-23 08:41:41] [EMAIL PROTECTED] Still needed with 4.2.0 PS : please change status from Bogus to Open ------------------------------------------------------------------------ [2002-01-13 17:43:37] [EMAIL PROTECTED] I've the same problem. Please resolve this bug. Thanks. for more info, 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 ------------------------------------------------------------------------ [2001-10-25 17:45:42] [EMAIL PROTECTED] User reported on php-dev, so adding here: --- 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. ------------------------------------------------------------------------ [2001-10-23 12:08:25] [EMAIL PROTECTED] Here an exemple of stored procedure : Yes, i execute this sybase stored procedure : 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 ------------------------------------------------------------------------ [2001-10-20 05:36:50] [EMAIL PROTECTED] 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. ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/13763 -- Edit this bug report at http://bugs.php.net/?id=13763&edit=1