Has_many :through with :order?


#1

Let’s say I have

class Student < ActiveRecord::Base
has_many :classes_students
has_many :classes, :through => :classes_students
end

I want the list of classes for each student to be sorted by the class
title.
I could get an array containing the classes and then sort it. But, I
would like for the database to do the work.

Is there some combination of :include and :order that would cause
rails to ask for a sorted list?

I know this does not work:
has_many :classes, :through => :classes_students, :order => ‘title’

Any ideas?


#2

User.find(:all, :include => [:profile], :order => ‘profiles.name ASC’)

Seems to work for me … not sure that it should, but it does.

Chris
http://www.dummied.org


#3

I know this does not work:
has_many :classes, :through => :classes_students, :order => ‘title’

What do you mean this does not work? It works for me. Does it not
sort it the way you want?