A clause of the query contained only ignored words

Using FULL-Text search in SQL server and fornt end is VB6.0
My SQL statement is:
"Select English,Japanese from (select English,Japanese from S_R_J_E
where CONTAINS(English,'WWW')) as EJ where English='WWW' "
But it cause problem when exact match for "WWW" is not found in
database and error message is shown:
"A clause of the query contained only ignored words."
I already known that it caused for noise.* files.
But how I can solve it.
Pls help.
Molay Ash
Molay
---
Posted via http://www.mcse.ms
---
View this thread: http://www.mcse.ms/message336819.htmlI don't do a lot of fulltext, but try this and see if it works any better
Select English,Japanese from S_R_J_E
where CONTAINS(English,'WWW')) and English='WWW'
It seems kind of strange that you would need to search for the word WWW with
fulltext when you are requiring that the entire field be EXACTLY 'WWW'.
You might also try the containstable command instead of contains... (Docd
in books on line)
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Molay" <Molay.10qdal@.mail.mcse.ms> wrote in message
news:Molay.10qdal@.mail.mcse.ms...
> Using FULL-Text search in SQL server and fornt end is VB6.0
> My SQL statement is:
> "Select English,Japanese from (select English,Japanese from S_R_J_E
> where CONTAINS(English,'WWW')) as EJ where English='WWW' "
> But it cause problem when exact match for "WWW" is not found in
> database and error message is shown:
> "A clause of the query contained only ignored words."
> I already known that it caused for noise.* files.
> But how I can solve it.
> Pls help.
> Molay Ash
>
> Molay
> ---
> Posted via http://www.mcse.ms
> ---
> View this thread: http://www.mcse.ms/message336819.html
>