
October 30th, 2001, 06:27 AM
|
|
Junior Member
|
|
Join Date: May 2001
Location: Liverpool, UK
Posts: 0
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
ResultSets and variables?
I have two ResultSets, however how would i use variables created in one in the other.
// Execute Query - get question for the Quest_ID
ResultSet QuestionRS = statement.executeQuery("SELECT Question FROM Questions WHERE Quest_ID = '"+Quest_ID+"'");
// Get correct answer for the Quest_ID
ResultSet CorrectAnsRS = statement.executeQuery("SELECT Ans_ID FROM CorrectAns WHERE Quest_ID = '"+Quest_ID+"'");
// Get answers for Ans_IDs containing the Quest_ID
ResultSet AnswerRS = statement.executeQuery("SELECT * FROM CorrectAns, Answers WHERE Ans_ID = '"+Quest_ID+"*'");
int count = 1;
String check = "";
while (QuestionRS.next()) {
String Question = QuestionRS.getString("Question");
%>
<tr><td><font face="Arial, Helvetica, sans-serif" size="2"><input type="text" name="Question" value="<%= Question %>"
<%
}
while (CorrectAnsRS.next()) {
String CorrectAns = CorrectAnsRS.getString("Ans_ID");
check = CorrectAns;
}
while (AnswerRS.next()) {
String Ans_ID = AnswerRS.getString("Ans_ID");
String Answer = AnswerRS.getString("Answer");
%>
<tr><td><font face="Arial, Helvetica, sans-serif" size="2"><input type="radio" name="Answer" value="<%= Ans_ID %>"<% if (Ans_ID.compareTo(check) == 0) { %>checked<% } %>><b><%= count %>. </b><input type="text" name="choice" value="<%= Answer %>"><input type="hidden" name="Ans_ID" value="<%= Ans_ID %>"></font></td></tr>
<%
count++;
}
|