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 <[email protected]
>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