And How i use the join?( where a.idt=b.idt and)

[ ]�s
----- Original Message -----
From: "Leandro Rodrigo Saad Cruz" <[EMAIL PROTECTED]>
To: "OJB Users List" <[EMAIL PROTECTED]>
Sent: Monday, July 28, 2003 5:03 PM
Subject: Re: Query


Using QueryByCriteria !

On Mon, 2003-07-28 at 16:51, Cesar wrote:
> People
> I have one query
>
> SQL = select a.idt, a.desc from table1 a, table2 b where a.idt=b.idt and
> b.idUser=?
>
> I need execute this query to recover one object, but i can�t set the bind
> variable using the code below
>
> Query query = QueryFactory.newQuery(MyClass,Queries.SQL);
>  PersistenceBroker broker = getPersistenceBroker();
>  Object object = broker.getObjectByQuery(query);
>   broker.close();
>  return object;
>
> How I make to set the "bind" variable?
>
> [ ]�s
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
--
Leandro Rodrigo Saad Cruz
IT - Inter Business Tecnologia e Servicos (IB)
http://www.ibnetwork.com.br
http://db.apache.org/ojb
http://xingu.sourceforge.net


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to