Re: stored procedures cakephp

The best place would be in a separate function in the applicable Model. To wrap the procedure call in a transaction do something like:

For example if you have a calcUserRep() procedure you should do:

public function getUserRep($someParam,$someOtherParam){

......

$this->begin();
$this->query("CALL calcUserRep();");
$result = $this->query("SELECT something");
$this->commit();

....

}

On Thursday, 2 August 2012 13:27:57 UTC+3, Milina Udara wrote:

I found that we can use SP with Cakephp. But there are thing  call    transaction,   DataSource,   behaviors and  Events System. 
My  problem is  where to use those things and SP ?

 I wont answer from architectural  view.

--
Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions.
 
 
To unsubscribe from this group, send email to
cake-php+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php