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"Marc" <marc.birkett@.gmail.com> wrote in message
news:1120751900.865752.25890@.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|||No it doesnt! Found microsoft.public.sqlserver.fulltext.
thanks for the advice.
