Hello, 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. Has anyone had any experience with this issue and workarounds for it? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:357486 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
