db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Olufemi Omojola" <king...@vehiclesense.com>
Subject Issues with select distinct
Date Tue, 11 Feb 2003 08:12:48 GMT
Hi,
  I'm getting started with Torque 3.0, and I've had nothing but joy with the
setup and the basics, such as insertion or selecting all. I'm having a nightmare
of a time (namely 6 hours so far :-)) trying to figure out how to do a SELECT
DISTINCT. I have a database with a VARCHAR column titled part_number, and I'm
using the following code:

Criteria crit = new Criteria();
 crit.addSelectColumn(PartPeer.PART_NUMBER);
 crit.addJoin(PartPeer.PART_NUMBER, PartPeer.PART_NUMBER);
 crit.setDistinct();
 List m = PartPeer.doSelect(crit);

Mime
View raw message