group by?

AD11 · May 11, 2007, 3:35am

How can you add an "group by title" clause to:

@books_pages, @books = paginate (:books, :conditions => ['keyid = ?', @key.id], :order => 'id DESC', :per_page => 10 )

Thanks

Camo · May 11, 2007, 5:35am

Hey there mate,

Go to railscast.com i think there is a quick 4 min viedo on it, that should help

Alain_Ravet · May 11, 2007, 10:37am

You just sent him to a spam search page

Correct url:

Alain Ravet

Scott18 · May 11, 2007, 9:43pm

If I am not mistaken, with pagination you should be able to use all the parameters that you would on a find. So you could use the :group option.

@books_pages, @books = paginate (:books, :conditions => ['keyid = ?', @key.id], :order => 'id DESC', :per_page => 10, :group => "title" )

Scott

Cliff_Rowley · May 12, 2007, 8:04am

Just watched a few of the railscasts. Most productive 20 minutes I've spent in the past 2 weeks