Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Apache Torque Users List" <torque-user@db.apache.org>
Received-SPF: pass (hermes.apache.org: local policy)
In-Reply-To: <4A2E265BA43ED5408940E6C0815899EB03B5097B@DBLMXS3>
Subject: RE: criteria-problem
To: "Apache Torque Users List" <torque-user@db.apache.org>
Message-ID: 
 <OF7991B145.90624FAF-ONC1257020.002AF8D3-C1257020.002C0595@seitenbau.net>
From: Thomas Fischer <fischer@seitenbau.net>
Date: Tue, 14 Jun 2005 10:00:48 +0200
MIME-Version: 1.0
Content-type: text/plain; charset=US-ASCII


Hi,

the problem is that at the moment, joins between two tables other than
using the = operator are not possible as far as I know.
Perhaps it is possible to split the query into two. The last resort would
be to create the query by hand and use BasePeer.doSelect()

     Thomas
"Dressler,Erik(externe MA)" <Erik.Dressler@Dresdner-Bank.lu> schrieb am
10.06.2005 11:02:04:

>
> hello, everybody!
>
> is it possible to create a criteria for the statement below???
>
> SELECT p.statecode AS Vater, s.statecode AS Nachfolger
> FROM processstate p, processstate s
> WHERE s.lft BETWEEN p.lft AND p.rgt
> AND s.statecode = 'D225'
> ORDER BY p.lft;
>
> i have problems to assign one table two aliases and to select the same
> column twice with two different aliases!!!
>
> i'm completely mystified!!!!
>
> greetz, erik
>
> *  *  *  *  *  *  D I S C L A I M E R  *  *  *  *  *  *  *
>
> This message is confidential and intended for the named addressee(s)
only.
> If you are not the intended recipient, please contact the sender by
E-Mail
> return and then delete this message from your system. You should not copy
> or use it or disclose its contents to any other person.
>
> If any part of this message is illegible or if you suspect that the
message
> may have been intercepted or amended, please contact the sender.
> Dresdner Bank Luxembourg S.A. cannot accept any responsibility for the
> accuracy or completeness of this message without further investigation.
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
>


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org