Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / Other Technologies / Full-Text Search / July 2004

Tip: Looking for answers? Try searching our database.

Ignored words problem

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Nick Gilbert - 15 Jul 2004 12:41 GMT
Hi,

I'm getting very frustrated with the usual "A clause of the query
contained only ignored words" problem when using fulltext searches.

Is there any way at all I can prevent this error from happening? Is it
safe to change my noise words file to be empty and force a repop? I
really NEED the ability to match pleurals/singulars of the criteria but
I can't use FORMSOF(INFLECTIONAL, "blah") if it's going to keep throwing
errors all the time.

Or is there an external component that will expand my search terms to
include pleurals and search using CONTAINS, but ignore non noise words
so it doesn't generate an error? (If there isn't, someone should write
one!).

Thanks,

Nick...
Nick Gilbert - 15 Jul 2004 12:59 GMT
Why does the below query match the pleurals when I'm not using
FORMSOF(INFLECTIONAL,blah)?

SELECT Category as CategoryName
FROM tblCategory
WHERE FREETEXT(tblCategory.*, 'studios')
  AND FREETEXT(tblCategory.*, 'charts')

Results:

CategoryName
--------------------------------
Studio Chart
Studio Chart, Specialised Stages

I thought you had to use FORMSOF INFLECTIONAL to get it to match pleurals?

Nick...
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.