SQLObject ordering

Discussion in 'Python' started by Kevin Dahlhausen, Feb 26, 2004.

  1. 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("Manufacturer")


    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?
    Kevin Dahlhausen, Feb 26, 2004
    #1
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Ian Bicking

    ANN: SQLObject 0.4

    Ian Bicking, Jul 5, 2003, in forum: Python
    Replies:
    0
    Views:
    335
    Ian Bicking
    Jul 5, 2003
  2. Ian Bicking

    ANN: SQLObject 0.5

    Ian Bicking, Nov 1, 2003, in forum: Python
    Replies:
    0
    Views:
    336
    Ian Bicking
    Nov 1, 2003
  3. Robin Munn
    Replies:
    1
    Views:
    345
    Istvan Albert
    Oct 12, 2004
  4. Ian Bicking

    [ANN] SQLObject 0.6.1

    Ian Bicking, Jan 26, 2005, in forum: Python
    Replies:
    0
    Views:
    292
    Ian Bicking
    Jan 26, 2005
  5. nbigaouette

    Z-Ordering (Morton ordering) question

    nbigaouette, Nov 5, 2009, in forum: C Programming
    Replies:
    2
    Views:
    2,147
Loading...

Share This Page