Fulltext Search

[Marc]

Apologies if this is not the correct place to put this.

I wrote this query to perform a fulltext search on tblPages.

SELECT * FROM tblPages,
FREETEXTTABLE(tblPages, *,@searchTerm) searchTable
WHERE [KEY] = tblPages.PageID ORDER BY RANK DESC

Where PageID is the primary key.

The synax is correct but why does it never return any results?

thanks

marc

[Simon Hayes]

"Marc" <ma**********@gmail.com> wrote in message
news:11*********************@o13g2000cwo.googlegro ups.com...

Apologies if this is not the correct place to put this.

I wrote this query to perform a fulltext search on tblPages.

SELECT * FROM tblPages,
FREETEXTTABLE(tblPages, *,@searchTerm) searchTable
WHERE [KEY] = tblPages.PageID ORDER BY RANK DESC

Where PageID is the primary key.

The synax is correct but why does it never return any results?

thanks

marc

I have no idea - does SELECTing only from FREETEXTABLE return any results?
Without seeing table DDL and data, it's almost impossible to say, so you
should probably put together a script which others can run in Query Analyzer
to reproduce your problem. You might want to post to
microsoft.public.sqlserver.fulltext, as you may well get a better response
there.

Simon

[Marc]

No it doesnt! Found microsoft.public.sqlserver.fulltext.

thanks for the advice.