similar to: How can I paginate records find by using find_by_sql

Hello, I have 2 tables table colors : +----------------------+ | id | user_id | name | +----------------------+ | 1 | 1 | test1 | | 2 | 2 | test2 | | 3 | 3 | test3 | +----------------------+ table users : +----------------------+ | id | enabled | name | +----------------------+ | 1 | 1 | bob | | 2 | 1

Does anybody know how to paginate a find_by_sql query? Unfortunately I need to paginate a query which is next to impossible for ActiveRecord or just too much of a pain to implement. So I''m using find_by_sql. However, I anticipate a large number of rows returned eventually. So I may need paginate. Does anyone know how? Thanks Phillip Novess http://primalart.net

Hi, So I''m using @post_pages, @posts = paginate :posts, :per_page => 10 to paginate. But I have rails 2.0.2 on my VPS. Now this version of paginate throws an error. What happened to classic pagination and what is done now? Thanks, Ron --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on

Hi, I''m getting a undefined method `paginate'' for #<Class:0x567eb98> even though I have gem ''will_paginate'' installed. Inside the users_controller I have @users = User.paginate(page: params[:page ]) so I believe I set everything up to be correct. Can you figure out why the method''s undefined, despite installing the gem? -- You received this

Dear I used to use the will_paginate plugin, and now it is no longer available in the repository. I am using the one in the gem #gem install will_paginate in my controller I have this @careers = Career.paginate :page => params[:page], :per_page => 10 and in the view <%= will_paginate @careers %> I found this way in all the tutorials and the railscasts episode 51. Though I still

My question is whether there''s a more idiomatic rails way of structuring this query or of redoing the underlying models. First, the ugly find_by_sql code, which is the method to generate an atom feed: def atom items_per_feed = 15 sql_query = "SELECT activities.*, users.real_name AS real_name, accounts.last_scraped_at AS last_scraped_at,

hi; i use will_paginate the first page come true but all other page get the same data of first page i checked in controller "page" parameter works true but paginate get only first page''s data and shows these data in all pages forexample first page seen A,B second page also seen A,B but second page must be C,D my code is; controller : @list = Company::Env.paginate :page =>

hi everybody, i am new to rails.. plz clear my doubt... this is my question In my table(public_topics), i have 11 rows of data.. whenever i run the following view, it shows the entire rows in the current page.. and i have set the '':per_page'' option to ''2''.so it must show two data per page..but it shows all the rows in a single page..and this case continue

Hi all, Is there a way to create pagination with a complex SQL, more complex than the :conditions option will support? I have two databases, houses and images. Houses has_many images, and each Image belongs_to house. I''m creating a search engine for the house records and I''d like to be able to filter out all the houses without any associated images. So far I''m

Hi, I was trying to use the :select parameter to select a calculated row, but it appears that the parameter is not picked up by the paginate method. I want to add the following to the select statement: timediff(now(), created_on) as age So I tried: @story_pages, @stories = paginate :stories, {:per_page => 10, :include => ''user'', :select =>

I''m still a newb but having fun - Any help on this problem will be much appreciated. I have mymodel Call.rb class Call < ActiveRecord::Base belongs_to :user has_many:visits, :dependent => :destroy has_many:visits do def latest find :all, :order => ''id DESC'', :limit => 3 end def all_latest find

Hi, please help... In controller... def index @customers = Customer.find(:all) pagination code here.... end In index.html.erb Displayes list of customers and has pagination 1,2,3,4...etc. On clicking page 2, it will again run this(Customer.find(:all)) query in controller. So, there will be lack of performance. So, how to increase the mysql performace? Can i use the index as below or any

hi, I am curently using rails version 2.1.1. Currently i have done simple pagination using will_paginate plugin.it works.but when i am trying pagination using ajax with help of will_paginate plugin it wont works.i am also using RemoteLinkRenderer helper, but it gives an error uninitialized constant RemoteLinkRenderer. can anyone provide any tutorial or sample code so that i can

How to make it work with paginator (kaminari)? MySQL and full text search: Words (id, word) @words = Word.find_by_sql(["SELECT id, word, MATCH (word) AGAINST (?) AS Score FROM words WHERE MATCH (word) AGAINST (?) ORDER BY Score Desc, word!=?", params[:search],params[:search],params[:search]]) I can''t add .page(params[:page]).per(5) to the end of "find_by_sql()" so

mislav-will_paginate(will_paginate) doesn''t work after search. servers_controller.rb def index @servers = Server.paginate(:page => params[:page], :per_page => 20, :order => ''device_id ASC'') respond_to do |format| format.html # index.html.erb format.xml { render :xml => @servers } end end def search @servers =

hi i know i can do: @customer_pages, @customers = paginate :customers, :per_page => 8 but these customers have helpdesk calls which are child records. I hoped i could do something like paginate customers.calls, but dat doesn''t work what is the best way to get a paginated list of child records? remco -- Posted via http://www.ruby-forum.com/.

I have a little web app where we need to paginate collections of items. I''m trying to sort the collection and then pass it, sorted, to a Paginator, and still be able to paginate through the collection, across several pages, with the new sort order. The only thing I''m doing differently from the regular scaffolding approach is this: @order_pages = Paginator.new(self,

Hello all,will_paginate don''t work on jruby platform, the Model.paginate find works ok, accepts all kinds of params, this is config.gem config.gem ''will_paginate'', :version => ''2.3.11'', :source => ''http://gemcutter.org'', but <%= will_paginate @collection %> doesn''t work it always produce nil(so nothing on page).

I have: class Post < ActiveRecord::Base has_many :comments do def published find( :all, :conditions => {:published => true} ) end end end When in my controller I do Post.find(:first).comments.published.paginate :page => params[:page] I get an error undefined method `paginate'' for []:Array Is will_paginate supposed to

I am trying to monkey-patch the ActiveRecord::Base class to incorporate a generic search class method so that it can be used by all model classes which need this functionality. Since model classes directly inherit from ActiveRecord::Base and unlike controllers and helpers, do not have an ancestor class defined, I think I am forced to open the ActiveRecord::Base class and patch it? May be I am