[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