Re: [Spyce-users] help creating sqlalchemy/sqlsoup code for sql query

[Jonathan E. <jon...@ca...>]

from sqlalchemy import or_
where = or_(db.timetable.c.course=='LAA', db.timetable.c.course=='COM')
db.timetable.select(where, order_by=[db.timetable.c.day,
db.timetable.c.starttime])

On Wed, 4 Oct 2006 11:50:07 +0100, "Mary Jane Boholst"
<mar...@io...> said:
> 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
> _______________________________________________
> Spyce-users mailing list
> Spy...@li...
> https://lists.sourceforge.net/lists/listinfo/spyce-users
-- 
C++ is history repeated as tragedy. Java is history repeated as farce.  --Scott McKay