On Sep 24, 2008, at 11:02 AM, Heston James wrote:
>
> Hi,
>
> Thanks for the response, that gave me a good foot in the door to this.
> I've now appened my existing query with.
>
> .order_by('myobject.created')[:1000]
>
> Which appears to give the desired result set, however, when looking
> through the SQL debug output it seems that the limit their is applied
> using python and not SQL,
issue the slice as [0:1000] and you'll get the LIMIT/OFFSET. Ticket
#1177 will address the [:1000] usage (and others).
--~--~---------~--~----~------------~-------~--~----~
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?hl=en
-~----------~----~----~----~------~----~------~--~---
