Page 1 of 1
changing search from "exact" to "like":
Posted: Sun Feb 15, 2009 11:51 pm
by rohitsrivastava
Hi,
I am using "Simple Search" searching control..but this existing search is somethng like
"exact search" i want to convert it with "Like"
changing search from "exact" to "like"....
For Example:- i want to search product "charm gold swirl wings" it would only show up on a search of the word "gold" or "wing" separately , but not gold wing...
what we have to do for applying this functionality ....
is it possible or not?
your help will highly appreciable....
Thanks in advanced.....
Regards
Rohit
Re: changing search from "exact" to "like":
Posted: Mon Feb 16, 2009 5:51 am
by mazhar
Simple search is based on like. Make use of wild card characters for this purpose for example use *gold* to search word gold in any where in string.
Re: changing search from "exact" to "like":
Posted: Fri Mar 20, 2009 5:34 pm
by blackstonemedia
mazhar wrote:Simple search is based on like. Make use of wild card characters for this purpose for example use *gold* to search word gold in any where in string.
Customers are not going to enter *. How can we modify the simple search to do what the OP is asking?
Re: changing search from "exact" to "like":
Posted: Sat Mar 21, 2009 1:34 am
by mazhar
The other possible solution could be to write your custom search component to replace the standard one.
Re: changing search from "exact" to "like":
Posted: Sat Mar 21, 2009 9:51 am
by Mike718NY
I was told the next release of AC7 is going to offer
Microsoft Full Text Search as an option.
Full Text search is great. I used it on another ecommerce website I wrote.
It returns the most relevant searches to the top
(I achieved that by tweaking the SQL in the stored procedure).
It also searches by word inflections (different forms of the same word).
If you search "women" it will also return results for "Women's ".
I believe the search on a website is the most important feature
to have for an ecommerce store. I was checking the shopping cart
table in the database and about 70% of those items were added there from Searches.
If a customer can't find what they want fast, they leave.
Re: changing search from "exact" to "like":
Posted: Sat Mar 21, 2009 12:27 pm
by blackstonemedia
mazhar wrote:The other possible solution could be to write your custom search component to replace the standard one.
I don't understand how this is an acceptable answer. This is supposed to be a fully featured, top-of-the-line ecommerce application but the search, to be honest, sucks.