|
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
if sUserID = "epicenter" or sUserID = "school-jobs" then
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 & "';"
else
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 & "' AND JOB.active=true;"
end if
'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>and</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</option>
<option value="3">Alaska</option>
<option value="4">Arizona</option>
<option value="5">Arkansas</option>
<option value="6">California (Northern)</option>
<option value="8">California (Southern)</option>
<option value="10">Colorado</option>
<option value="12">Connecticut</option>
<option value="13">Delaware</option>
<option value="14">Florida</option>
<option value="16">Georgia</option>
<option value="18">Hawaii</option>
<option value="19">Idaho</option>
<option value="20">Illinois</option>
<option value="22">Indiana</option>
<option value="23">Iowa</option>
<option value="24">Kansas</option>
<option value="25">Kentucky</option>
<option value="27">Louisiana</option>
<option value="29">Maine</option>
<option value="30">Maryland</option>
<option value="31">Massachusetts</option>
<option value="33">Michigan</option>
<option value="36">Minnesota </option>
<option value="37">Mississippi</option>
<option value="38">Missouri</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</option>
<option value="46">New Mexico</option>
<option value="47">New York (Southeastern)</option>
<option value="48">New York (Upstate)</option>
<option value="49">North Carolina</option>
<option value="51">North Dakota</option>
<option value="52">Ohio</option>
<option value="54">Oklahoma</option>
<option value="55">Oregon</option>
<option value="56">Pennsylvania</option>
<option value="58">Rhode Island</option>
<option value="59">South Carolina</option>
<option value="61">South Dakota</option>
<option value="62">Tennessee</option>
<option value="64">Texas</option>
<option value="66">Utah</option>
<option value="67">Vermont</option>
<option value="68">Virginia</option>
<option value="70">Washington</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="91">New Brunswick, Canada</option>
<option value="78">Newfoundland, Canada</option>
<option value="79">Northwest Territory, Canada</option>
<option value="80">Ontario, Canada</option>
<option value="81">Nova Sotia, Canada</option>
<option value="82">Prince Edward Island, Canada</option>
<option value="83">Quebec, Canada</option>
<option value="84">Saskatchewan, Canada</option>
<option value="85">Yukon Territory, Canada</option>
<option>----------------------</option>
<OPTION VALUE="88">Caribbean</OPTION>
<option>----------------------</option>
<OPTION VALUE="89">Marianas Islands</OPTION>
<OPTION VALUE="90">Guam</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-->