Sorting by a Select Field (Taxonomy)

I'm trying to sort an item list by a Select Field that draws it's data from the Taxonomy tree using the "Order By" box . It does sort it, but it sorts it by the ID# of the Field rather than the name itself..which makes little sense (from a usage standpoint). Is it possible to have it sort by the Field value rather than the ID?

Hi harley77,
this is not so easy. But it will work with this (in Order by at the list Module):

Code:

---

(SELECT sorting FROM catalog_tablename AS cs WHERE cs.id=catalog_field) ASC

---

catalog_tablename is the reference... like the taxonomie at your install.

regards

THANK YOU! I bow before your awesomeness, that worked perfectly. I didn't realize we could use SQL statements inside the order By box.