Re: Retrieving Records for a range of primary keys

2009-12-17 Thread Hans Pikkemaat
Hi, This works like a charm. thanks Hans Andrey Razumovsky wrote: 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

Re: Retrieving Records for a range of primary keys

2009-12-17 Thread Andrey Razumovsky
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 > but the ExpressionFactory doesnt ha

Re: Retrieving Records for a range of primary keys

2009-12-17 Thread Hans Pikkemaat
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 Hi, I guess this produces the 'IN' operator. Th

Re: Retrieving Records for a range of primary keys

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

Re: Retrieving Records for a range of primary keys

2009-12-17 Thread Hans Pikkemaat
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

Re: Retrieving Records for a range of primary keys

2009-12-17 Thread Andrey Razumovsky
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 > 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 i

Retrieving Records for a range of primary keys

2009-12-17 Thread Hans Pikkemaat
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 t