Hi,

I can't get what I want when I run the following code. It should have 2 records, but only the 1st recordNumber and Callnumber returned. Any one can help me out? Thank you.
================================================== =======
try{
    dbc = new DatabaseConnection();//userdefined class Connection con = dbc.getConnection();
    stmt = dbc.getStatement();
    String sql = "SELECT ITEMRECORDNUMBER, CALLNUMBER FROM ITEM WHERE ITEMRECORDNUMBER = ?";
    PreparedStatement pstmt = con.prepareStatement(sql);
        String strItemRecordNumber = "";
        String strItemCallNumber = "";

        ResultSet rs = null;
    query = "SELECT ITEMRECORDNUMBER FROM ITEM WHERE BIBLIOGRAPHICRECORDNUMBER = '" + strBibliographicRecordNumber + "'";
    rst = stmt.executeQuery(query);
    while (rst.next()){
            strItemRecordNumber = rst.getString(1);
            pstmt.setString(1, strItemRecordNumber);
            rs = pstmt.executeQuery();
            while(rs.next()){
             strItemRecordNumber = rs.getString(1);
                         strItemCallNumber = rs.getString(2);
                         System.out.println (strItemRecordNumber);
                 System.out.println (strItemCallNumber);
                         } rs.close();
        }
        rst.close();
        stmt.close();
        dbc.disconnectDB();
          }catch(SQLException sqle){}

Try your SQL without using a prepared statement. This way you can prove that it isn't the data that is causing the problem.

Cheers

Martyn

Something else you could try is to detetermine the number of records in the result set:

rs.last();
System.out.println("Number of Records: " + rs.getRow());

Cheers

Martyn

I tried your first method, but still only got the 1st record. Is that because I am using the same connection?

Great News!!

I solved the problem by using ArrayList. Methods that I used include add(Object o) and size().

Thanks anyway