ResulSet Question

2003-10-21 Thread salvador . bravo 
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(trtd+
rsFrame.getString(ATTRIBUTE_VALUE) +/td/tr); }
} else{
rsFrame = statement.executeQuery(QueryFrameF);
if (rsFrame.next()){ js.append(trtd+
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]

Re: ResulSet Question

2003-10-21 Thread 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(trtd+
rsFrame.getString(ATTRIBUTE_VALUE) +/td/tr); }
} else{
rsFrame = statement.executeQuery(QueryFrameF);
if (rsFrame.next()){ js.append(trtd+
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]

Re: ResulSet Question

2003-10-21 Thread epyonne 
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(trtd+
 rsFrame.getString(ATTRIBUTE_VALUE) +/td/tr); }
 } else{
 rsFrame = statement.executeQuery(QueryFrameF);
 if (rsFrame.next()){ js.append(trtd+
 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]