<%@ 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 = '1001'"); 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 = '1001' 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; %> <% int Repeat2__numRows = -1; int Repeat2__index = 0; rscontent_numRows += Repeat2__numRows; %> Untitled Document
<%=(((rsPage_data = rsPage.getObject("PageTitle"))==null || rsPage.wasNull())?"":rsPage_data)%>
  <% while ((rscontent_hasData)&&(Repeat2__numRows-- != 0)) { %> <% Repeat2__index++; rscontent_hasData = rscontent.next(); } %>
">.gif" name="pic<%=(((rscontent_data = rscontent.getObject("contentID"))==null || rscontent.wasNull())?"":rscontent_data)%>" width="100" height="126" border="0" id="pic<%=(((rscontent_data = rscontent.getObject("contentID"))==null || rscontent.wasNull())?"":rscontent_data)%>" onMouseOver="MM_swapImage('limelight<%=(((rscontent_data = rscontent.getObject("contentID"))==null || rscontent.wasNull())?"":rscontent_data)%>','','assets/limelight.gif','pic<%=(((rscontent_data = rscontent.getObject("contentID"))==null || rscontent.wasNull())?"":rscontent_data)%>','','assets/myths<%=(((rscontent_data = rscontent.getObject("contentID"))==null || rscontent.wasNull())?"":rscontent_data)%>-over.gif',1)" onMouseOut="MM_swapImgRestore()">

<% if (!rsItem_isEmpty ) { %> "<%=(((rsItem_data = rsItem.getObject("content1"))==null || rsItem.wasNull())?"":rsItem_data)%>" <% } /* end !rsItem_isEmpty */ %> <% if (rsItem_isEmpty ) { %> <%=(((rsPage_data = rsPage.getObject("Pagecontent1"))==null || rsPage.wasNull())?"":rsPage_data)%> <% } /* end rsItem_isEmpty */ %>

<% if (!rsItem_isEmpty ) { %> <%=(((rsItem_data = rsItem.getObject("content2"))==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(); %>