"query contained only ignored words "?

When I try to search a word by an ASP web page, it returns error '80040e14
, The query contained only ignored words'. I know the question maybe asked
for many many times and I do search the Internet but cannot find the answer
right for me.
I use Windows 2003 SP1 and SQL server 2000, all are Chinese Simplified
Edition. According to some articles, I empty the noise.chs in the C:
\windows\system32 and C:\Program Files\Common Files\System\MSSearch\Data
\Config, then re-index the fulltext. But the error still exists. Pls help
me, thanks.
Hi. I've got the answer. I add a space to the noise.chs instead of clear
all the content. thanks!
mizi <haha@.haha.com> wrote in
news:Xns9725D5AB6E7B0hahahahacom@.207.46.248.16:

> When I try to search a word by an ASP web page, it returns error
> '80040e14 , The query contained only ignored words'. I know the
> question maybe asked for many many times and I do search the Internet
> but cannot find the answer right for me.
> I use Windows 2003 SP1 and SQL server 2000, all are Chinese Simplified
> Edition. According to some articles, I empty the noise.chs in the C:
> \windows\system32 and C:\Program Files\Common
> Files\System\MSSearch\Data \Config, then re-index the fulltext. But
> the error still exists. Pls help me, thanks.
>

"Count" formula giving me a fit!

You guys solved my problem last time so I'm counting on you again! :D

I want to count the number of times the word "CAN" appears on my report. So I wrote a formula that is simply this:

Count (["CAN"])

However, it continually returns the value "1" no matter how many times the word is shown on the report. Like it's a boolean or something.

Don't know if this matters, but the field it is counting up is also a formula. Here is that forumla: If {fieldname}=<-0 then "CAN"

I've tried everything, can you please help??Count (["CAN"]) won't work because it will count the number of array elements, but "CAN" is the only element.

Try creating a new formula
if {fieldname}=<0 then 1

and then creating subtotal for this formula with SUM operation.|||That worked great!! Except my formula couldn't have the = sign directly after the field name.

So my formula is:

if {fieldname}<=0 then 1

Thank you greatly!