[thesite] t.e.o. updates
rudy
r937 at interlog.com
Sat Nov 17 20:25:08 CST 2001
>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...
More information about the thesite
mailing list