cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Hans Pikkemaat <h.pikkem...@tsi-solutions.nl>
Subject Re: Retrieving Records for a range of primary keys
Date Thu, 17 Dec 2009 14:35:57 GMT
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
>>
>>
>>     
>
>
>   


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