Shouldn't the evaluation statement, i.e. Frame.equals("E"), be outside the
main while loop? When inside a while loop of a ResultSet, you should be
evaluating the value in the ResultSet.
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, October 21, 2003 10:26 AM
Subject: ResulSet Question
> 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]
