[thesite] [bug] t.e.o. - Other Articles Written by this Author

[rudy]

>Oracle Error Code = 904
>ORA-00904: invalid column name

heh

well, it's partly helpful


> i tried each select separately to make sure it wasn't an issue
> with the special sort column and they worked just fine.

then it's gotta be the columns in the ORDER BY

try   ORDER BY 1, 2 desc, 3 desc, 4

this uses ordinal column numbers, which i *think* is phased out in sql3,
but should still be backwards compatile (and our version of oracle is sql2,
i think)

if that don't work, take the table qualifiers off the ORDER BY column names

rudy