Results 1 to 1 of 1

Thread: How to seperate rows from createQuery

  1. #1

    Thumbs down 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
  •