Never been to DZone Snippets before?

Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world

About this user

Peter Cooperx http://www.petercooper.co.uk/

« Newer Snippets
Older Snippets »
Showing 1-1 of 1 total  RSS 

paginate on custom sql queries in rails

Someone in #rubyonrails wrote this. Forget who!

   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
to ruby rails pagination sql by peter on Apr 02, 2005 2 Comments
« Newer Snippets
Older Snippets »
Showing 1-1 of 1 total  RSS