[thesite] t.e.o. updates

[Joshua Olson]

Rudy, Jeff,

Could the top-n query technique outlined in the article be used to calculate
the "page throughs" on the front page of evolt?

The pseudo-logic could be, assuming you want to view articles [article min]
to [article max]:

 select those articles in the top [article max] that are NOT in the top
[article min]

-joshua

----- Original Message -----
From: "rudy" <r937 at interlog.com>
Subject: Re: [thesite] t.e.o. updates

<snip>


: this uses the new RANK() function in oracle 8
:
: i admit, i have never used it before, but i ran across it in the following
: article which i found when searching for "top ten" resources --
:
:   Performing Top-N Queries in Oracle
:
http://gethelp.devx.com/techtips/oracle_pro/10min/10min1200/10min1200.asp
:
: obviously, you may need to adjust WHERE contrank < 6 (which returns the
top
: five) to reflect however many random articles you want out of the subquery