<%@ page contentType="text/html; charset=iso-8859-1" language="java" import="java.sql.*" errorPage="" %> <%@ include file="Connections/rbdc.jsp" %> <% Driver Driverrst = (Driver)Class.forName(MM_rbdc_DRIVER).newInstance(); Connection Connrst = DriverManager.getConnection(MM_rbdc_STRING,MM_rbdc_USERNAME,MM_rbdc_PASSWORD); PreparedStatement Statementrst = Connrst.prepareStatement("SELECT tennant, tennantcontact, tennantphone, tennantfax, tennantaddress, tennatdesc, tennantweb, tennantemail FROM rbdccom_rbdc.tbltennants WHERE centreid = 1 ORDER BY tennant"); ResultSet rst = Statementrst.executeQuery(); boolean rst_isEmpty = !rst.next(); boolean rst_hasData = !rst_isEmpty; Object rst_data; int rst_numRows = 0; %> <% int Repeat1__numRows = -1; int Repeat1__index = 0; rst_numRows += Repeat1__numRows; %> Small Business Centre South West Metro: Incubator Tennants

Small Business Centre South West Metro: Incubator Tenants

<% while ((rst_hasData)&&(Repeat1__numRows-- != 0)) { %>
Tenant <%=(((rst_data = rst.getObject("tennant"))==null || rst.wasNull())?"":rst_data)%>
Details <%=(((rst_data = rst.getObject("tennatdesc"))==null || rst.wasNull())?"":rst_data)%>
Contact <%=(((rst_data = rst.getObject("tennantcontact"))==null || rst.wasNull())?"":rst_data)%>
Address <%=(((rst_data = rst.getObject("tennantaddress"))==null || rst.wasNull())?"":rst_data)%>
Phone No <%=(((rst_data = rst.getObject("tennantphone"))==null || rst.wasNull())?"":rst_data)%> Fax No <%=(((rst_data = rst.getObject("tennantfax"))==null || rst.wasNull())?"":rst_data)%>
Email "><%=(((rst_data = rst.getObject("tennantemail"))==null || rst.wasNull())?"":rst_data)%>
Website " target="_blank"><%=(((rst_data = rst.getObject("tennantweb"))==null || rst.wasNull())?"":rst_data)%>

<% Repeat1__index++; rst_hasData = rst.next(); } %>
   
<% rst.close(); Statementrst.close(); Connrst.close(); %>