[SQLObject] Best way to order columns

[Mark M. <ma...@di...>]

I have two questions:

1) What is the best way force a particular order to the columns returned by 
a select()?

By this I do not mean sorting records - I mean the order of the columns.  
So for a given select(), SQLObject returns the columns in the order they 
appear in the database.  Is there a way to specify a new default in which 
they are returned, or do I have to reorder them myself after I do a 
select()?

2) In terms of sorting records, it appears that when I specify a join, I 
can use the orderBy keyword and pass it a list and it will happily sort the 
items based on the order of the items in the list (at least it appears to 
work that way).  However the _defaultOrder class variable will not take a 
list.  Is there any way to specify more than one parameter to the SQL that 
is generated for the "ORDER BY" clause as the default for select()?

-- 
Thanks,
Mark.