|
Server : Apache/2.4.62 System : FreeBSD fbsdweb2.web.rcn.net 14.1-RELEASE FreeBSD 14.1-RELEASE releng/14.1-n267679-10e31f0946d8 GENERIC amd64 User : www ( 80) PHP Version : 8.3.8 Disable Function : NONE Directory : /domains/highlandlabs/cqi-bin/ALFA_DATA/alfasymlink/root/domains/howardbender2/jobs/ |
Upload File : |
<%@ Language=VBScript %>
<%
Dim sTitle
sTitle = "Resume search"
%>
<%
Dim sUserID
sUserID = trim(Request("userid"))
'check if userid is empty. if empty redirect to login screen
if sUserID = "" then Response.Redirect "login.asp?menu=school"
%>
<!--#include file=datastore.asp-->
<!--#include file=header.asp-->
<!--#include file=top.asp-->
<div align="center">
<table width="600" cellspacing="0" cellpadding="0" border="0" bgcolor="#FFFFFF">
<tr>
<td width="240" valign="top">
<img src="images/findpcand.jpg" border="0" WIDTH="240" HEIGHT="60">
<font face=arial><b>Search our resume database to find the best candidates for your vacancies<b>
</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="lightgreen" align="center"><b>Search Resumes</b></td></tr>
<tr><td bgcolor="lightgreen" align="center"><a href="schlist.asp?userid=<%=request("userid")%>"><font color="brown">Post New Jobs</font></a></td></tr>
<tr><td bgcolor="lightgreen" align="center"><a href="listjobs.asp?userid=<%=request("userid")%>"><font color="brown">List My Jobs</font></a></td></tr>
<tr><td bgcolor="lightgreen" align="center"><a href="schlist.asp?userid=<%=request("userid")%>"><font color="brown">Edit My Registration</font></a></td></tr>
</table>
</td>
</tr>
</table>
</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><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>
<%
'check if user has at least a job in database.
Dim objConn
Dim rsJobs
Dim sSQL
Dim bFound
Set objConn = server.CreateObject("ADODB.Connection") 'Connection object
Set rsJobs = server.CreateObject("ADODB.Recordset") 'Recordset object
'open the connection object
objConn.Open sConnect
'create SQL statement
sSQL = "SELECT JOB.*, SCHOOL.name FROM (MANAGER INNER JOIN SCHOOL ON MANAGER.managerid = SCHOOL.manager_id) INNER JOIN JOB ON SCHOOL.schoolid = JOB.school_id WHERE MANAGER.managerid='" & sUserID & "';"
'open the JOB table
rsJobs.Open sSQL, objConn, adOpenStatic
if not rsJobs.EOF then bFound = True else bFound = False
rsJobs.Close
Set rsJobs = Nothing
objConn.Close
%>
<% if bFound then %>
<div align="center">
<table width="600" border="0"><br>
<tr>
<td align="center"> <font face=arial color=Blue>
<form name="frmResSearch" action="findres.asp?userid=<%=sUserID%>" method="post">
<table width="100%">
<tr>
<td><font color=red><b>Area of Expertise:</b></font></td>
<td>
<select id="cboExpertise" name="cboExpertise" size="1">
<option value="0">All</option>
<option value="1">Administration</option>
<option value="2">Computers & Technology</option>
<option value="3">Desktop Publishing & Multimedia</option>
<option value="4">Early Learning</option>
<option value="5">Financial & Business</option>
<option value="6">Fine Arts</option>
<option value="7">Foreign Language & ESOL</option>
<option value="8">General Education</option>
<option value="9">Health & Physical Education</option>
<option value="10">History, Geography & Social Studies</option>
<option value="24">Home Economics & Home Studies</option>
<option value="11">Language Arts</option>
<option value="12">Library, Media Science & Reference</option>
<option value="13">Mathematics Education</option>
<option value="14">Measurement & Testing</option>
<option value="15">Music & Performing Arts</option>
<option value="16">Professional Training</option>
<option value="17">Psychology & Counseling</option>
<option value="18">Religious Education</option>
<option value="19">Research & Grants</option>
<option value="20">Science Education</option>
<option value="21">Social Sciences</option>
<option value="22">Special Education</option>
<option value="23">Web-Based Education</option>
</select>
</td>
</tr>
<tr>
<td><font color=red><b>Desired Locations:</b></font></td>
<td>
</td>
</tr>
<tr>
<td> <b>- Metro Area:</b> </td>
<td>
<select name="cboMetro" id="cboMetro" size="1">
<option value="0" selected>All</option>
<option value="1">Atlanta, Georgia</option>
<option value="2">Austin, Texas</option>
<option value="3">Baltimore, Maryland</option>
<option value="4">Biloxi, Mississippi</option>
<option value="5">Birmingham, Alabama</option>
<option value="6">Boston, Massachusetts</option>
<option value="7">Chicago, Illinois</option>
<option value="8">Cincinnati, Ohio</option>
<option value="9">Cleveland, Ohio</option>
<option value="10">Columbus, Ohio</option>
<option value="11">Dallas-Fort Worth, Texas</option>
<option value="12">Denver, Colorado</option>
<option value="13">Detroit, Michigan</option>
<option value="14">Frankfort, Kentucky</option>
<option value="15">Houston, Texas</option>
<option value="16">Indianapolis, Indiana</option>
<option value="17">Kansas City, Kansas</option>
<option value="18">Las Vegas, Nevada</option>
<option value="19">Los Angeles, California</option>
<option value="20">Memphis, Tennessee</option>
<option value="21">Miami, Florida</option>
<option value="22">Milwaukee, Wisconsin</option>
<option value="23">Minneapolis-St. Paul, Minnesota</option>
<option value="24">Nashville, Tennessee</option>
<option value="25">New Orleans, Louisiana</option>
<option value="26">New York City, New York</option>
<option value="27">Norfolk, Virginia</option>
<option value="28">Oklahoma City, Oklahoma</option>
<option value="29">Orlando, Florida</option>
<option value="30">Philadelphia, Pennsylvania</option>
<option value="31">Phoenix, Arizona</option>
<option value="32">Pittsburgh, Pennsylvania</option>
<option value="33">Portland, Oregon</option>
<option value="34">Raleigh-Durham, North Carolina</option>
<option value="35">Richmond, Virginia</option>
<option value="36">Salt Lake City, Utah</option>
<option value="37">San Antonio, Texas</option>
<option value="38">San Diego, California</option>
<option value="39">San Francisco, California</option>
<option value="40">Seattle, Washington</option>
<option value="41">St. Louis, Missouri</option>
<option value="42">Tampa-St. Petersburg, Florida</option>
<option value="43">Washington, D.C.</option>
<option value="44">Winston-Salem, North Carolina</option>
</select>
</td>
</tr>
<td><b>or</b> </td>
<tr>
<td> <b>- Region:</b> </td>
<td>
<select name="cboRegion" id="cboRegion" size="1">
<option value="0" selected>All</option>
<option value="1">Alabama (Northern)</option>
<option value="2">Alabama (Southern)</option>
<option value="3">Alaska</option>
<option value="4">Arizona</option>
<option value="5">Arkansas</option>
<option value="6">California (Northern Coastal)</option>
<option value="7">California (Northern Inland)</option>
<option value="8">California (Southern Coastal)</option>
<option value="9">California (Southern Inland)</option>
<option value="10">Colorado (Northern)</option>
<option value="11">Colorado (Southern)</option>
<option value="12">Connecticut</option>
<option value="13">Delaware</option>
<option value="14">Florida (Northern)</option>
<option value="15">Florida (Southern)</option>
<option value="16">Georgia (Northern)</option>
<option value="17">Georgia (Southern)</option>
<option value="18">Hawaii</option>
<option value="19">Idaho</option>
<option value="20">Illinois (Northern/Metro)</option>
<option value="21">Illinois (Southern)</option>
<option value="22">Indiana</option>
<option value="23">Iowa</option>
<option value="24">Kansas</option>
<option value="25">Kentucky (Northeastern)</option>
<option value="26">Kentucky (Southwestern)</option>
<option value="27">Louisiana (Northern)</option>
<option value="28">Louisiana (Southern)</option>
<option value="29">Maine</option>
<option value="30">Maryland</option>
<option value="31">Massachusetts (Eastern)</option>
<option value="32">Massachusetts (Western)</option>
<option value="33">Michigan (Upper Peninsula)</option>
<option value="34">Michigan (Lower Eastern)</option>
<option value="35">Michigan (Lower Western)</option>
<option value="36">Minnesota </option>
<option value="37">Mississippi</option>
<option value="38">Missouri (Northern)</option>
<option value="39">Missouri (Southern)</option>
<option value="40">Montana</option>
<option value="41">Nebraska</option>
<option value="42">Nevada</option>
<option value="43">New Hampshire</option>
<option value="44">New Jersey (North/NY Metro)</option>
<option value="45">New Jersey (Southern)</option>
<option value="46">New Mexico</option>
<option value="47">New York (Southeastern)</option>
<option value="48">New York (Northwestern)</option>
<option value="49">North Carolina (Eastern)</option>
<option value="50">North Carolina (Western)</option>
<option value="51">North Dakota</option>
<option value="52">Ohio (Northern)</option>
<option value="53">Ohio (Southern)</option>
<option value="54">Oklahoma</option>
<option value="55">Oregon</option>
<option value="56">Pennsylvania (Eastern)</option>
<option value="57">Pennsylvania (Western)</option>
<option value="58">Rhode Island</option>
<option value="59">South Carolina (Coastal)</option>
<option value="60">South Carolina (Inland)</option>
<option value="61">South Dakota</option>
<option value="62">Tennessee (Eastern)</option>
<option value="63">Tennessee (Western)</option>
<option value="64">Texas (Eastern)</option>
<option value="65">Texas (Western)</option>
<option value="66">Utah</option>
<option value="67">Vermont</option>
<option value="68">Virginia (North/DC metro)</option>
<option value="69">Virginia (South)</option>
<option value="70">Washington (Eastern)</option>
<option value="71">Washington (Western)</option>
<option value="72">West Virginia</option>
<option value="73">Wisconsin</option>
<option value="74">Wyoming</option>
<option>----------------------</option>
<option value="75">Alberta, Canada</option>
<option value="76">British Columbia, Canada</option>
<option value="77">Manitoba, Canada</option>
<option value="78">Newfoundland, Canada</option>
<option value="79">Ontario, Canada</option>
<option value="80">Nova Sotia, Canada</option>
<option value="81">Prince Edward Island, Canada</option>
<option value="82">Quebec, Canada</option>
<option value="83">Saskatchewan, Canada</option>
<option value="84">Yukon, Canada</option>
</select>
</td>
</tr>
<tr>
<td><font color=red><b>Education:</b></font></td>
<td>
<select name="cboEducation" id="cboEducation" size="1">
<option value="0" selected>All</option>
<option value="1">At Least High School Diploma</option>
<option value="2">At Least Bachelor Degree</option>
<option value="3">At Least Master Degree</option>
<option value="4">Doctorate</option>
</select>
</td>
</tr>
<tr>
<td><font color=red><b>Desired Salary:</b></font></td>
<td>
<select id="cboSalaryRange" name="cboSalaryRange" size="1">
<option selected value="0"> All</option>
<option value="1">No More than $10000</option>
<option value="2">No More than $20000</option>
<option value="3">No More than $30000</option>
<option value="4">No More than $40000</option>
<option value="5">No More than $50000</option>
</select>
</td>
</tr>
<tr>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td><input type="submit" value="Search" id="SubmitSearch" name="SubmitSearch"> <input type="reset" value="Reset" id="ResetFields" name="ResetFields"></td>
</tr>
</table>
</form>
</td>
</tr>
</table>
</div>
<% else %>
<!--User must post at least one job to use this service-->
<div align=center>
<table cellspacing=0 cellpadding=0 border=0 width=600>
<tr>
<td align=center class="title"><font face=arial><b>Welcome</b></font></td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td>
<font face=arial><b>Thank you for using our resume search database system. You must post at least one job before you can start using this service. To post jobs, <a href="schlist.asp?userid=<%=sUserID%>">Click here</b></font></a>.
</td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td align=center>
<a href="javascript:history.back()">Back</a>
</td>
</tr>
</table>
</div>
<% end if %>
<!--#include file=bottom.asp-->
<!--#include file=footer.asp-->