<%@ page contentType="text/html; charset=iso-8859-1" language="java" import="java.sql.*" errorPage="" %> <%@ 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 = '1005'"); 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 = '1005' 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; %> <% int Repeat1__numRows = -1; int Repeat1__index = 0; rscontent_numRows += Repeat1__numRows; %> Go Formal
 
  <% while ((rscontent_hasData)&&(Repeat1__numRows-- != 0)) { %>

<%=(((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)%>
 
  <%=(((rsPage_data = rsPage.getObject("PageTitle"))==null || rsPage.wasNull())?"":rsPage_data)%>
 
<% rsPage.close(); StatementrsPage.close(); ConnrsPage.close(); %> <% rscontent.close(); Statementrscontent.close(); Connrscontent.close(); %>