> Not joking, I would'n take the responsibility of such a political issue. > Ask them to define themselves what the rank of every one should have,
Well, management at the law firm has now said "I don't want those egotist controlling their rank, do a count on the search term and rank by that". (Exact quote!!!) So, there ya go, the word comes down from on high. OK, so back to my original question - do a count, read that back into a new query object, and sort from there? Or is there a better way? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307876 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4