Displaying 20 results from an estimated 9000 matches similar to: "Help needed in specifying conditions in pagination"
2006 Feb 15
0
Confused by this error when trying to use ''pagination''
Trying to create stuff without resorting to scaffold command.
I have a list view in my login_controller.rb file...
def list_users
@user_pages, @users = paginate :users, :per_page => 14
end
I have a command in my list_users.rhtml file which undoubtedly calls
this pagination...
<%
odd_or_even = 0
for user in @users
odd_or_even = 1 - odd_or_even
%>
and instead of being presented a
2006 Apr 26
1
List shows always first page
Hello!
I''m a beginner of rails.
I made a simple test project with rails 1.1.2 and ruby 1.8.2 on Windows
XP.
DB is SQLServer 7.0.
I''m connecting the server thru ODBC.
I created a table named "users" with about 10 columns.
I inserted 1000 sample records.
I created a scaffold for user model and login controller for it using
the script.
Everything''s fine
2006 Jan 03
0
has_and_belongs_to_many include problem
hey,
i have users who are in groups, and i have a search form, where i can search on
group, user lastname, and user firstname.
All this is also with pagination.
these are my models
class User < ActiveRecord::Base
has_and_belongs_to_many :groups
end
class Group < ActiveRecord::Base
has_and_belongs_to_many :users
end
in my controller i do this
THIS works (but in need pagination)
@users2
2006 Feb 13
1
another simple question: per_page in pagination
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:
2006 Jan 24
1
Pagination
Hello,
maybe that I''m a stupid, but I don''t know how I can working with
pagination. In all examples is written (for example) next:
def user_list
@user_pages, @users = paginate(:users, :order_by => ''name'')
end
So, it''s OK (as a scaffold) for all set of users. But I need a little
other functionality. For example I need paginate only a little bit
2006 Feb 01
1
Rails pagination problem
I am having this problem with pagination query in my controller class.
I am using SQL server and following code to create pagination fails,
complains about column name ''program_name'' (which is valid
column/attribute of program)
The error message is:
DBI::DatabaseError: S0022 (207) [Microsoft][ODBC SQL Server
Driver][SQL Server]Invalid column name
2006 Aug 01
1
Re-using a Listing screen form
How do I display subsets of records on a Listing page (that lists in
grid form table records)? In particular, when displaying the Listing
page, it would be nice to allow the user to display a subset of the
records, for example, by filtering.
For example, I have the following Controller Listing and Filtering
actions:
def list
@eng_sense_pages, @eng_senses = paginate :eng_senses,
2006 Aug 07
4
Problem with Pagination
Hi Guys,
I am trying to paginate the results from a search. When I use actual
constants in the search conditions, it works fine:
def query
@k2_result_pages, @k2_results = paginate (:k2_results,
:conditions => [''e_date >= ? AND
e_date <= ?'', ''2006-07-12'', ''2006-08-12''],
2006 May 23
3
Pagination problem
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
2006 Jan 09
3
Pagination :conditions not working - MySQL v. PostgreSQL, Rails abstraction v. embedded SQL
Hi everyone,
I have this code:
@person_pages, @people = paginate :person, :per_page => 20,
:conditions => [ "username LIKE ? OR first_name LIKE ? OR
last_name LIKE ? OR preferred_name LIKE ?",
"%" + params[:q].downcase + "%",
"%" + params[:q].downcase + "%",
2006 May 23
1
Re: Wierd pagination problem - Unknown options:
> Unfortunately I still get the same error. Here is my code now (the
> commented line works):
>
> def list
> @upload_pages, @uploads = paginate(:uploads, :per_page =>
> 20, :order
> => ''id'')
> # @upload_pages, @uploads = paginate(:uploads, :per_page => 20)
> end
You may have an older version, try using the order_by clause
2006 Jul 11
1
Has And Belongs To Many and Pagination
I''m struggling with the issue of pagination and many to many
relationships.
I have products and categories (a many to many relationship.)
When I go to a category page, I wish to load all products associated
with that category and have pagination of the products.
@category_products = @category.products gives me all the products
associated with the category however, when I try to
2006 May 23
5
Wierd pagination problem - Unknown options: order?
I am trying to use pagination with the order option. I am following
examples I''ve seen all over the web, but I am getting an error. My code
seems simple:
def list
@upload_pages, @uploads = paginate :uploads, :per_page => 20, :order
=> ''id''
end
Yet I keep getting this error:
___________________________________________
2008 Feb 29
7
Moving pagination to the Model
I''m using will_paginate in a Post class method;
[code]def self.list(page)
paginate :per_page => 10,
:page => page,
:include => :user
end[/code]
I can happily use the method on my posts controller index action;
[code]
class PostsController < ApplicationController
def index
@posts = Post.list(params[:page])
respond_to do |format|
2006 Feb 16
1
Pagination help/how to
Hello,
I want to know how can I paginate a set of records. It seems
there is no direct way of doing this, and I am not able to understand the
documentation of paginate, so any pointers on how to do this will be much
appreciated.
To be specific what I want is that the records returned by user.recipes, the
recipes of the particular user be paginated.
My attempt to do this failed because
2006 Jul 05
3
list of users
Hi all,
I''m creating admin module. in that module i need to get the list of
users and also the projects created by the each user.
No doubt i''m getting the list of users. but i''m not getting the list
of projects done by each user..
This is my code::
<% for user in @users %>
<%=link_to
2006 Jul 31
9
Multiple Pagination
I have the following:
def index
begin
@restaurant_pages, @restaurants = paginate :restaurants,
:order => (params[
:sort ] || "name"),
:per_page => 2
@cuisines = Cuisine.find_all
rescue
redirect_to :action => :index
end
end
# sort by cuisine
def
2005 Aug 04
1
Pagination and :include (eager associations)
I have tried to use eager association with pagination, but
the :include option is not supported:
Here''s the one-line pagination call without :include
@link_pages, @links = paginate :link, :per_page => 10, :order_by
=> sort_clause
and here the work around, using the "classic" method
# @link_pages = Paginator.new self, Link.count, 10,
2006 May 14
3
Beginner question on paginate with params and conditions
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,
2006 Jul 03
0
Pagination with acts_as_ferret
Hey there,
Previous to finding ferret I had a test query setup to do pagination
like:
@listing_pages, @listings =
paginate(:listing, :per_page => 10,
:conditions => [" name LIKE ? ", "%" + search_criteria +
"%"],
:order_by => "name ASC")
Can I do similar pagination with @results array returned from a ferret