<%@page contentType="text/html; charset=iso-8859-1" language="java" import="java.sql.*"%> <%@ include file="/css/includecss.html"%> <%@ include file="/CS/Connections/CreateBBConnection.jsp" %> <%@page import="java.lang.*"%> <%@page import="java.io.*"%> <%@page import="java.text.*"%> <%@page import="java.util.*"%> <%@ page import="beans.Various"%> <%String DWNLD_ID = request.getParameter("ID");%> <%String currentURL = "/CS/External/JSPSingle.jsp?ID=" + DWNLD_ID;%> <% String NameForm = ""; String compareGrp = ""; String sql = "SELECT DWNLD_NAME, DWNLD_CNTLGRP, DWNLD_PAGE FROM BB.DOWNLOADABLES WHERE DWNLD_ID = " + DWNLD_ID; rs = stmt.executeQuery(sql); rs.next(); NameForm = rs.getString("DWNLD_NAME"); compareGrp = rs.getString("DWNLD_CNTLGRP"); %> <%@ include file="/CS/authentication/writeName.jsp"%> <% if (!ldapbean.getVALID_LOGIN()){ response.sendRedirect ("/CS/authentication/authorize.jsp"); } %> <% try{ try{ beans.Various singquot = new beans.Various(); String MainContent1 = rs.getString("DWNLD_PAGE"); rs.close(); conn.close(); rs=null; conn=null; String MainContent = singquot.replaceSubstring(MainContent1,"'","''"); %> <%@ include file="/css/includecss.html" %> <%@ include file="/CS/navigation/HeaderNoSearch.html" %> <% out.println(MainContent); }catch(java.lang.NullPointerException e){ out.print("

An error has occurred. Please contact Bonnie


"); } }catch(java.sql.SQLException e) { out.print("

An error has occurred. Please contact the Administrator


" + e); } %> <%session.invalidate();%>