Invalid cursor state

[jan frank]

Hi,

Any suggestions & solutions about this elusive error message? [Microsoft][ODBC Driver Manager] Invalid cursor state.
This is the bit of code that gives that error:

<table border ="3" width = "50%">
   <tr>
         <td width = "20%"> <img src="images/multipic.jpg" width="227" height="170"></td>
         <td width = "80%">
 <%
String sql1 = "SELECT tblHomePage.welcome_note FROM tblHomePage";
Connection con1 = null;
       try
     {
   Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
   con1 = DriverManager.getConnection("jdbc :-o	 dbc:IVES","","");
   Statement stmt1 = con1.createStatement();
       ResultSet rs1 = stmt1.executeQuery(sql1);
%>
 
  <% 
   while (rs.next()) {
   System.out.println(rs1.getString("welcome_note")); 
    }
%>
 
  <%
 
   rs1.close();  //close the resultset
   }//end of try
 
   catch(SQLException e)
   {
       out.println(e.getMessage());
   }
%>
   </td>
   </tr>
 
</table>   

Thanks

[David O'Meara]

while (rs.next()) {
System.out.println(rs1.getString("welcome_note"));
}

Which result set are we referring to?

[jan frank]

oops! the resultset should have been rs1 not rs.
I resolved the problem