<!-- METADATA TYPE="typelib"
FILE="C:\Program Files\Common Files\System\ado\msado15.dll" -->

<%
Dim strTrainCon
Dim objConn
Set objConn = Server.CreateObject("ADODB.Connection")

objConn.Open = "Provider=sqloledb;" & _
"Network Library=DBMSSOCN;" & _
"Data Source=198.234.213.46,11368;" & _
"Initial Catalog=TrainingCourses;" & _
"User Id=trainingweb;" & _
"Password=web.train!"

strTrainCon = "Provider=sqloledb;" & _
"Network Library=DBMSSOCN;" & _
"Data Source=198.234.213.46,11368;" & _
"Initial Catalog=TrainingCourses;" & _
"User Id=trainingweb;" & _
"Password=web.train!"

%>

END clssfd.asp

<!--#include file="Clssfd.asp"--><basefont face="Georgia" color="DarkBlue">
<html>
<head>
<meta http-equiv="Content-Language" content="en-us">
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<link HREF="style.css" TYPE="text/css" REL="stylesheet">
<title>EMA Training - Courses</title>
</head>
<%
Dim rsCourse, strCourseName, strDescription
Set rsCourse = Server.CreateObject("ADODB.Recordset")
strSQL = "SELECT Course.CourseName, Course.CourseDescription, Course.CoursePreRequisites FROM Course WHERE CourseID =" & Request("Course")
rsCourse.Open strSQL, objConn
strCourseName = rsCourse("CourseName")
strDescription = rsCourse("CourseDescription")
strPreRequisites = rsCourse("CoursePreRequisites")
rsCourse.Close
Set rsCourse = Nothing

Dim rsSignUps
Set rsSignUps = Server.CreateObject("ADODB.Recordset")
strSQL = "SELECT * FROM SignUp WHERE fkCourseID =" & Request("Course") & _
" ORDER BY TimeStamp DESC;"

rsSignUps.Open strSQL, objConn
%>
<body BGCOLOR="#4866a6" TEXT="#000000" LINK="#FD5200" VLINK="#FD5200" ALINK="#FD5200">
<table width="100%" cellpadding="0" cellspacing="0" border="0">
<tr valign="middle"><td colspan="2" bgcolor="#4866a6" height="50"><font size="5" color="#635542" style="position: relative; left: 12px; top: 18px;" face="Arial"><b>On-line Sign Up For:
<%= strCourseName %></b></font><br><font size="5" color="white" style="position: relative; left: 10px; top: -12px;" face="Arial"><b>On-line Sign Up For: <%= strCourseName %></b></font>
</td></tr>
</table>
<table width="764" border="0" cellpadding="5" height="82" style="border-collapse: collapse" bordercolor="#111111" cellspacing="0">
<tr><td width="161" rowspan="3" height="70">&nbsp;</td><td width="103" height="1">Course:</td><td width="529" height="1"><%= strCourseName %></td></tr>
<tr><td width="103" height="18">Description:</td><td width="529" height="18"><%= strDescription %></td></tr>
<tr><td width="192" height="18">Class Pre-Requisites:</td><td width="217" height="18"><%= strPreRequisites %></td></tr>
</table>
<p>
<br>

</p>
<table width="100%" cellpadding="0" cellspacing="0" border="0">
<tr><td bgcolor="#DDD6CC" height="1"></td></tr>
<tr><td bgcolor="#665744" height="1"></td></tr>
</table>
<table width="100%" cellpadding="0" cellspacing="0" border="0">
<tr valign="middle"><td colspan="2" bgcolor="#4866a6" height="50"><font size="5" color="#635542" style="position: relative; left: 12px; top: 18px;" face="Arial"><b>Meeting the
Pre-Requisites: </b></font>
<br><font size="5" color="white" style="position: relative; left: 10px; top: -12px;" face="Arial"><b>Meeting the Pre-Requisites: </b></font></td></tr>
</table>
<table width="824" border="0" cellpadding="5" height="163" bordercolor="#00008B" cellspacing="0" style="border-collapse: collapse">
<tr><td width="114" height="22" bordercolor="#FFFFCC">&nbsp;</td><td width="221" height="22" bordercolor="#FFFFCC">Your Certifying Facility/Agency:</td><td width="492" height="22"
bordercolor="#FFFFCC"><b><input name="PreReqFacility" value="<%= Session("PreReqFacility")%>" size="31" tabindex="1"><span style="font-weight: 400"><font color="#FFFF00" size="2">(Please
use N/A if not required)</font></span></b></td></tr>
<tr><td width="114" height="22" bordercolor="#FFFFCC">&nbsp;</td><td width="221" height="22" bordercolor="#FFFFCC">Your Degree/Certification:</td><td width="492" height="22"
bordercolor="#FFFFCC"><b><input name="PreReqDegree" value="<%= Session("PreReqDegree")%>" size="31" tabindex="2"><span style="font-weight: 400"><font color="#FFFF00" size="2">(Please use
N/A if not required)</font></span></b></td></tr>
<tr><td width="114" height="22" bordercolor="#FFFFCC">&nbsp;</td><td width="221" height="22" bordercolor="#FFFFCC">Date Earned:</td><td width="492" height="22" bordercolor="#FFFFCC"><b>
<input name="PreReqDateEarned" value="<%= Session("PreReqDateEarned")%>" size="10" tabindex="3"><span style="font-weight: 400"><font color="#FFFF00">(Please use FULL year, i.e. 06/15/2003
or N/A) </font></font></span></b></td></tr>
<tr><td width="114" height="22" bordercolor="#FFFFCC">&nbsp;</td><td width="221" height="22" bordercolor="#FFFFCC">Your Course/Field of Study:</td><td width="492" height="22"
bordercolor="#FFFFCC"><b><input name="PreReqStudyCourse" value="<%= Session("PreReqStudyCourse")%>" size="39" tabindex="4"><span style="font-weight: 400"><font color="#FFFF00">(Please use
N/A if not required)</font></font></span></b></td></tr>
</table>
<p align="center">
<font color="#FFFFFF"><b>If the class you are signing up for has pre-requisites, and you fail to<br>supply us the above information, your application will be rejected.</b></font></p>
<table width="100%" cellpadding="0" cellspacing="0" border="0">
<tr><td bgcolor="#DDD6CC" height="1"></td></tr>
<tr><td bgcolor="#665744" height="1"></td></tr>
</table>
<table width="100%" cellpadding="0" cellspacing="0" border="0">
<tr valign="middle"><td colspan="2" bgcolor="#4866a6" height="50"><font size="5" color="#635542" style="position: relative; left: 12px; top: 18px;" face="Arial"><b>Justification: </b>
</font>
<br><font size="5" color="white" style="position: relative; left: 10px; top: -12px;" face="Arial"><b>Justification: </b></font></td></tr>
</table>
<form name="FrontPage_Form1" action="AddSignUp.asp" method="POST" onsubmit="return FrontPage_Form1_Validator(this)" language="JavaScript">
<b><input type="Hidden" name="CourseID" value="<%= Request("Course") %>"></b>
<p>

</p>
<table width="802" border="0" cellpadding="5" height="255" style="border-collapse: collapse" bordercolor="#111111" cellspacing="0">
<tr><td width="223" rowspan="6" height="243">&nbsp;</td></tr>
<tr><td width="695" height="1">Briefly describe below, your activities or responsibilities as they relate to the course for which you are applying, and identify how you will use the
information obtained from this Course:</font></td></tr>
<tr><td width="695" height="23"><b>
<!--webbot bot="Validation" s-display-name="Your_Justification" s-data-type="String" b-allow-letters="TRUE" b-allow-digits="TRUE" b-allow-whitespace="TRUE" s-allow-other-chars=", . - ' &quot;" b-value-required="TRUE" i-minimum-length="10" --><input name="SignUpReason" value="<%= Session("SignUpReason")%>" size="96"
tabindex="5"></b></td></tr>
<tr><td width="695" height="17"><font size="2">&quot;I certify that the information contained in my registration and on this application is correct.&nbsp; I agree to abide by the policies
stated in the most recently published Ohio Emergency Managment Training Catalog.</font><p>
I understand that if I am a NO SHOW for the training course I have signed up for,&nbsp; I may be restricted from taking classes for a 12 month period.&quot;</font></font></td></tr>
<tr><td width="695" height="43">
<p align="center">
<b><input type="Submit" value="I have read, understand and agree to the Statement Above"></b></td></tr>
<tr><td width="143" height="4">
<p align="left">
<b><input type="RESET"></b></td></tr>
</table>
</form>
<p>

</p>
<hr>
<p>

</p>
<hr>
</body></html>

END Signup.asp