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...