ID: 13763
Comment by: [EMAIL PROTECTED]
Old Reported 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:
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
Previous Comments:
------------------------------------------------------------------------
[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.
------------------------------------------------------------------------
[2001-10-20 04:50:44] [EMAIL PROTECTED]
Here an exemple :
sybase_connect(SERVER,LOGIN,PASSWORD);
sybase_select_db(DATABASE);
$query = "EXEC MYPROC";
$result = sybase_query($query);
while ($row = sybase_fetch_array($result))
{
print $row["COLUMN1"];
print $row["COLUMN3"];
print $row["COLUMN3"];
}
If in this sybase procedure there is not compute all is ok, all the
record are return. But if there is a compute all the record are return
and when php arrive in the compute line is don't display it.
This bug is encountred when the proc return more than 1 recorset like
(in the proc)
SELECT LIB1, LIB2 FROM LIBELLE
SELECT NAME, FNAME FROM PEOPLE
In this exemple this proc is use to make a delivery order, in the same
proc, whe make a select to retrive the customer information (name,
adress, phone...) and the second select to retrive information about a
command of this customer.
Thanks for your help
PS : The library is SYBASE_CT.
------------------------------------------------------------------------
[2001-10-19 15:36:19] [EMAIL PROTECTED]
Can you provide a sample script?
------------------------------------------------------------------------
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/?id=13763
Edit this bug report at http://bugs.php.net/?id=13763&edit=1
--
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]
