Can you provide an example of usage?
On Tuesday, 4 December 2012 10:23:14 UTC-6, Derek wrote:
>
> 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.
>>>
>>>
--
