Re: Problems with updateAll

Hi,

did I understand right, that the updateAll works but you just don't
like the two statements to get the result?

I guess that's the standard way cake does the updateAll, maybe because
of scalability.

But do you really need updateAll? Your query looks more like saveField
() is what you need.

Regards,
Michael

LPaulino schrieb:
> I've done this:
> <?php
> $this->Account->updateAll(
> array('Account.memb__pwd' => "'qweqwe'"),
> array('Account.memb___id' => 'mylogin')
> );
> ?>
> work, but not as I wanted... first cake does a select, later does the
> update with the result of the select. look
>
> 11 SELECT [Account].[memb_guid] AS [Account__0] FROM [MEMB_INFO] AS
> [Account] WHERE [Account].[memb___id] = 'mylogin' 1 1 9
> 12 UPDATE [MEMB_INFO] SET [memb__pwd] = 'qweqwe' WHERE [memb_guid] =
> ('1') 44426 3197
>
> But I dont want that happens.
>
> I just want:
> UPDATE [MEMB_INFO] SET [memb__pwd] = 'qweqwe' WHERE [Account].
> [memb___id] = 'mylogin'
>
> Its simples, so trivial, its directly and cake cant do this ¬¬
>
>
> PS: Im using direct data without SHA1 or MD5, cause this site already
> has a DB and it cant be changed. If I use query('UPDATE MEMB_INFO SET
> memb__pwd=' . '"qweqwe"' . ' WHERE memb___id=' . '"mylogin"') it
> works, but I did wanna use cake methods.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
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?hl=en
-~----------~----~----~----~------~----~------~--~---