You just need to do a select distinct on your Street table? Criteria c = new Criteria() c.setDistinct(true); List streets = StreetPeer.doSelect(c);
Enjoy, Eric Pugh -----Original Message----- From: Schell, Scott A (Scott) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 16, 2002 10:10 AM To: [EMAIL PROTECTED] Subject: Help with Torque and Validations Hi All, This may be a rookie question, just coming on board... Say I have a table of locations: - ID - Address - Street - ... And I want to provide a combo-box for the user of the distinct streets in the table (e.g. select distinct street...). I don't want to have to create a validation table (e.g. Streets) to do that...Do I go into the peer classes and do some work (if so, could someone point me at a similar example). Getting back a vector of distinct streets is perfect...Thoughts/Help? Thanks Scott Schell [EMAIL PROTECTED]
