jpser
Posts: 44
|
| Posted: 10/13/2006, 3:19 AM |
|
Big Trouble with buiding queries with stored procedure ( PHP5 / Mysql5)
Impossible to get parameters
myproc sample:
CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_facclidate`(IN pdate date)
BEGIN
select datefac,idclientfac,societe,netttc from faccli where datefac = pdate order by societe;
END
I can get result with a simple browser ( mysqlquery)
I gave all privileges to the user
But CCS 3 can not get parameter within stored procedure query building
_________________
jp serei
|
 |
 |
jres
|
| Posted: 10/13/2006, 4:41 AM |
|
I tried mysql driver with ctored procedure some time ago and found that it works very bad with stored procedures.
So it can be driver problem.
|
|
|
|
maxq
Posts: 15
|
| Posted: 10/14/2006, 4:46 PM |
|
MyODBC 3.5 do not support stored procedures. We just have to wait for MyODBC 5. This have nothing to do with CCS, it is a limitation in the driver.
|
|
|
|
|
