cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sid Ferreira <sid....@gmail.com>
Subject Re: How to?
Date Fri, 16 Jan 2009 12:17:44 GMT
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
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message