cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andrey Razumovsky <razumovsky.and...@gmail.com>
Subject Re: Retrieving Records for a range of primary keys
Date Thu, 17 Dec 2009 14:39:08 GMT
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.pikkemaat@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.pikkemaat@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

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message