<%
queryBuf = new StringBuffer();
queryBuf.append("SELECT m.ModuleName, m.ModuleSubName, mc.Name, mc.Email, mc.CommentText\n");
queryBuf.append(" FROM Modules AS m, ModuleComments AS mc, ModuleQuestions AS mq\n");
queryBuf.append(" WHERE m.ModuleID=mq.ModuleID AND mc.QuestionID=mq.QuestionID");
queryBuf.append(" AND m.ModuleNum=" + moduleNum + " AND mq.QuestionNum=" + questionNum);
queryBuf.append(" AND mq.PageNum=\"" + pageNum + "\" AND mc.Publish=\"Y\"\n");
ResultSet commentRS = con.createStatement().executeQuery(queryBuf.toString());
if (commentRS != null && commentRS.next()) {
commentRS.beforeFirst();
while (commentRS.next()) {
String name = commentRS.getString("mc.Name");
if (name == null) name = "";
String email = commentRS.getString("mc.Email");
if (email == null) email = "";
String text = commentRS.getString("mc.CommentText");
%>
<% if (commentRS.isFirst()) { %>
<% } %>
Peer:
<% if (!name.equals("") || !email.equals("")) { %>
<%= name %>
<% if (!email.equals("")) { %>
(<%= email %>)
<%
}
} else {
%>
Anonymous
<% } %>
Comment:
<%= text %>
<%
} /* close while */
} else { %>
There are no peer comments for this question yet.
<%
} /* close if */
// close database connection
con.close();
%>