Yeah, for range you'll need betweenDbExp, I just got mistreated with analogue to paginated queries, which use in
2009/12/17 Hans Pikkemaat <h.pikkem...@tsi-solutions.nl> > 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.pikkem...@tsi-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 >>> >>> >>> >>> >> >> >> >> > > -- Andrey
