Actually, I have no street table (and don't want one)...I actually want to figure out how to get a list of streets out of the location table...
(If I had a street table, you are correct, it's easy to do...do you have a solution when there is not a street table)? Scott -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 16, 2002 8:08 AM To: [EMAIL PROTECTED] Subject: RE: Help with Torque and Validations 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] -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
