I am very new at RoR but am trying to tweak the code for the AJAX table from http://dev.nozav.org/rails_ajax_table.html.
I have it all working the way I want except for one line of code:
conditions = ["firstname LIKE ?" , "%#{@params[:query]}%"] unless @params[:query].nil?
I need this to look at multiple fields not just firstname. Any idea how I do this?
unless params[:query].blank? query = "%#{@params[:query]}%" conditions = ["firstname LIKE ? OR lastname LIKE ?", query, query] end
You can add as many OR's as you want as long as you keep adding more query's to the end.
Your database may not like you if you do this, but that's another matter 
-philip