cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andrus Adamchik <and...@objectstyle.org>
Subject Re: How to?
Date Fri, 16 Jan 2009 12:30:55 GMT
Then I don't understand what you are trying to fetch. Could you  
explain the meaning of the query?

Thanks,
Andrus

On Jan 16, 2009, at 2:17 PM, Sid Ferreira wrote:

> select1 = new SelectQuery(UsuariosClientes.class);
> select1 
> .andQualifier 
> (ExpressionFactory.matchDbExp(UsuariosClientes.CD_CLIENTE_PK_COLUMN,
> this.cdCliente));
>
> Didn't worked...
>
> On Fri, Jan 16, 2009 at 8:38 AM, Andrus Adamchik <andrus@objectstyle.org 
> >wrote:
>
>> Hi Sid,
>>
>> Two possible approaches:
>>
>> 1. (preferred) matching on a related object. That's the point of  
>> ORM after
>> all to work with objects, not DB keys.
>>
>> 2. If this is not possible, you can use the same approach as with PK
>> matching. The only difference is that there's no generated constant  
>> for the
>> FK, so you'd specify a string column name. E.g., continuing with  
>> your code
>> example:
>>
>> select1.andQualifier(ExpressionFactory.matchDbExp("fk_column",  
>> value));
>>
>> Andrus
>>
>>
>> On Jan 15, 2009, at 9:34 PM, Sid Ferreira wrote:
>>
>> qualifier1 =
>>> ExpressionFactory 
>>> .matchExp("db:"+UsuariosClientes.CD_CLIENTE_PK_COLUMN,
>>> getCdCliente());select1 = new SelectQuery(UsuariosClientes.class,
>>> qualifier1);
>>>
>>> How to make a select using a PFK (primary key AND foreign key)  
>>> field?
>>>
>>> --
>>> Sidney G B Ferreira
>>> Desenvolvedor Web - Tibox Innovations
>>>
>>
>>
>
>
> -- 
> Sidney G B Ferreira
> Desenvolvedor Web - Tibox Innovations


Mime
View raw message