Hi can i use 2 result sets and compare them?
ResultSet rs,rs1;
Statement st;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con =DriverManager.getConnection("jdbc
dbc
msdb","admin","");
st=con.createStatement();
rs=st.executeQuery("SELECT DATE1,NAME,SUM(LINE_COUNT) AS LCOUNT,AVG(QUALITY) AS ACCURACY FROM Production GROUP BY DATE1,NAME");
rs1=st.executeQuery("SELECT DATE1,NAME,SUM(LINE_COUNT) AS LB FROM PRODUCTION WHERE QUALITY < 98 GROUP BY DATE1,NAME");
while (rs.next())
{
while (rs1.next())
{%>
<tr bgColor="#FFFFFF">
<td><p><%=rs.getString("DATE1")%> </p>
</td>
<td><p><%="NULL"%> </p>
</td>
<td><p><%=rs.getString("NAME")%> </p>
</td>
<td><p><%=rs.getString("LCOUNT")%> </p>
</td>
<td><p><%=rs.getString("ACCURACY")%> </p>
</td>
<%if ((rs.getString("NAME") == rs1.getString("NAME")) && (rs.getString("DATE1") == rs1.getString("DATE1")))
{%>
<td><p><%=rs1.getString("LB")%> </p>
</td>
<%}%>
</tr>
<%}}%>
</table>
</center>
</div>
<%
con.close();
I get error resultset closed! Y?
PLS REPLY