Ruby on Rails
Sunday, December 2, 2012
Hello guys,
I trying to create the conditions of my search, but I have some troubles.
This is the method I'm trying to create in my model.
def self.searchadv(title, place, category, date) !title.blank? ? conditions = ['title LIKE ?', "%#{title}%"] : conditions = [] if conditions !place.blank? ? conditions << [' AND place LIKE ?', "%#{place}%"] : conditions << [] !place.blank? ? conditions << [' AND category LIKE ?', "%#{place}%"] : conditions << [] !place.blank? ? conditions << [' AND date LIKE ?', "%#{place}%"] : conditions << [] else !place.blank? ? conditions << [' place LIKE ?', "%#{place}%"] : conditions << [] !place.blank? ? conditions << [' category LIKE ?', "%#{place}%"] : conditions << [] !place.blank? ? conditions << [' date LIKE ?', "%#{place}%"] : conditions << [] end find(:all, :conditions => conditions) endI get this error
wrong number of bind variables (4 for 1) in: title LIKE ?
if I delete this:
if conditions !place.blank? ? conditions << [' AND place LIKE ?', "%#{place}%"] : conditions << [] !place.blank? ? conditions << [' AND category LIKE ?', "%#{place}%"] : conditions << [] !place.blank? ? conditions << [' AND date LIKE ?', "%#{place}%"] : conditions << [] else !place.blank? ? conditions << [' place LIKE ?', "%#{place}%"] : conditions << [] !place.blank? ? conditions << [' category LIKE ?', "%#{place}%"] : conditions << [] !place.blank? ? conditions << [' date LIKE ?', "%#{place}%"] : conditions << [] endEverything works great, but I need this other options in order to create my search and I don't undertand why the error is in the "LiKE"
Does anyone could help me please?
Thanks in advance!
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@googlegroups.com.
To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msg/rubyonrails-talk/-/6upZgpqP5hMJ.
For more options, visit https://groups.google.com/groups/opt_out.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment