SQLSoup results and zip
Christopher Clarke <cclarke-wYfHrJ5eQDBWk0Htik3J/[email protected]> Mon, 5 Feb 2007 15:21:34 -0400
| Newsgroups | gmane.comp.python.spyce.general |
|---|---|
| Message-ID | <[email protected]> |
Hi All
I've taken the plunge and have started porting my database stuff to
sqlsoup
A problem i've encountered is that sometimes i need to get a "column"
from a list or results
so i do a res=zip(*mycur.fetchall()) and res[0] is the first column
etc.
How do i replicate this in SQLSoup?
when i try for example
res=mydb.intraday.select(mydb.intraday.c.symbol=='RBTT',
order_by=[desc
(mydb.intraday.c.trade_date)])
zip(*res) i get
TypeError: zip argument #1 must support iteration
Regards
Chris
-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier.
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642