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>
