help creating sqlalchemy/sqlsoup code for sql query

Mary Jane Boholst <[email protected]> Wed, 4 Oct 2006 11:50:07 +0100
Newsgroups gmane.comp.python.spyce.general
Organization IOP
Message-ID <[email protected]>
Hi again,
Another question which should be fairly simple to answer. I am trying to carry 
out a fairly word query within my spyce code and am not sure how to do it. 
The sql that I want to translate to sqlalchemy is select * from timetable 
where course='LAA' or course='COM' order by day, starttime.
I have tried several times to do this but I get errors trying to do both the 
order by and the where clauses. 
Any help will be gratefully received. 
Thank you all for your help and suggestions. The login token problem is now 
fixed and I have at the moment decided to use the example on the spyce pages 
to help with the displaying of different pages for different users.
Thanks again,
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