sorry, wasnt being accurate. yeah, it does that. too much coffee today.

On May 10, 2006, at 8:33 PM, Jamie Wilkinson wrote:

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
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users



-------------------------------------------------------
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
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users

Reply via email to