Thanks a lot Chris & Mr. m.sbr. :-)
I will think & check your code so that how can I implement in my
project.
Yeah, this is a mysql issue, i think need to create a table by using
InnoDB engine. This support row level locking.
Regards,
sharath.
On Aug 20, 7:15 pm, <[EMAIL PROTECTED]> wrote:
> I have used this on one of my projects:
>
> function afterSave() {
> /*
> ** If new record find counter
> */
> if(! @$this->data['Protocolli']['id']) {
> $id = $this->getLastInsertId();
> $anno = $this->data['Protocolli']['anno'];
> $segreteria_id =
> $this->data['Protocolli']['segreteria_id'];
>
> $sql = 'LOCK TABLES protocolli READ';
> $this->execute($sql);
>
> $sql = "SELECT MAX(numero) as maxnum
> FROM protocolli
> WHERE anno = {$anno}
> AND segreteria_id = {$segreteria_id}";
> $row = $this->execute($sql);
>
> $num = (int) $row[0][0]['maxnum'] + 1;
>
> $sql = 'LOCK TABLES protocolli WRITE';
> $this->execute($sql);
>
> $sql = "UPDATE protocolli
> SET numero = {$num}
> WHERE id = {$id}";
> $this->execute($sql);
>
> $sql = 'UNLOCK TABLES';
> $this->execute($sql);
> }
> return parent::afterSave();
> }
>
> > -----Messaggio originale-----
> > Da: [email protected]
> > [mailto:[EMAIL PROTECTED] Per conto di Chris Hartjes
> > Inviato: lunedì 20 agosto 2007 15.32
> > A: [email protected]
> > Oggetto: Re: about row locking
>
> > On 8/20/07, sharath <[EMAIL PROTECTED]> wrote:
>
> > > Hi,
> > > I'm using cake & mysql for editing purpose.
> > > Now i want to lock a particular row of a table. Can anybody tell me
> > > about how to do this in cake?
>
> > > Thanks in advance,
> > > sharath.
>
> > That is a MySQL issue, not a CakePHP one. I am not aware of
> > any functionality that exists in CakePHP to let you do this,
> > but my quess is this: if you can lock a row with a MySQL
> > command then you can probably run it using
> > $this->Foo->query(...) if you need a response back or
> > $this->Foo->execute(...) if you don't.
>
> > Hope that helps.
>
> > --
> > Chris Hartjes
> > Senior Developer
> > Cake Development Corporation
>
> > My motto for 2007: "Just build it, damnit!"
>
> > @TheBallpark -http://www.littlehart.net/attheballpark
> > @TheKeyboard -http://www.littlehart.net/atthekeyboard
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
