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
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
. 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
I have had this issue before and simply removed the noise words from the
search string first.
On Thu, Jan 23, 2014 at 7:16 PM, Brian Cain bcc9...@gmail.com wrote:
I tried that, and it did not make a difference. I still get the
informational message with option on or off.
On Thu, Jan 23
for
searching by company name. Not elegant, but functional.
On Thu, Jan 23, 2014 at 1:24 PM, Russ Michaels r...@michaels.me.uk wrote:
I have had this issue before and simply removed the noise words from the
search string first.
On Thu, Jan 23, 2014 at 7:16 PM, Brian Cain bcc9...@gmail.com wrote
I tried that, and it did not make a difference. I still get the
informational message with option on or off.
What happens if you call it with CFSTOREDPROC, and specify two
different recordsets?
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
http://training.figleaf.com/
Fig Leaf
When I call a proc with no noise words it works as expected. When I add
the noise words back to the proc, save the cfstoredproc result to a
variable and dump that I get cached=false and executiontime=395. There are
no proc results returned with it.
I even tried adding the cfprocresult tags
here is a very old blog post I did on the subject, this is probably for SQL
Server 2000, but may still be applicable.
http://www.michaels.me.uk/archives.cfm/search/?term=noise+words
On Thu, Jan 23, 2014 at 7:42 PM, Brian Cain bcc9...@gmail.com wrote:
When I call a proc with no noise words
Hi..
In my search criteria when ever i give some noise words i get an error
from sql server...
i have created a table dumped all keywords in that table first check
that table ...that was a solution given by our friend in our discussion
forum..
But i have a brand by name "same" ...wh
Delete "same" from your table of noise words.
best, paul
At 08:22 PM 12/3/00 -0800, you wrote:
But i have a brand by name "same" ...which i cant afford to ignore..
Could anybody provide a solution please...
~~
Struc
10 matches
Mail list logo