similar to: passing name/value parameters to paginate.

I have a search page with a text_field as below <%= text_field ''program'', ''program_name'' %> After I perform the search in my controller I go to a search results view which shows search results and uses Rails pagination. Now how to pass the search paramters (i.e. params[:program][:program_name] in my controller) to the pagination links (next and

Hi all, I am trying to use the pagination capabilities in a search tool that I have. A search view takes several parameters provided in text input and drop down boxes. Submitting the form causes a POST call to :action => ''search''. I generate some DB conditions based on the parameters and do a paginate. Everything gets shuttled off to the view again and things get rendered

The built-in Rails pagination is fairly limited...you pass in the model name, and optionally some conditions, and it generates a paginated query for you. This gets to be very bad if you''ve got any custom queries. class Company < ActiveRecord::Base def complete_videos Video.find :all, :conditions => "company_id=#{id} AND status=''complete''", :order

hello I hope somebody can help me figure this out. found this great tutorial at http://dev.nozav.org/rails_ajax_table.html. got it working except for one thing. I can''t seem to make the pagination work. The link_to_remote defined in the helper is pointing to the wrong url. I have set up things like so: defined a search method in de project_controller located in apps/admin/project.

I am trying to do a simple search by product name. The first page returns fine, but when I try to go to any other pages of the search results, I lose the original search parameters from my search form and get NilClass errors. Here is the code in my controller: namesearch = "%" + params[:name].strip + "%" @product_pages, @products = paginate :product,

Why does it seem like I''m having so much trouble with this? I created a topics table, and a replies table. In my Topic model I used the following lines of code: has_many :replies has_one :first_reply, :class_name => ''Reply'', :order => "created_on" has_one :last_reply, :class_name => ''Reply'', :order => "created_on DESC"

Hi I use the scaffolded generated crud to handle my entries, and I cannot figure out how to reverse the list, what with the pagination. I can reverse the entries on a page, but not the entire paginated list. Also, it would be helpful to me to be able to redirect to the last page of a paginated list when I destroy, i figured out how to add such links to the view, but how to get from the

I have a controller and list page for region object. My list page has a ''name'' text input that can be used to limit the list. It works except that the paginate gets the full set of regions unqualified by my search term. I believe this full list is contained in :regions symbol which I dont seem to be allowed to modify or replace (yes I am a ruby and rails newb). How can I

Hello, AV::paginate query first by a count, how access this value in the controller or view ? Why ? Because I''ll like to display the total number or records found w/o doing another expenssive Count. Thanks,

All, I''m trying to take advantage of the pagination in my somewhat modified scaffold view now. But there''s something fundamental here that I''m missing. I have this link_to call: <%= link_to ''Previous page'', { :page => @target_list_pages.current.previous } if @target_list_pages.current.previous %> It generates this link: < a

Hi, Why can''t I use a variable to specify the :per_page attribute when using the most basic form of pagination? (if I use a hardcode number, it runs) What did I do? Thx. My code: def list_orders page_size = 20 ... order_pages, @orders = paginate(:orders, :per_page => page_size) end My Errors: undefined method `>'' for false:FalseClass RAILS_ROOT:

There must be a better way to write this code: @project_pages, @projects= paginate :project, :per_page => 10, :conditions => ["account_id = ?", account] ?! If only I could pass the sub-collection account = ... @projects = account.project to paginate, instead of letting it extract it with a find :all + sql conditions Alain. -- Posted via

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

I have this code in my controller and i cannot seem to figure out how to get it to paginate correctly.. Is there a trick to do something like this? There are a few others at www.rubyonrailsforum.com that are having the same issue. Any incite would be great, thanks in advance! (over 117 views and no answer in rubyonrailsforum???) def display_location if params[:search] &&

First I read previous thread with similar problem but I don''t find answer (problem is little diffrent) Hello, I have problem with display information from two tables using paginate.. Here is code. ##### SQL create table subscribers ( id integer not null auto_increment, name varchar(32) not null, surname varchar(64) not null, create_timestamp DATETIME not null, modify_timestamp DATETIME

Hi, Firts all sorry for my poor english I am doing a simple search with paginate, the problem is the search dont find the words within acutes (example "dont find sal?n if i search salon"). Its the code for the seach: def search words = @params[''search''].to_s.split('' '') array_conditions = [] for w in words array_conditions =

My current code is like this: query = "desc_uf like ''%" + session[:search_term] + "%''" @event_pages, @events = paginate :events, :per_page => 10 ,:conditions => query ,:order => "start_date DESC" This query is made against table ''EVENTS'' and everything works fine. Now the query gets complex. I need to make a

I have this code in my controller and i cannot seem to figure out how to get it to paginate correctly.. Is there a trick to do something like this? There are a few others at www.rubyonrailsforum.com that are having the same issue. Any insite would be great, thanks in advance! def display_location if params[:search] && params[:search].size > 0 @listing_pages, @listings =

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, 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