[thelist] Relevancy Algorithm for ASP

[Rob Smith]

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