Rails - Sep 2005 - Ordering By Related Object Attribute

I a video object. That video ''belongs_to'' an artist object.

I want to fetch videos and have them sorted by the artist name, an attribute
of the artist object.

This is the result of converting an application from WebObjects, so perhaps
my thinking is off in Rails-isms?

I was trying this:

@videos = VideoTrack.find(:all, :order => "artist.sort_name")

This of course didn''t work as it looks like Rails just passes
''order''
directly to the DB without processing it at all.

So, what is the correct method to get this done in Rails?

Thanks,
Hunter

> I a video object. That video ''belongs_to'' an artist
object.
> I was trying this:
> @videos = VideoTrack.find(:all, :order => "artist.sort_name")
I think you just need to tell rails to include artist in the query.

@videos = VideoTrack.find(:all, :include => :artist, :order => :sort_name)

You may need to add a little something to remove ambiguity if a
"sort_name" column exists in both tables.