Thanks George for your quick response. But let me know where from can I get the Village jars. Is there any other class in turbine API which can do the work of Record ?
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> -- To unsubscribe, e-mail: <mailto:turbine-user-unsubscribe@;jakarta.apache.org> For additional commands, e-mail: <mailto:turbine-user-help@;jakarta.apache.org>
