[Achim] | Andreas Kostyrka wrote: | | > offset has no function without ORDER BY. | | If changed the second case to | | for record in | query.select(limit=10,offset=10,order_by=LogRecord.c.Id): | print record.Id | | but it still returns the first 10 records. I also tried some | combinations with desc(...) but I always get the same result for both | cases.
To save you further agony, MSSQL doesn't support the OFFSET clause. (At least not up to and including SQL Server 2000 and probably not in 2k5). TJG ________________________________________________________________________ This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ________________________________________________________________________ --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy -~----------~----~----~----~------~----~------~--~---