Re: select statment from db with more than one order by clause

just put more than one column in the order list:

db.users.select(order_by=[db.users.c.name, db.users.c.email])

On Fri, 29 Sep 2006 11:06:59 +0100, "Mary Jane Boholst"
<[email protected]> said:
> Hi,
> I am trying to use sqlsoup to select items from a table in a database 
> from within a .spy file, however I need to be able to specify two order 
> by clauses and do not seem to be able to do this. Does anyone have any 
> suggestions as to how I might go about this.
> Sorry if I am not making much sense. Let me know if you need me to 
> explain a bit better.
> Thanks in advance,
> MJ
> 
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share
> your
> opinions on IT & business topics through brief surveys -- and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> Spyce-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/spyce-users
-- 
C++ is history repeated as tragedy. Java is history repeated as farce.  --Scott McKay


-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys -- and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV