http://snippets.dzone.com/posts Fri, 25 Jul 2008 03:36:32 GMT DZone Snippets: pagination code http://snippets.dzone.com/posts/show/389 Sometimes it's nearly impossible to paginate a result set using the built-in :limit and :offset parameters of find(:all). Instead, you can fetch a complicated query and paginate the results afterward. <br /> <br />Add the following to application.rb: <br /> <br /><code> <br /> def paginate_collection(collection, options = {}) <br /> default_options = {:per_page => 10, :page => 1} <br /> options = default_options.merge options <br /> <br /> pages = Paginator.new self, collection.size, options[:per_page], options[:page] <br /> first = pages.current.offset <br /> last = [first + options[:per_page], collection.size].min <br /> slice = collection[first...last] <br /> return [pages, slice] <br /> end <br /></code> <br /> <br />Call it from within your action like this: <br /><code> <br />@pages, @users = paginate_collection User.find_custom_query, :page => @params[:page] <br /></code> Thu, 16 Jun 2005 13:13:41 GMT http://snippets.dzone.com/posts/show/389 canadaduane (Duane Johnson)