$this->model->execute( 'START TRANSACTION' ); and $this->model->execute( 'COMMIT' );
worked for me on mysql On Jan 24, 6:49 pm, "zipman" <[EMAIL PROTECTED]> wrote: > Hello, > > I am using postgres as a database which supports transactions. > Is there any update on how I can use transactions in cakephp? > Somewhere i have seen the following piece of code: > > 1- $this->model->begin(); > 2- $result = $this->model->save(); > 3- $sql = 'some query'; > 4- $this->model->execute( $sql ); > 5 -$this->model->commit(); > > Does this actually work? > Are 2 and 4 atomic? > What variable do I have to set to get atomic transactions working? --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
