Thanks, Mariano. However, I'm looking to pull in a whole record for the given $post_id. If I extend your suggestion to SELECT post_id, MAX(revision), data I get the data from the older records. Because MAX(revision) is the field returned, not the WHERE clause.
Also, I'm hoping to take advantage of findAll() and find()'s ability to pull in associated tables. I believe your suggestion is to do a query(), which will just deliver the record requested. I suppose I could do the query in two passes, first finding the post_id and revision for each row I want, then pulling them and building the whole array in a second pass. I'm not sure how I'll auto-get the associated tables, though. Also, I'm hoping to take advantage of save() after I modify the data in a view. pulling MAX(revision) won't save as "revision". Although, I can modify the returned structure, changing the array name "MAX(revision)" to "revision", I suppose. Any further help? --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
