Hi,
I am doing an update which requires all products that meet a criteria
to be updated without an id. Each time I run the query, all data is
updated twice.
For example if the price is $0.20 cents, it is changed to $0.60.
Here is what the structure of the query looks like inside of the
component without quotes:
$this->controller->$modelclass->query( Update tbl set price = price
+0.20 where price <= 0.20 )
Is there away to do table updates without using the id for reference?
Thanks for your help,
Bill
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
