%@page contentType="text/html; charset=iso-8859-1" language="java" import="java.sql.* , java.text.*, java.lang.String.* "%> <%@ include file="../Connections/tester.jsp" %> <%@include file="includes/proxy.jsp"%> <%@ page errorPage="ecab_error.jsp" %> <% Driver DriverrsNational = (Driver)Class.forName(MM_tester_DRIVER).newInstance(); Connection ConnrsNational = DriverManager.getConnection(MM_tester_STRING,MM_tester_USERNAME,MM_tester_PASSWORD); PreparedStatement StatementrsNational = ConnrsNational.prepareStatement("SELECT text, heading, link, headlink FROM tblText AS a RIGHT OUTER JOIN tblHeading AS p ON a.HeadingId = p.HeadingId WHERE TitleId = 1 OR TitleId = 2 ORDER BY heading"); ResultSet rsNational = StatementrsNational.executeQuery(); boolean rsNational_isEmpty = !rsNational.next(); boolean rsNational_hasData = !rsNational_isEmpty; Object rsNational_data; int rsNational_numRows = 0; %> <% int Repeat1__numRows = -1; int Repeat1__index = 0; rsNational_numRows += Repeat1__numRows; %> <%String Heading, lastHeading = "";%> <%String gHeading, lastgHeading = ""; String sty = "006666"; String sty2 = "006666";%>
| Home | About Us | Contact Us | Help | Search |
|
|||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||
<% rsNational.close(); ConnrsNational.close(); %>