[thesite] [bug] t.e.o. - Other Articles Written by this Author
.jeff
jeff at members.evolt.org
Fri Nov 16 15:53:28 CST 2001
rudy,
><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
> From: rudy
>
> > 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
><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
except they didn't throw an error when the UNION ALL and one of the other
queries was commented out.
><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
> try ORDER BY 1, 2 desc, 3 desc, 4
><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
this worked, but it didn't give me the results in the order i wanted them.
where are 3 and 4 defined?
i'd like them by foo, content.rating DESC, content.ratings DESC,
content.datemod ASC.
><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
> if that don't work, take the table qualifiers off the
> ORDER BY column names
><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
now this worked.
next question. what if i wanted to sort those records to the top that had
more than 5 ratings, but only if the author had at least 5 articles that had
at least 5 ratings. (i'm trying my best to mimic the highest ranked
articles selection process, but at the author level. honest, this really
does have a purpose)
thanks,
.jeff
http://evolt.org/
jeff at members.evolt.org
http://members.evolt.org/jeff/
More information about the thesite
mailing list