From: Mark Toth <mark.toth@...>
Date: 2007-12-30T04:11:53+09:00
Subject: Re: String highlighting problem (newbie)

Thanks for your answer.

I have now used the following for the 1.:

a1 = "+"
a2 = "*"
@searchstring = params[:searching].gsub(" ", "* +")
@results = Product.find_by_sql("SELECT * FROM products WHERE MATCH 
(name,sku) AGAINST ('"+a1+@searchstring+a2+"' IN BOOLEAN MODE) order by 
name desc LIMIT 0,50;")

It works, BUT not for numbers. Any idea why it coesn卒t work for numbers?
If I have example: "this is 34" in the database. It works fine "this 
is", but as soon as I enter the "34" it shows no results.



About 2:

Brute force method? - What do you mean by this?

ar = @string.split(' ')
ar[1] = "<b>#{ar[1]}</b>"
ar[3] = "<b>#{ar[3]}</b>"
@string = ar.join(' ')


-- 
Posted via http://www.ruby-forum.com/.