I think that rsSN is associated with statement, so we you do 'statement.executeQuery()' that invalidates the current ResultSet. Try using other statement object for the internal querys.
Regards,
___________ Manolo.
[EMAIL PROTECTED] wrote:
All,
I have the following code
rsSN = statement.executeQuery(Query); while (rsSN.next()){ if (Frame.equals("E")){ rsFrame = statement.executeQuery(QueryFrameE); if (rsFrame.next()){ js.append("<tr><td>"+ rsFrame.getString("ATTRIBUTE_VALUE") +"</td></tr>"); } } else{ rsFrame = statement.executeQuery(QueryFrameF); if (rsFrame.next()){ js.append("<tr><td>"+ rsFrame.getString("ATTRIBUTE_VALUE") +"</td></tr>"); } } }
Why it only do it once, if the ResulSet rsSN have 100 records
Thanks in advance Salvador
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]