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

Sqlalchemy does not seem to like the order by argument which I suspect has 
something to do with the lack of primary keys in the table that I am trying 
to access. Is it necessary to have primary keys defined for this statement to 
work or have I misunderstood? 
Thanks very much once again.
MJ
On Saturday 30 September 2006 04:24, Jonathan Ellis wrote:
> 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

-------------------------------------------------------------------------
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