arbirk wrote:
I am a newbie and have created a small blog-like app. Im have tried to implement the saerch function following this tutorial: http://snippets.dzone.com/posts/show/1691
Everything seems to work when the searchphase is empty (it finds the 454 rows) but as soon as I start typing it returns nothing. Here is the controller:
def live_search
@phrase = request.raw_post || request.query_string a1 = "%" a2 = "%" @searchphrase = a1 + @phrase + a2 @results = Funktioner.find(:all, :conditions => [ "Description LIKE ?", @searchphrase])
@number_match = @results.length
render(:layout => false) end
The Description-column is text rich and contains the word ledelse, but when searched it returns: 'ledelse=' not found!
One of the puzzels is where the equal sign comes from. It appears also in the logging og the mysql queries.
Can you help me - anyone?
I think your problem is that later Prototypes always try to encode a key=value query string, which doesn't work with request.raw_post.
So add the option
:with => 'phrase'
to your observe_field options, and in your controller have
@phrase = params[:phrase]