It has since 3.0. It's already in beta (and RC1 will likely be this year), so I advice you to switch. Otherwise, try
Expression exp = new ASTBetween(new ASTDbPath(pathSpec), value1, value2); (not sure this is complatible with 2.0) 2009/12/17 Hans Pikkemaat <h.pikkem...@tsi-solutions.nl> > but the ExpressionFactory doesnt have betweenDbExp. > > I'm using version 2 btw > > > Andrey Razumovsky wrote: > >> 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
