Uploading to trunk now. Please give it a try. I assuming the FETCH ONLY comes after GROUPBY and ORDERBY.
Massimo On Mar 6, 3:42 pm, DenesL <denes1...@yahoo.ca> wrote: > The previous limitby=(10,30) for mssql: > > rows=cursor.execute('select top 30 * from person').fetchall()[10:] > > The same can be achieved with nested selects as explained > in:http://sqlzoo.net/howto/source/z.dir/tip857849/sqlserverfor --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---