Don't want to scare you off blunt, but I've had many painful run-ins with stored procedures, particulary with PHP4 and Mysql < 5
They're finicky. I don't have a full solution, but maybe someone else here knows more. One thing I've found is that closing the connection and reopening it works. though, as you may guess, this can really slow an app down. Best advice may be upgrade your MySql and/or your PHP. I've heard PHP5 is better at it, and Mysql 5.0 may not have the problem at all, but I don't know for sure. I do know that store procedures work great from the mysql comandline interface. And if you only run one stored procedure for your processing you won't notice the problem. I don't know if this will help you build your app or not. But I don't think what you're seeing is a cake thing. I think it's a php/mysql thing. Jeff On Sep 26, 2:40 am, blunt <[EMAIL PROTECTED]> wrote: > That just gives me an error: > > Query: rawQuery > Warning: SQL Error: 1064: You have an error in your SQL syntax; check > the manual that corresponds to your MySQL server version for the right > syntax to use near 'rawQuery' at line 1 in D:\www\race\cake\libs\model > \datasources\dbo_source.php on line 437 > > On Sep 25, 10:51 pm, Jan Boonen <[EMAIL PROTECTED]> wrote: > > > Have you tried the method rawQuery($sql)? I don't have experience with > > calling stored procedures from CakePHP, but from the API it seems more > > logical to me to use this method. See the API > > docs:http://api.cakephp.org/1.2/class_dbo_source.html#4c5cec0634f083d98db9.... > > > Cheers, > > > Jan --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
