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
