As much as I liked Middlekit, SQLObject is my new favorite. It's just
so clean. I haven't been able to figure out how to order the results
of a select by an attribute that is another SQLObject (Foreign Key):
class Car:
manufacturer = ForeignKey("Man ufacturer")
class Manufacturer:
name = StringCol()
I'd like to run a select on Car and have the results return sorted by
Manufacturer name. Normally, it would just be a matter of passing the
attribute name into the select statement as an orderBy keyword, but
foreign keys work differently.
Does anybody know how to do this?
so clean. I haven't been able to figure out how to order the results
of a select by an attribute that is another SQLObject (Foreign Key):
class Car:
manufacturer = ForeignKey("Man ufacturer")
class Manufacturer:
name = StringCol()
I'd like to run a select on Car and have the results return sorted by
Manufacturer name. Normally, it would just be a matter of passing the
attribute name into the select statement as an orderBy keyword, but
foreign keys work differently.
Does anybody know how to do this?