Tickets go on https://trac.cakephp.org
However, if you search there you will find a few tickets on the same topic, such as: https://trac.cakephp.org/ticket/3029 "The purpose of updateAll() is to allow updating of fields based on calculated values of other fields. Hence, strings are not supposed to be quoted. Optional support for in-method quoting may be added later." On Apr 1, 1:43 am, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: > Hi all, > > I am new to the cake group, thanks for see the thread. > > I was trying to use updateAll() and being stuck for a while. not sure > it is a bug or something special, would somebody please identify it. > And how can I report a bug? > > The following query works in 1.2.0.6311: > > $this->Fruit->updateAll(array("color" => "'yellow'"), > array("Fruit.name" => > "lemon")); > > it will be interpreted to: > > UPDATE `fruits` AS `Fruit` SET `Fruit`.`color` = 'green' WHERE `name` > = 'lemon' > > Two problems come with the array elements: > > 1. The field intended to update can not be defined as > "Fruit.color", otherwise a reluctant table name will be added to the > generated query (... SET `Fruit`.`Fruit`.`color` = ...) > 2. The new value of the field can not be quoted as "yellow", but > "'yellow'", which loses consistency with the condition array value > given "lemon". --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to cake-php@googlegroups.com 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 -~----------~----~----~----~------~----~------~--~---
