Re: Retrieving Records for a range of primary keys

From: Hans Pikkemaat (h.pikkemaa..si-solutions.nl)
Date: Thu Dec 17 2009 - 09:35:57 EST

  • Next message: Andrey Razumovsky: "Re: Retrieving Records for a range of primary keys"

    Hi,

    I guess this produces the 'IN' operator.
    This would mean I need to produce all the key values in the range I want
    to retrieve?

    Is there not a betweenDbExp?

    tx

    Hans

    Andrey Razumovsky wrote:
    > If you're using SelectQuery, Expression.inDbExp() is for you to go. See
    > http://cayenne.apache.org/doc/path-expressions.html
    >
    > 2009/12/17 Hans Pikkemaat <h.pikkemaa..si-solutions.nl>
    >
    >
    >> Hi,
    >>
    >> Some paginated mechanisms are based on a persistence layer to be able to
    >> retrieve records for a range of primary keys.
    >>
    >> I know it is possible to insert the primary key field in the definition but
    >> then I'm also required to populate it
    >> when I create a record. I'm using a sequence generator to determine the key
    >> value of a new record.
    >>
    >> So my question is: without having to insert the key field in the
    >> definition, is it possible to query the table
    >> by primary key range, and if yes, how?
    >>
    >> tx
    >>
    >> Hans Pikkemaat
    >>
    >>
    >>
    >
    >
    >

    This archive was generated by hypermail 2.0.0 : Thu Dec 17 2009 - 09:37:26 EST