Re: [web2py] Limitby not working with Oracle with joins

please print the output of db(db.headers.id == db.alarms.header)._select(db.header.name, db.alarms.komment, limitby=(0,5)) -Thadeus On Fri, Feb 26, 2010 at 12:00 PM, SergeyPo wrote: > Limitby clause still is not working with Oracle backend when used in > queries that have any kind of join

[web2py] Limitby not working with Oracle with joins

Limitby clause still is not working with Oracle backend when used in queries that have any kind of join, left or inner. db.define_table('headers', SQLField('name', 'string') ) db.define_table('alarms', SQLField('header', db.headers), SQLField('komment', 'string') ) data = db(db.heade