ID: 13763
Updated by: [EMAIL PROTECTED]
Reported By: [EMAIL PROTECTED]
-Status: Bogus
+Status: Open
Bug Type: Sybase-ct (ctlib) related
Operating System: LINUX REDHAT 7
PHP Version: 4.0.6
New Comment:
Reopening on user request.
Previous Comments:
------------------------------------------------------------------------
[2002-05-14 13:50:38] [EMAIL PROTECTED]
Still needed with 4.2.1
PS : please change status from Bogus to Open
------------------------------------------------------------------------
[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
------------------------------------------------------------------------
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
