That is an interesting idea. (Although I don't think it would give me the exact SELECT .. FOR UPDATE functionality, but I guess it's as close as I can get).
Let me give it a try and see if it works the way you suggested and I'll get back to you. Thanks Teddy On Sat, Aug 13, 2011 at 12:51 PM, 0x20h <[email protected]>wrote: > Maybe an alternative would be to use mysqls GET_LOCK... > > e.g. > $record = find('first', array(...,'fields' => array('GET_LOCK("foo",0) > AS lock', ...) > > if ($record[0]['lock']) { > ... > } > > didn't try that, just a shot in the blue. Of course the named lock > should be unique on what you want to lock. > > > Am 10.08.2011 19:10, schrieb Teddy Zeenny: > > Hi, > > > > Is there a way in cakephp to use SELECT .. FOR UPDATE (for InnoDB row > > level locking) without using the $Model::query function (as this is > > highly not recommended) ? > > > > If not, does anyone know an alternative ? > > > > Thanks, > > > > Teddy > > > > > -- > 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 > [email protected] For more options, visit this group > at http://groups.google.com/group/cake-php > -- 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 [email protected] For more options, visit this group at http://groups.google.com/group/cake-php
