@stream = Stream.find(:all, :joins => "streams as s inner join tags as t on s.id=t.id", :conditions => ['s.name LIKE ? or s.resolution LIKE ? or s.codecname LIKE ? or s.framerate LIKE ? or s.tags LIKE ? or t.name LIKE ?', '%'+params[:search_text]+'%','%'+params[:search_text]+'%','%'+params[:search_text]+'%', '%'+params[:search_text]+'%','%'+params[:search_text]+'%','%'+params[:search_text]+'%'], :select => "name")
SELECT streams.name FROM `streams` . In this no need to give streams.name, so repalce streams.name by just "name". Just try above query -- 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 [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 -~----------~----~----~----~------~----~------~--~---
