Hello Matthew, not all database systems, which CakePHP supports, allow to use LIMIT within an UPDATE statement (eg. PostgreSQL doesn't).
So, I guess, you'll have to use a custom query. 2008/11/1, Mathew <[EMAIL PROTECTED]>: > > > Hi, > > I'm having some troubles updating records. I need to be able to define > the ORDER and LIMIT for the update, but the method updateAll appears > to only accept conditions. > > updateAll is created the LEFT JOIN statements for my other models, but > i need to only update the first 100 records ordered by field value. > > Any ideas on how to do this? > > > -- Sincerely yours, Olexandr Melnyk http://omelnyk.net/ --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" 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 -~----------~----~----~----~------~----~------~--~---
