[prev in list] [next in list] [prev in thread] [next in thread] 

List:       turbine-torque-user
Subject:    How to compare two columns in one table
From:       "Colin Chalmers" <colin.chalmers () maxware ! nl>
Date:       2002-08-30 10:13:35
[Download RAW message or body]

Hi guys,

I'm trying to perform a query on a specific table for a situation where
column1=column2, what would be the best/easiest way to do this?

The following code appears to work, but is this the correct way to go about
it?
We're using Torque-3-b4

<snip>
Criteria lCrit = new Criteria();
lCrit.addJoin(FooPeer.COLUM1, FooPeer.COLUMN2);
List lList = FooPeer.doSelect(lCrit);
</snip>

Colin Chalmers
Maxware Benelux



--
To unsubscribe, e-mail:   <mailto:turbine-torque-user-unsubscribe@jakarta.apache.org>
For additional commands, e-mail: <mailto:turbine-torque-user-help@jakarta.apache.org>

[prev in list] [next in list] [prev in thread] [next in thread]