paginate on custom sql queries in rails
1 def paginate_from_sql(model, sql, total, per_page) 2 @object_pages = Paginator.new self, total, per_page, @params['page'] 3 @objects = model.find_by_sql(sql + " LIMIT #{per_page} " + 4 "OFFSET #{@object_pages.current.to_sql[1]}") 5 end