Return-Path: Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm Delivered-To: mailing list torque-user@db.apache.org Received: (qmail 60547 invoked from network); 12 Apr 2003 00:56:08 -0000 Received: from smtp3.brturbo.com (HELO smtp.brturbo.com) (200.199.201.47) by daedalus.apache.org with SMTP; 12 Apr 2003 00:56:08 -0000 Received: from ricardo (unknown [200.203.185.8]) by smtp.brturbo.com (Postfix) with SMTP id 11B6711E911 for ; Fri, 11 Apr 2003 21:54:30 -0300 (BRST) Message-ID: <001501c300b0$5b9b3bd0$8b00000a@ricardo> From: "Ricardo Lecheta" To: "Turbine Torque Users List" References: Subject: Re: SELECT TABLE.FIELD FROM TABLE. How do I do this? Date: Fri, 11 Apr 2003 21:59:49 -0700 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N Thank you Gareth, the code worked, but it shows a list of Record objects. I would like that the list was of Pessoa objects. ----- Original Message ----- From: "Gareth Boden" To: "Turbine Torque Users List" Sent: Friday, April 11, 2003 1:16 AM Subject: Re: SELECT TABLE.FIELD FROM TABLE. How do I do this? Is there a way to do it? Ricardo > SELECT TABLE.FIELD FROM TABLE // only a field of the table > I tried to do it like this: > > Criteria c = new Criteria(); > c.addSelectColumn(PessoaPeer.NOME); > PessoaPeer.doSelect(c); > Could you please tell me the right way to do it ? Use something like: List l = PessoaPeer.doSelectVillageRecords(c); for (Iterator it = l.iterator(); it.hasNext(); ) { Record r = (Record) it.next(); Object valueInColumn1 = r.getValue(1).asObject(); } Gareth --- Development Team Leader, eGS, 5-7 Singer Street, London EC2A 4BQ. +44 (0)20 7336 1440 CONFIDENTIALITY: This is email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of eGovernment Solutions (UK) Ltd. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, or copying of this email is strictly prohibited. If you have received this email in error please contact the sender. --------------------------------------------------------------------- To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org For additional commands, e-mail: torque-user-help@db.apache.org