mssql 2005 and above has row_number which would allow pagination. On Tuesday, December 4, 2012 7:49:21 AM UTC-7, Massimo Di Pierro wrote: > > This is a similar problem as mssql which does not support pagination. > I just committed to trunk a new adpater: > > DAL('informix-se://.....') > > please give it a try and see if does what you need. You should be able to > fix the problem just by tweaking the InformixSEAdapter and not the normal > InformixAdapter. Let me know if this work for you. > > Massimo > > On Tuesday, 4 December 2012 05:08:37 UTC-6, Wouter Pronk wrote: >> >> I'm trying to connect web2py to Informix SE (standard engine) with some >> succes. I've edited dal.py and removed the following >> dbms_version = int(self.connection.dbms_version.split('.')[0]) >> if lmin and (dbms_version >= 10): >> # Requires Informix 10.0+ >> sql_s += ' SKIP %d' % (lmin, ) >> if fetch_amt and (dbms_version >= 9): >> # Requires Informix 9.0+ >> sql_s += ' FIRST %d' % (fetch_amt, ) >> because Informix SE doesn't have a limitby function. After the >> modification I can connect to small tables, but it doesn't function with >> large tables. How can I use the fetchmany() function from informixdb? I >> would like to limit to 20 results and than with another function get the >> next 20 results. >> >>
--