<%@ 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 wshopid, workshop, wshopdatefrom, wshopdateto, wshoptime, wshopvenue, wshopdesc, wshoppresenter, wcost FROM rbdccom_rbdc.tblworkshops WHERE centreid = 2 ORDER BY wshopdatefrom"); 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; %> <%! public String DoDateTime(java.lang.Object aObject,int nNamedFormat,java.util.Locale aLocale) throws Exception{ if ((aObject != null) && (aObject instanceof java.util.Date)){ if (aLocale!=null){ java.text.DateFormat df = java.text.DateFormat.getDateInstance(nNamedFormat,aLocale); return df.format(aObject); } else{ java.text.DateFormat df = java.text.DateFormat.getDateInstance(nNamedFormat); return df.format(aObject); } } return ""; } String wshopid = null; %> Kwinana Technology Business Centre: Workshops

Kwinana Technology Business Centre: Workshops

Workshops

The Kwinana Technology Business Centre workshops are here to help Small Businesses.

Training Vouchers

The Small Business Smart Business Program provides small business owners in Western Australia with training vouchers, up to the value of $220 (includes GST).

These training vouchers are designed to help small business owners and operators to access training in the areas that they need. Increased training assists small business operators improve their productivity and competitiveness and support them through difficult first years of operation.

<% int cinter = 0; while ((rst_hasData)&&(Repeat1__numRows-- != 0)) { %> <% wshopid = rst.getString("wshopid"); Driver Driverrst1 = (Driver)Class.forName(MM_rbdc_DRIVER).newInstance(); Connection Connrst1 = DriverManager.getConnection(MM_rbdc_STRING,MM_rbdc_USERNAME,MM_rbdc_PASSWORD); PreparedStatement Statementrst1 = Connrst1.prepareStatement("SELECT wdocid, docupath, docdesc FROM rbdccom_rbdc.tblwshopdocs WHERE wshopid = " + wshopid + ""); ResultSet rst1 = Statementrst1.executeQuery(); boolean rst1_isEmpty = !rst1.next(); boolean rst1_hasData = !rst1_isEmpty; Object rst1_data; int rst1_numRows = 0; %> <% int Repeat2__numRows = -1; int Repeat2__index = 0; rst1_numRows += Repeat2__numRows; %> <% if (rst.getString("wcost").equals("Free")) { %> <% } else { %> <%} %> <% while ((rst1_hasData)&&(Repeat2__numRows-- != 0)) { %> <% Repeat2__index++; rst1_hasData = rst1.next(); } %>
Workshop
<%=(((rst_data = rst.getObject("workshop"))==null || rst.wasNull())?"":rst_data)%>
Details "> <%=(((rst_data = rst.getObject("wshopdesc"))==null || rst.wasNull())?"":rst_data)%> "> ">
Venue <%=(((rst_data = rst.getObject("wshopvenue"))==null || rst.wasNull())?"":rst_data)%>
Date From <%= DoDateTime((((rst_data = rst.getObject("wshopdatefrom"))==null || rst.wasNull())?"":rst_data), java.text.DateFormat.SHORT, java.util.Locale.UK) %> Date To <%= DoDateTime((((rst_data = rst.getObject("wshopdateto"))==null || rst.wasNull())?"":rst_data), java.text.DateFormat.SHORT, java.util.Locale.UK) %> Time <%=(((rst_data = rst.getObject("wshoptime"))==null || rst.wasNull())?"":rst_data)%>
Presenter <%=(((rst_data = rst.getObject("wshoppresenter"))==null || rst.wasNull())?"":rst_data)%>
Cost<%=(((rst_data = rst.getObject("wcost"))==null || rst.wasNull())?"":rst_data)%>$<%=(((rst_data = rst.getObject("wcost"))==null || rst.wasNull())?"":rst_data)%> per person (GST Inclusive)
 
Attached Workshop Documents
" target="_blank"><%=(((rst1_data = rst1.getObject("docdesc"))==null || rst1.wasNull())?"":rst1_data)%>

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