%--
doViewComments.jsp
------------------
View peer comments for professional development modules.
Includes:
oerlWebViewCon.jsp
Created by zaz@sri.com.
Last modified by zaz@sri.com, 3/24/03.
--%>
<%@ page language="java" import="java.sql.*" %>
<%-- Make connection to database using oerl_webview login --%>
<%@ include file="../jspcode/oerlWebViewCon.jsp" %>
<%
// Get required parameters
String moduleNum = request.getParameter("Module");
if (moduleNum == null) moduleNum = "";
String pageNum = request.getParameter("Page");
if (pageNum == null) pageNum = "";
String questionNum = request.getParameter("Question");
if (questionNum == null) questionNum = "";
// Get module name and subname
StringBuffer queryBuf = new StringBuffer();
queryBuf.append("SELECT ModuleName, ModuleSubName FROM Modules");
queryBuf.append(" WHERE ModuleNum=" + moduleNum);
ResultSet moduleRS = con.createStatement().executeQuery(queryBuf.toString());
String moduleName = "";
String moduleSubName = "";
if (moduleRS != null && moduleRS.next()) {
moduleName = moduleRS.getString("ModuleName");
moduleSubName = moduleRS.getString("ModuleSubName");
if (moduleSubName != null && !moduleSubName.equals("")) {
moduleName += ": ";
}
if (moduleName == null) {
%>
Peer: | <% if (!name.equals("") || !email.equals("")) { %> <%= name %> <% if (!email.equals("")) { %> (<%= email %>) <% } } else { %> Anonymous <% } %> |
Comment: | <%= text %> |
There are no peer comments for this question yet.