[thesite] t.e.o. updates

[rudy]

>Oracle Error Code = 923
>ORA-00923: FROM keyword not found where expected

urggle

well, it's probably not where you said, because as far as i know oracle is
pretty orthogonal (sorry, that's rdbms-speak for sql compliant)

in other words, it's probably not

       SELECT contentid
         FROM
            ( SELECT

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

oh well, two queries it is, at least in the interim, until/unless dean or
dan or some other oracle guru steps in...

the only other idea i have is to use a temp table to store the sorted
random contentids in (instead of returning them to the cf code), and then
selecting the first one off that table using min(randum) or something...
but that would require a temp table

now, a temp table is not a bad idea, but i think it means a stored proc,
unless there's a way for cf to pass a couple of queries over and have them
executed as a block?

i dunno, i've never seen an oracle stored proc nor an oracle temp table

oh well


remember my #1 rule -- never give up

i guess i didn't mention corollary #1A -- it's okay to take a rest once in
a while from pounding your head against the wall...