Full Text Search Ranking

[dc8johnson]

Is it possible to change the ranking values for the full text search? Right now it is:

Code: Select all

SELECT [KEY], (RANK * 2.0) AS weightRank FROM CONTAINSTABLE(ac_Products, Name, @keyword)
UNION ALL
SELECT [KEY], (RANK * 2.0) AS weightRank FROM CONTAINSTABLE(ac_Products, Sku, @keyword)
UNION ALL
SELECT [KEY], (RANK * 2.0) AS weightRank FROM CONTAINSTABLE(ac_Products, ModelNumber, @keyword)
UNION ALL
SELECT [KEY], (RANK * 2.0) AS weightRank FROM CONTAINSTABLE(ac_Products, SearchKeywords, @keyword)
UNION ALL
SELECT [KEY], (RANK * 1.5) AS weightRank FROM CONTAINSTABLE(ac_Products, Summary, @keyword)
UNION ALL
SELECT [KEY], (RANK * 1.0) AS weightRank FROM CONTAINSTABLE(ac_Products, [Description], @keyword)
UNION ALL
SELECT [KEY], (RANK * 1.0) AS weightRank FROM CONTAINSTABLE(ac_Products, ExtendedDescription, @keyword)

Our client would prefer to weight the SKU highest, then Name.
Thanks!

[jmestep]

That is in Able compiled code. You can change it if you have the source code. I pulled the code out of their source code and adapted it for a webpage search function and I was able to adjust the rankings in my code.

[dc8johnson]

Thanks Judy,

That's what I suspected. We're working on getting the source code.

Thanks again,