they werent there; try the latest SVN. On Aug 25, 2006, at 9:27 PM, Sol wrote:
> Hello, > I want to use LIMIT and OFFSET with the UNION construct. Using keyword > arguments to the union function, like > > union( > select([foo.c.id, foo.c.timestamp]), > select([bar.c.id, bar.c.timestamp]), > order_by = ['timestamp DESC'], > limit = 10, > offset = 10, > ) > > didn't work. What i ended up with is: > > union( > select([foo.c.id, foo.c.timestamp]), > select([bar.c.id, bar.c.timestamp]), > order_by = ['timestamp DESC LIMIT 10 OFFSET 10'], > ) > > > Is there a more clean way to do this. Did I miss something? > -- > Cheers, Sol. > > ---------------------------------------------------------------------- > --- > 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 ------------------------------------------------------------------------- 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
