[thelist] Relevancy Algorithm for ASP
Rob Smith
rob.smith at THERMON.com
Wed Mar 5 13:34:02 CST 2003
Ok. Did I do something wrong? I scoped out the CONTAINS and CONTAINSTABLE
queries on M$'s site, and I used their examples. Of course I tried running
the queries as they are and it threw errors: Categories is not full-text
indexed. So I used the full-text indexing wizard and did it on the columns
requested of the queries. So I go back and use the queries:
SELECT FT_TBL.CategoryName, FT_TBL.Description, KEY_TBL.RANK
FROM Categories AS FT_TBL INNER JOIN
CONTAINSTABLE(Categories, Description,
'ISABOUT (breads weight (.8),
fish weight (.4), beers weight (.2) )' ) AS KEY_TBL
ON FT_TBL.CategoryID = KEY_TBL.[KEY]
ORDER BY KEY_TBL.RANK DESC
on the North winds Database and get nothing, when I should get something?
What did I do wrong? or what still needs to be done?
Rob
More information about the thelist
mailing list