On Sun, Dec 21, 2008 at 8:40 PM, Patrick Doyle <[email protected]> wrote: > I can't figure out how to make that work -- the revisions table does not > have a column named "documents". It does have a "document_id" field, which > is associated with a specific record in the documents table. I'm trying to > figure out how I can query the "revisions" table, but sort the results based > on data stored in the associated record in the "documents" table.
You'll need to do a join to the documents table then, à la @revisions = Revision.find(:all, :include => :document, :order => 'documents.sort_field') Read up on ActiveRecord find for more info. Regards, Franz --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" 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/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
