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:46:16 GMT
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.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
>>>>
>>>>
>>>>
>>>>
>>>>         
>>>
>>>
>>>       
>>     
>
>
>   


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