rubyonrailsin

Try this:

@product = Product.find(:first, :conditions => ["title like ?", "%#{name}%"])

Hope this helps...

Jeffrey L. Taylor wrote:   

Quoting Leah Antkiewicz <lists@ruby-forum.com>:     

Rolling Rock. I tried the following but it doesn't work: @find = Product.find(:first, :conditions => ["title.include? '#{name}'"])  I get this error: ActiveRecord::StatementInvalid in SearchController#results Mysql::Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'include'#{name}')  LIMIT 1' at line 1: SELECT * FROM `products` WHERE (title include'#{name}')  LIMIT 1        

@find = Product.find(:first, :conditions => ["title like '?'",  "%#{name}%"])  This code is untested, but I would expect to work.  Jeffrey     

 Thanks for the help Jeffrey but I still get the same error that I posted  above. I altered your code to this: @find = Product.find(:all, :conditions => ["title LIKE '#{name}'"]) and got it to work when I enter the full name again but when I add in  the % signs it tells me: @find = Product.find(:all, :conditions => ["title LIKE '%#{name}%'"]) malformed format string - %R  Any suggestions on why the % doesn't work?