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

On Sep 29, 2006, at 6:06 AM, Mary Jane Boholst wrote:

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

Mary,
Here's an example:

select
    foo, bar, toot
from
    tablename
order by
    bar, toot

But you should realize that SQL doesn't have anything to do with SPyce.

bye
Philip


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