Rails - Aug 2007 - Cannot get simple search by date to work with will_paginate

View:

<% form_tag attendances_path, :method => ''get'' do %>
	<p>Search attendances by date:
		<%= date_select :search, params[:search], :use_short_month =>
true, :order => [:month, :day, :year] %>
		<%= submit_tag ''Search'', :name => nil %>
	</p>
<% end %>


Model:

def self.search(search, page)
    paginate :per_page => 10, :page => page,
             :conditions => [''date like ?'',
"%#{search}%"],
             :order => ''date desc''
end


Controller:

def index
    @page_title = ''Attendances''
    @attendances = @school.attendances.search(params[:search],
params[:page])
end

Why is this not working? Thanks for any help!


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

What isn''t working? What''s the error?  What is the expected
behaviour?
How does the actual behaviour differ from the expected?

Is it necessary for you to define a search method in your model,
rather than just call @school.paginate(:all, :conditions => blah)?

Adam


On 8/8/07, jko170 <jko170-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>
wrote:
>
> View:
>
> <% form_tag attendances_path, :method => ''get'' do
%>
>         <p>Search attendances by date:
>                 <%= date_select :search, params[:search],
:use_short_month =>
> true, :order => [:month, :day, :year] %>
>                 <%= submit_tag ''Search'', :name =>
nil %>
>         </p>
> <% end %>
>
>
> Model:
>
> def self.search(search, page)
>     paginate :per_page => 10, :page => page,
>              :conditions => [''date like ?'',
"%#{search}%"],
>              :order => ''date desc''
> end
>
>
> Controller:
>
> def index
>     @page_title = ''Attendances''
>     @attendances = @school.attendances.search(params[:search],
> params[:page])
> end
>
> Why is this not working? Thanks for any help!
>
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

I guess I don''t need it a search method so I added this to my
controller:

@attendances = @school.attendances.paginate :per_page => 10, :page =>
params[:page],
                                                :conditions =>
[''date
like ?'', "%#{params[:search]}%"],
                                                :order => ''date
desc''

My intended behavior is to simply search attendances by an exact date.
I don''t get an error but no records show up even if I search the
correct date. Also, is there a way to have a cleaner url when
searching that this?

domain.com/attendances?search%5B%282i%29%5D=8&search%5B%283i
%29%5D=8&search%5B%281i%29%5D=2007

Thanks for the help.


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

I really like blinksale''s invoice filter functionality. Is there a
plugin for something like that?


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

blinksale''s invoice filter looks like it''s using a bunch of
custom
routes and then parsing the parameters.  Read up on rails routes to
figure out how to implement these types of urls.

And your conditions look wrong.  If you''re searching by date, and the
date column in your database is a date type, then you shouldn''t be
using ''like''.  You should be using date comparison operators,
such as
=, <, >, <=, >=.

Adam

On 8/8/07, jko170 <jko170-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>
wrote:
>
> I really like blinksale''s invoice filter functionality. Is there a
> plugin for something like that?
>
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

Got it to work! Thanks for your help.


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

jko170 wrote:
> Got it to work! Thanks for your help.
Hi I do face same type of issue in my project can u share how u over 
come that...
My mail id is ratnavelps-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org

Thanks in advance
-- 
Posted via http://www.ruby-forum.com/.

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---