Ok, I know I am not the first to want to do this but for the life of me I can not find any useful CF examples of what I would like to do.
I have switched a high traffic website (CF5.X) from Verity to MSSQL's Full text search (FREETEXTTABLE). It works but as expected the results are not as good. The reason we switched was the processing overhead for verity searches were much too high on this website. The site generates 1-2 million page views a month. Because I am somewhat involved in another project I was looking for some CF code that would pre-process the user input, extract the noise words, remove invalid characters and return either a string that can be used with the CONTAINSTABLE function eg: take search string "Parse the % text string" and turn it into "parse NEAR text NEAR string" or "parse NEAR text and string" or some permutation that can be used in a full text search query. Does anyone have some sample code that they are willing to share? Best Regards, Dennis Powers UXB Internet - A website design and Hosting Company 690 Wolcott Road P.O. Box 6029 Wolcott, CT 06716 Tel: (203)879-2844 http://www.uxbinternet.com/ http://www.uxb.net/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Macromedia ColdFusion MX7 Upgrade to MX7 & experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274034 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4