On Mar 1, 1:35 am, Michael Graff <[email protected]> wrote:
> I often do the brute-force approach:
>
> cond_string = []
> cont_hash = {}
>
> if params[:search_name]
> cond_string << "(name ILIKE :name)"
> cond_hash[:name] = "%#{params[:search_name]}%"
> end
> if params[:search_address]
> cond_string << "(address ILIKE :name)"
> cond_hash[:address] = "%#{params[:search_address]}%"
> end
>
> conditions = cond_string.join(" AND ")
> Person.all :conditions => [ conditions, cond_hash ]
>
The merge_conditions method (which was protected in previous versions
of rails) and the scoped named_scope are also handy for this sort of
thing.
Fred.
> --Michael
>
> On Sat, Feb 28, 2009 at 6:25 PM, Joshua Partogi <[email protected]> wrote:
>
> > Hi all,
>
> > How do we add a conditions in a ActiveRecord find method when the
> > parameter is available?
>
> > Lets say I want to add this category conditions when the parameter
> > from the client:
> > Product.find(:all, :conditions => [ "c.id = ?", params[:catid])
>
> > Can we dynamically add that conditions to the find method when it is
> > available? Or do I have to manually make an conditional statement when
> > the parameter is available then give a different find method?
>
> > Thanks in advance.
>
> > --
> > If you can't believe in God the chances are your God is too small.
>
> > Read my blog:http://joshuajava.wordpress.com/
> > Follow me on twitter:http://twitter.com/jpartogi
--~--~---------~--~----~------------~-------~--~----~
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 [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---
