thanks a lot man its work!!!!! On 13 nov, 12:53, Jonathan LaCour <[EMAIL PROTECTED]> wrote: > [EMAIL PROTECTED] wrote: > > I need a return array with START and LIMIT to create a pagination > > return in CLASS > > > Who do its possible in elixir? > > The SQLAlchemy Query object supports both `limit` and `offset` methods. > Here is an example for a "Person" entity: > > class Person(Entity) > name = Field(Unicode) > age = Field(Integer) > > ... lets say you want to query for all people over the age of 21, but > you want to enforce a limit of 20 and and offset of 10: > > people = Person.query.filter(Person.age>21).limit(20).offset(10) > > Good luck. I suggest consulting the SQLAlchemy documentation at > sqlalchemy.org for more information on the Query object. > > -- > Jonathan LaCourhttp://cleverdevil.org
--~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "SQLElixir" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlelixir?hl=en -~----------~----~----~----~------~----~------~--~---
