[thesite] t.e.o. updates

[.jeff]

rudy,

><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
> From: rudy
>
> that's causing the error, but rather
>
>    SELECT contentid, rand.random AS randum
>    RANK() OVER
>    (ORDER BY randum ASC NULLS LAST) AS contrank
>      FROM content
>
> which, i figured, was a faithful reproduction of the
> syntax i saw in that devx article
><><><><><><><><><><><><><><><><><><><><><><><><><><><><><

yup, that's indeed what's causing the error as i get the same error when i
try to run the above by itself.

i double-checked the syntax (from the article about top-n queries that you
posted) and everything is kosher.  i don't know why it won't work for us
here.

thanks,

.jeff

http://evolt.org/
jeff at members.evolt.org
http://members.evolt.org/jeff/