Retriving data from table

[Ian Cockcroft]

Hi all, the following code gets data from an ACCESS database.
I need to put the data in textFields and a checkBox, why is so difficult?
OrderDate is a DATE field.
OrderFilled is a Yes/No filled.
How should I be doing it?
Regards
Ian

  
Object objOrderNo = orderNo.getSelectedItem();
//statement and connection declared and 
//conneccted previously
qStmt2 = con.createStatement();
//resultset rs
rs1 = qStmt2.executeQuery("SELECT * FROM 
         + Ord where OrderNo = " + objOrderNo);

int intOrderDate = rs1.getInt("OrderDate");
booleanboolOrderFilled = rs1.getBoolean
         + ("OrderFilled");
txtOrderDate.setText(stringOrderDate);
orderFilled.setSelected(boolOrderFilled);

I get the following error aswell, when i comment out the setText() code:
Connection error : java.sql.SQLException: [Microsoft][ODBC Driver Manager] Invalid cursor state
this really is confusing, i have no idea,
any can help?

[mustang india]

u have to place the cursor at the begining of the result set. All u have to do is put ur data retrivel code inside
//supposing that there is only one row fetched.
if(rs.next()) {
}
rs.next() puts the cursor pointing to the first row fetched by the resultset, if it has fetched something. If there are no rows selected, it returns false.