Search area

Hi,

I've implemented two boxes of research which correspond to two columns of my table. This solution works well:

In my index.html.erb:   <% form_tag search_intervenants_path, :method => :get do %>     <%= label_tag "code" %>     <%= text_field_tag "search[by_code]", params[:search].try(: , :code) %>     <%= label_tag "id" %>     <%= text_field_tag "search[by_id]", params[:search].try(:, :id) %>       <%= submit_tag "Search" %>     <% end %>

In my controller: def search         @intervenants = Intervenant.search(params[:search])     render :index   end

In my model: def self.search(params)       params.keys.inject(scoped({})) do |found, k|       params[k].blank? ? found : found.send(:"#{k}", params[k])         end   end    scope :by_code, lambda {|name| where("intervenants.code LIKE ?", "%#{name}%")}    scope :by_id, lambda {|name| where("intervenants.id LIKE ?", "%#{name}%")}

I would like to have an only search area, I tried but I didn't suceed in it... Who can help me? Thanks a lot !

have you tried Intervenant.where("code like ? or id like ?", params[:search], params[:search]).

consider using searchlogic gem.