-
Aug 17th, 2007, 07:32 AM
#1
How to seperate rows from createQuery
SQL_QUERY = "SELECT dsritem_id,total_cost FROM "
+ "WorkMeasurement WHERE work_id='" + workId
+ "' and item_type_id=1 ";
Query query3 = session.createQuery(SQL_QUERY);
for (Iterator it3 = query3.iterate(); it3.hasNext()
{
Object[] row3 = (Object[]) it3.next();
Integer dsrId = (Integer) row3[0];
Float dsrTotal = (Float) row3[1];
}
here i got 3 records but i want fetch one record at a time and apply some queries on fetched record
Last edited by pramodjagdale25; Aug 17th, 2007 at 07:39 AM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules