In my app, a user has_many resolutions, and i want @user.resolutions to return only the most recently updated five resolutions, but ordered *oldest first* out of those five.
So, let's say i have 12 records, which we'll label 1 through to 12. For simplicity's sake let's say that the order of updated_at matches the order of the labels. Then,
has_many :resolutions, :order => "id DESC", :limit => 5
A bit nasty, but how about
has_many :resolutions, :finder_sql => 'SELECT * from (SELECT * from resolutions order by id desc limit 5) as t order by id asc'
Fred