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