The easiest way to get the contacts table into the mix is to use :include on the has_many:
has_many :update_requests, :dependent => :destroy, :include => :contact, :order => 'contacts.last_name asc' I'm not 100% sure that this will actually sort the records the way you want, however. If it doesn't work, you'll probably need to build a named scope on UpdateRequest that sorts by contact last_name. --Matt Jones On Nov 16, 10:02 pm, lunaclaire <[email protected]> wrote: > here are my models (only showing the associations that relate to this > post): > > class UpdateRequest < ActiveRecord::Base > belongs_to :user > belongs_to :contact > end > > class User < ActiveRecord::Base > has_many :update_requests, :dependent => :destroy > end > > so I want to be able to list UpdateRequests and sort them based on > attributes of the referenced Contact in each > > I cant, for instance, do the following for the User > > has_many :update_requests, :dependent => :destroy, :order => > 'contacts.last_name asc' > > It doesnt know about the 'contacts' table's columns > > I can do this, right? How? > > Thx --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---

