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 wrote:
>
> When I call a proc with no noise words it wo
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 to
> 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
native for
searching by company name. Not elegant, but functional.
On Thu, Jan 23, 2014 at 1:24 PM, Russ Michaels 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 wrote:
&g
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 wrote:
>
> I tried that, and it did not make a difference. I still get the
> informational message with option on or off.
>
>
> On Thu,
st 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
>
l. 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
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 noi
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...
~~~
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 "sam
10 matches
Mail list logo