This one time, at band camp, Michael Bayer wrote:
> result = usermapper.select_by(address='[EMAIL PROTECTED]').order_by
>(addresstable.c.address)[4:15]
>
>will add "LIMIT 4 OFFSET 15 ORDER BY addresses.address" to the
>generated query before executing.
I'm not intimately familiar with LIMIT/OFFSET, but shouldn't that slice
operation instead add
LIMIT 11 OFFSET 5
to get the items 5 through 15 from the result set?
-------------------------------------------------------
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
_______________________________________________
Sqlalchemy-users mailing list
Sqlalchemy-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
