Re: ResulSet Question

[Manolo Ramirez T.]

Hi,

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]