[web2py] limitby not working

Hi, I have a database of lamps, I was trying to show paginated records from lamps table. I could not find limitby working. My code is: lamps = db().select(db.lamps.ALL, limitby=(offset, limit)) But, I get records only in the rage 0 to limit starting from offset To clarify, if I have 7 records

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