<% @Language=VBScript %>

<% 
	Dim sTitle 
	sTitle = "Housing Example"
%>
<!--#include file="_ScriptLibrary/adovbs.inc"-->
<!--#include file="datastore.asp"-->

<!--#include file=header.asp-->
<!--#include file=top.asp-->

<%
	'Declare variables
	Dim iJobID
	Dim rsJobs
	Dim objConn
	Dim sSQL
	Dim sHousing
	Dim rsSchool
		
	'get job id
	iJobID = request("id")
		
	'Connection object
	Set objConn = Server.Createobject("ADODB.Connection")

	'Recordset objects
	Set rsJobs = Server.CreateObject("ADODB.Recordset")
	Set rsSchool = Server.CreateObject("ADODB.Recordset")
	
	'open connection
	if objConn.State = 0 then	'only open if the connection is closed
		objConn.Open sConnect
	end if

'open the SCHOOL table
rsSchool.Open "SCHOOL", objConn, 0, 3


%>

<div align="center">
	<table width="600" cellspacing="0" cellpadding="0" border="0" bgcolor="#FFFFFF">
	<tr>
		<td width="420" valign="top">
			<img src="images/housing.gif" border="0" WIDTH="420" HEIGHT="60">
		</td>
		<td width="180" valign="top">
			<table width="100%" cellspacing="0" cellpadding="0" border="0">
				<tr>
					<td bgcolor="#003399">
						<table bgcolor="#003399" width="100%" cellspacing="2" cellpadding="2" border="0">
							<tr bgcolor="#003399"><td bgcolor="#6699FF" align="center"><a href="default.asp">Job Search</a></td></tr>
							<tr><td bgcolor="#6699FF" align="center"><a href="login.asp?menu=teacher">My Resume</a></td></tr>
							<tr><td bgcolor="#6699FF" align="center"><a href="login.asp?menu=school">For Schools</a></td></tr>
							<tr><td bgcolor="#6699FF" align="center"><a href="faqs.asp">FAQs</a></td></tr>
						</table>
					</td>
				</tr>
			</table>
		</td>
	</tr>
	</table>	
</div>
<div align="center">
	<table width="600" cellspacing="0" cellpadding="0" border="0" bgcolor="#FFFFFF">
	<tr>
		<td width="420" valign="top">
		</td>
		<td width="180" valign="top">
			<table width="100%" cellspacing="0" cellpadding="0" border="0">
				<tr>
					<td bgcolor="#003399">
						<table bgcolor="#003399" width="100%" cellspacing="2" cellpadding="2" border="0">
							<tr bgcolor="#003399"><td bgcolor="#6699FF" align="center"><a href="housing/housing250.asp"><font color=red>Housing Help</font></a></td></tr>
						</table>
					</td>
				</tr>
			</table>
		</td>
	</tr>
	</table>	
</div><br>

<%		
		response.write "<div align=center>"
		response.write "<table width=600 cellspacing=0 cellpadding=0 border=0>"
		response.write "<tr><td><h3>British Columbia - Math Teacher</h3></td></tr>"
		response.write "<tr><td><blockquote>Teach elementary school kids the joy of math</blockquote></td></tr>"
		response.write "<tr><td><h3>Requirements:</h3>"
		response.write "Degree: Bachelor Degree<br>"
		response.write "Expertise: Elementary Education<br>"
		response.write "Start date: August 2002<br>"
		response.write "Salary: $22,000.00 - $30,000.00 Per Year<p></td></tr>"
		response.write "<tr><td><br><br><h3>Contact Information:</h3>"
		response.write "Dr. Howard J. Bender<br>"
		response.write "250-555-0000<br>"
		response.write "<a href=mailto:[email protected]?subject=Inquiry_via_School-Jobs.net>[email protected]</a><br>"
		response.write "BC EPICENTER School<br>"
		response.write "0000 Main Street<br>"
		response.write "West Hyattsville, British Columbia<br>"
		response.write "</td></tr>"
		response.write "</table></div>"
		Response.Write "<p align=""center""><a href=""javascript:history.back()"">Back</a>"

%>


<!--#include file=bottom.asp-->
<!--#include file=footer.asp-->