rubyonrailsin

Hi all. Let's say that quizzes have many tags, through taggings.

I'm doing a search on quizzes, including various other associations, and
passing in various conditions, such as "quizzes.name like '%english%'"
or "quizzes.subject = 'Language'".

If i'm given a parameter :tag => "banana" then i want to order my
results so that the quizzes are ordered by their tags, but with the ones
with the 'banana' tag pushed up to the top of the results. I'm doing a
paginated search (with will_paginate) so i don't want to get all of the
results with a regular find(:all) and then re-order them - i want to do
it in the sql

Can i do this by passing something to the 'order' option? Something
along these pseudo-code lines (the order option is not valid but
hopefully gets my requirement across):

@quizzes = Quiz.paginate(:all, :conditions => <conditions>, :order =>
"tags.name = 'banana' or tags.name", :page => params[:page], :per_page
=> 25)

grateful for any advice - thanks, max
--
Posted via http://www.ruby-forum.com/.

--
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 rubyonrails-talk@googlegroups.com.
To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.