You could cheat of course. For example, consider this class:
class Person(SQLObject):
firstname = StringCol(length=255)
lastname = StringCol(length=255)
To achieve what you want you could then do the following:
people = Person.select("""person.id > 0 ORDER BY firstname, lastname DESC""")
You have to have something before the orderby clause that will always
be true of course and this assumes that your id will always be > 0
(which is normally the case).
If you have ORDER BY on it's own, the query comes out like:
SELECT person.FirstName, person.LastName FROM person WHERE ORDER BY
firstname, lastname DESC
This is invalid syntax. :)
Lee
On 1/5/06, zgoda <[EMAIL PROTECTED]> wrote:
>
> The doc you mention says it's possible.
>
> """
> You can use the keyword arguments orderBy to create ORDER BY in the
> select statements: orderBy takes a string, which should be the database
> name of the column, or a column in the form Person.q.firstName. You can
> use "-colname" to specify descending order, or call
> MyClass.select().reversed().
> """
>
> Anyway, I don't know how to make ordering by 2 columns, one asc and one
> desc.
>
> Cheers
> Jarek Zgoda
>
>
