Ok, I've got a solution, but it feels ugly to me. does anyone have suggestions:
select * from posts where post_id*1000+revision in (select post_id*1000+max(revision) from posts group by post_id); So, this is all in a where clause, so I can use findAll(), and it returns all of the latest revision data. It's obviously limited to 1,000 posts (which I could up to whatever max makes sense). I don't like the 1,000 thing though. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
