Model::query() On Sun, Nov 18, 2012 at 10:10 AM, John james <[email protected]> wrote: > I have to call a store procedure on my cakephp can anybpdy tell me how to do > it ? > > On Tuesday, October 16, 2007 8:11:46 PM UTC+5, beverly.guillermo wrote: >> >> Hi all, >> >> Just thought I'd post my workaround based on some of the posts here >> but I didn't see a consistent answer to the issue. My environment is >> PHP 5.2.3, Apache 2.2.6, and MySQL 5.0.41-community. >> >> So, here's the problem, I have a stored procedure that I want to call >> in Cake. When I try to run the $this->model->query("call >> sp_mine(params)"); or $this->model->_call, I don't get anything back >> and an mysql error occurs. >> >> Error 1312 - PROCEDURE <...> can't return a result set in the given >> context: nothing returned >> >> To resolve this, I had to modify the connect call to the database in >> dbo_mysql.php to include a client flag, specifically >> CLIENT_MULTI_RESULTS or CLIENT_MULTI_STATEMENTS or 65536. But after >> implementing this and calling my stored procedure I go another mysql >> error: >> >> Error 2014 - Commands out of sync; you can't run this command now >> >> I get this for any query or execute that I attempt to call. And per a >> post from blunt, I added this function >> >> function releaseDB() { >> $db =& ConnectionManager::getDataSource($this->useDbConfig); >> $db->disconnect(); >> $db->connect(); >> } >> >> to my model_php5.php. After every sp call, I call that method. >> >> >> If anyone has a better resolution or if it's fixed in the current cake >> version and I'm not doing something right, then let me know. :P >> >> Thanks, >> Beverly > > -- > Like Us on FaceBook https://www.facebook.com/CakePHP > Find us on Twitter http://twitter.com/CakePHP > > --- > You received this message because you are subscribed to the Google Groups > "CakePHP" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > Visit this group at http://groups.google.com/group/cake-php?hl=en. > >
-- Like Us on FaceBook https://www.facebook.com/CakePHP Find us on Twitter http://twitter.com/CakePHP --- You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. Visit this group at http://groups.google.com/group/cake-php?hl=en.
