search with query and cf_querysort

[vilaine]

I am creating a search page that allows users to be able to enter a search term and also limit the categories they want to search in. Each piece of editorial can be marked with up to 40 different topic areas (categories). So I did a cfsearch to match the search term and then a query after that to narrow it down to only articles that match the categories that were selected.

I know that the results from a regular cfsearch are in the "score" order, most relevant first, going down to least relevant. When using a query after a cfsearch the results aren't in "score" order, so I used Nate Weiss's CF_QuerySort custom tag. You can use that to return the results in the same "score" order after the query.
(I followed the example in this thread

http://www.tek-tips.com/gviewthread.cfm/lev2/4/lev3/31/pid/232/qid/117974)

With the cfsearch and query version and the cfsearch, query and CF_QuerySort custom tag version, I'm not getting the correct results. I can query the db and see that there are other articles that are a LOT more relevant (lot more occurances of the search term) that aren't first. And the score is always 100% even if there's only one occurance of the search term.

And with the CF_QuerySort I'm ending up with empty result rows. I was thinking that it was because those rows weren't applicable and tossed out by the query, but that's not it. No clue what's going on there.

You can see my search page (and search results) at

http://www.dmreview.com/portal_ros.cfm?NavID=297

Not very helpful since the results *look* right, but they're not.


Thanks,
Jessica