the rows was a cut and past mistake.. it should read results -----Original Message----- From: apdas [mailto:apdas@;iitk.ac.in] Sent: Saturday, 2 November 2002 3:44 AM To: Turbine Users List Subject: Re: [Fwd: Problem using raw SQL querries]
Hi George, Where can I get this village API ? is it a freeware? I donot find this API in TDK jars. And could U please explain what the rows variable means in the for loop ? Regards, A.P.Das. George Papastamatopoulos wrote: > > import com.workingdogs.village.Record; > > -----Original Message----- > From: apdas [mailto:apdas@;iitk.ac.in] > Sent: Saturday, 2 November 2002 3:24 AM > To: Turbine Users List > Subject: Re: [Fwd: Problem using raw SQL querries] > > Thanks George, > > But Could you please let me know what is this Record class and where > will I get this class ? > > Regards, > A.P.Das. > > George Papastamatopoulos wrote: > > > > BasePeer.executeQueryString() will return a Vector of Village Record > objects > > > > You need to do something like > > > > Vector results = BasePeer.executeQueryString() > > for (Iterator i = rows.iterator(); i.hasNext(); ) > > { > > Record item = (Record)i.next(); > > > > String myValue = item.getValue("MY_COLUMN_NAME").asString(); > > Long myLongVal = item.getValue("MY_LONG_COLUMN_NAME").asLongObj(); > > > > etc... > > } > > > > george > > > > -----Original Message----- > > From: apdas [mailto:apdas@;iitk.ac.in] > > Sent: Saturday, 2 November 2002 2:55 AM > > To: Turbine User > > Subject: [Fwd: Problem using raw SQL querries] > > > > Hi friends, > > > > My problem is not regarding executing raw SQL querries.My real problem > > is how to retrieve value of individual elements using foreach syntax ( > > or some other means) > > > > Please help me. > > > > Regards, > > A.P.Das > > > > -------- Original Message -------- > > Subject: Problem using raw SQL querries > > Date: Fri, 01 Nov 2002 10:35:40 -0500 > > From: apdas <[EMAIL PROTECTED]> > > Organization: IIT Kanpur > > To: Turbine User <[EMAIL PROTECTED]> > > > > Hi friends, > > > > I am using raw SQL querries to retrieve a row set. > > > > My query looks like this. > > > > Vector v=BasePeer.executeQuery("select * from TURBINE_GROUP where > > GROUP_NAME='global'"); > > > > I want to retrieve values of individual elements from this vector. > > But when I use foreach syntax I get the total row set. > > > > My result looks like this > > > > {'1','global','null'} > > > > How do I retrieve individual elements from this ? > > > > I donot want to use peers. > > Please help me. > > > > Regards, > > A.P.Das. > > -- To unsubscribe, e-mail: <mailto:turbine-user-unsubscribe@;jakarta.apache.org> For additional commands, e-mail: <mailto:turbine-user-help@;jakarta.apache.org> -- To unsubscribe, e-mail: <mailto:turbine-user-unsubscribe@;jakarta.apache.org> For additional commands, e-mail: <mailto:turbine-user-help@;jakarta.apache.org>
