Forum: Ruby on Rails 2 Quick SQL Questions: Paginate Conditions and Adding to Val

Announcement (2017-05-07): is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see and for other Rails- und Ruby-related community platforms.
Abed21abff74d51f99d8ae6ad8e5a3e9?d=identicon&s=25 (Guest)
on 2007-05-20 18:12
(Received via mailing list)
I have 2 quick SQL questions that all my googling couldnt come up with
an answer

1. Paginate results based on 2 conditions

I currently have sorthelper sorting based on title/author. I'd like
the option to select based on 3 genres then be able to sort that
through those results by title. I haven't be able to see how to handle
sorting with a variable condition. (codes below

2. How to add to current value

How would I add to a current value in my table?

value = value.current +

def upcoming

   items_per_page = 8
   @total = Albums.count
   @sorter = self, %w(artist album
votes_count date created_at), @params['sort'], @params['order'],
'created_at', 'asc'
   @albums_pages, @albums = paginate :albumss, :order =>
@sorter.to_sql, :per_page => items_per_page

   render :layout => 'albums_upcoming'

This topic is locked and can not be replied to.