Matt, I did actually give an explanation of why it doesn't work, perhaps you skipped that. So moving the words around wouldn't work as you are still searching for 3 words near to each other which are not near each other as "my" is not in your collection index. As I said, you need to parse the noise word list to make sure you do not search on any of them, especially if you are dynamically search on values passed from a form. if you want to search on noise words you will need to remove them from the noise list and re-index your collection, then it should work.
Russ -----Original Message----- From: Matt Quackenbush [mailto:[email protected]] Sent: 23 November 2010 22:07 To: cf-talk Subject: Re: (ot) SQL Server Full-Text Search CONTAINS() @ Russ- Thanks for the reply. I've read that page so many times that it's all just gibberish right now. My brain is mush. LOL Suffice it to say, as you stated, when encountered in a FTS search string, noise/stop words block any results from being delivered. @ Ian- I had not tried that prior to your asking, but I have now. No change in the results. @ Everyone- Thank you for your responses. I am putting this one to bed now. :-) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339482 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
