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.pikkemaa..si-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.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
>>>
>>>
>>>
>>>
>>
>>
>>
>>
>
>
-- Andrey
This archive was generated by hypermail 2.0.0 : Thu Dec 17 2009 - 09:40:00 EST