> I am working on a problem that is provide ample frustration. I have a > keyword search on my site. For the most part this > works fine. It is hitting a MSSQL 2012 server with FT Index setup. My > routine for formatting the keywords and everything > is in place and works well. The problem happens when the search condition > contains "noise" words. Simplest example > is a single letter like "big b equipment". When I run the query in > Management Studio, the results are returned, but I get > the informational message: "The full-text search condition contained noise > word(s)." > > The problem is that although it does not error when executing the query, > ColdFusion seems to be determining that the > informational message is the first result set, which is empty. Essentially > any FT search phrase that has noise words > does not work in CF. I am using the cfquery tag to get the results as stored > proc is not possible in this scenario due to > the possible complexity of the search. I can confirm through testing that > this same behavior happens even when using > a test stored procedure with the hard coded SQL statement, so the problem is > definitely how CF is handling the returned > result from the DB server.
You can disable this functionality on SQL Server: http://technet.microsoft.com/en-us/library/ms187914.aspx Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:357487 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
