<%@ page contentType="text/html; charset=iso-8859-1" language="java" import="java.sql.*" %> <%@ include file="Connections/connGoFormal.jsp" %> <% Driver DriverrsPage = (Driver)Class.forName(MM_connGoFormal_DRIVER).newInstance(); Connection ConnrsPage = DriverManager.getConnection(MM_connGoFormal_STRING,MM_connGoFormal_USERNAME,MM_connGoFormal_PASSWORD); PreparedStatement StatementrsPage = ConnrsPage.prepareStatement("SELECT pagehead.PageTitle, pagehead.Pagecontent1, pagehead.Pagecontent2, pagehead.Pagecontent3, pagehead.Pagecontent4, pagehead.Pagecontent5, pagehead.Pagecontent6 FROM pages LEFT JOIN pagehead ON pages.PageID = pagehead.PageID WHERE pages.PageID = '1004'"); ResultSet rsPage = StatementrsPage.executeQuery(); boolean rsPage_isEmpty = !rsPage.next(); boolean rsPage_hasData = !rsPage_isEmpty; Object rsPage_data; int rsPage_numRows = 0; %> <% Driver Driverrscontent = (Driver)Class.forName(MM_connGoFormal_DRIVER).newInstance(); Connection Connrscontent = DriverManager.getConnection(MM_connGoFormal_STRING,MM_connGoFormal_USERNAME,MM_connGoFormal_PASSWORD); PreparedStatement Statementrscontent = Connrscontent.prepareStatement("SELECT * FROM content WHERE PageID = '1004' AND contentStatus = 'current' ORDER BY ContOrder ASC"); ResultSet rscontent = Statementrscontent.executeQuery(); boolean rscontent_isEmpty = !rscontent.next(); boolean rscontent_hasData = !rscontent_isEmpty; Object rscontent_data; int rscontent_numRows = 0; %> <% String rsItem__MMColParam = "0"; if (request.getParameter("parcontentID") !=null) {rsItem__MMColParam = (String)request.getParameter("parcontentID") ;} %> <% Driver DriverrsItem = (Driver)Class.forName(MM_connGoFormal_DRIVER).newInstance(); Connection ConnrsItem = DriverManager.getConnection(MM_connGoFormal_STRING,MM_connGoFormal_USERNAME,MM_connGoFormal_PASSWORD); PreparedStatement StatementrsItem = ConnrsItem.prepareStatement("SELECT * FROM content WHERE contentID = '" + rsItem__MMColParam + "'"); ResultSet rsItem = StatementrsItem.executeQuery(); boolean rsItem_isEmpty = !rsItem.next(); boolean rsItem_hasData = !rsItem_isEmpty; Object rsItem_data; int rsItem_numRows = 0; %> <% int Repeat1__numRows = -1; int Repeat1__index = 0; rscontent_numRows += Repeat1__numRows; %> Untitled Document
 
<%=(((rsPage_data = rsPage.getObject("PageTitle"))==null || rsPage.wasNull())?"":rsPage_data)%>
<% while ((rscontent_hasData)&&(Repeat1__numRows-- != 0)) { %> " class="bodywhitelink"><%=(((rscontent_data = rscontent.getObject("content1"))==null || rscontent.wasNull())?"":rscontent_data)%>
<% Repeat1__index++; rscontent_hasData = rscontent.next(); } %>

<%=(((rsPage_data = rsPage.getObject("Pagecontent1"))==null || rsPage.wasNull())?"":rsPage_data)%>

<% if (!rsItem_isEmpty ) { %>

" class="PageTitleLink"><%=(((rsItem_data = rsItem.getObject("content1"))==null || rsItem.wasNull())?"":rsItem_data)%> <%=(((rsItem_data = rsItem.getObject("content2"))==null || rsItem.wasNull())?"":rsItem_data)%>

<%=(((rsItem_data = rsItem.getObject("content4"))==null || rsItem.wasNull())?"":rsItem_data)%>

<% } /* end !rsItem_isEmpty */ %>

 

 



<% rscontent.close(); Statementrscontent.close(); Connrscontent.close(); %> <% rsItem.close(); StatementrsItem.close(); ConnrsItem.close(); %> <% rsPage.close(); StatementrsPage.close(); ConnrsPage.close(); %>