[thesite] t.e.o. updates

[rudy]

>    rudy, can you tell me why this silly
>    query always returns the same number
>    for the rank alias?  is it because the
>    subselect is run first and its result
>    is tacked onto each row the main query
>    returns?
>
>         , (SELECT rand.random * 100000000
>              FROM dual
>           ) AS rank

yup, that would explain it

i haven't used oracle's random number generator but your interpretation of
it being run only once and the result used on each row of the outer query
sounds like the answer

rudy