Announcement Announcement Module
Collapse
No announcement yet.
How to seperate rows from createQuery Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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, 07:39 AM.
Working...
X