I really want to change the Search to use Microsoft Full-Text Search.
It gives much better results.
Someone on here said they did it, but they have the source code, . . I don't.
viewtopic.php?f=45&t=8644&p=37152&hilit ... rch#p37152
Is there anyway to add it without having the source code?
Want to use Microsoft Full-Text Search
Re: Want to use Microsoft Full-Text Search
Yes, I'm doing this without source; but you have to write your own search control, results control. FTS is also greatly enhanced if you cache the most recent/popular search results.
Nick Cole
http://www.ethofy.com
http://www.ethofy.com
Re: Want to use Microsoft Full-Text Search
>> but you have to write your own search control, results control.
Could I ask you a big favor and take a look at what you have coded?
I all also be happy to share anything that I come up with when I
start working on this. I have used FTS before and it works great.
On this website, http://www.dcp3.com, I used it. It is good because it
searches by word inflections (different forms of the same word).
If you search "women" it will also return results for "Women's ".
It also brings the most relevant matches to the top, like "Baptismal Stationary",
(but I customized the SQL to do that better).
On thing I don't like about the current search is that if your reverse
the search order of the words, it won't bring up any results. But with FTS,
"Stationary Baptismal" will return the exact same results.
Could I ask you a big favor and take a look at what you have coded?
I all also be happy to share anything that I come up with when I
start working on this. I have used FTS before and it works great.
On this website, http://www.dcp3.com, I used it. It is good because it
searches by word inflections (different forms of the same word).
If you search "women" it will also return results for "Women's ".
It also brings the most relevant matches to the top, like "Baptismal Stationary",
(but I customized the SQL to do that better).
On thing I don't like about the current search is that if your reverse
the search order of the words, it won't bring up any results. But with FTS,
"Stationary Baptismal" will return the exact same results.
Re: Want to use Microsoft Full-Text Search
Sorry - controls are part of a pretty extensive rewrite of site navigation/results, and not mine to share.
Nick Cole
http://www.ethofy.com
http://www.ethofy.com
Re: Want to use Microsoft Full-Text Search
We won't tellnickc wrote:Sorry - controls are part of a pretty extensive rewrite of site navigation/results, and not mine to share.

Joe Payne
AbleCommerce Custom Programming and Modules http://www.AbleMods.com/
AbleCommerce Hosting http://www.AbleModsHosting.com/
Precise Fishing and Hunting Time Tables http://www.Solunar.com
AbleCommerce Custom Programming and Modules http://www.AbleMods.com/
AbleCommerce Hosting http://www.AbleModsHosting.com/
Precise Fishing and Hunting Time Tables http://www.Solunar.com