
<% Select Case Request.QueryString ("s") case "searchJob" Dim lngJobCatId,CatName,strSearch lngJobCatId = Request.QueryString ("id") CatName =Request.QueryString ("CatName") strSearch = Request.Form ("keywords") if Request.QueryString ("id")<>"" then strSql = "SELECT A.*,B.strJobCatName FROM vy_jobs A,vy_JobsCat B where A.bactive<>0 AND A.bdeleted=0 AND A.lngJobCatID=B.lngJobCatID AND A.lngJobCatId="&lngJobCatId Else strSql = "SELECT A.*,B.strJobCatName FROM vy_jobs A,vy_JobsCat B where A.bactive<>0 AND A.bdeleted=0 AND (A.strTitle LIKE ('%"& strSearch &"%') OR A.strDesc LIKE ('%"& strSearch &"%'))AND A.lngJobCatID=B.lngJobCatID" End if Rs.Open strSql, Conn if Rs.bof and rs.eof then %>
| Below are the jobs opportunities that we have available for:<%=CatName%>
We're sorry, but there are currently no positions, currently available for this Jobs category. Please check back again soon, or visit one of the other sections below. |
| Title: | <%=Rs(2)%> |
| Description: | <%=Rs(3)%> |
| Salary: | <%=Rs(4)%> |
| Start Date: | <%=Rs(5)%> |
| Expiry Date: | <%=Rs(6)%> |
| Contact: | <%=Rs(7)%> ( <%=Rs(8)%> ) |
| # of Positions: | <%=Rs(9)%> |
| Qualifications: | <%=Rs(10)%> |
| Location: | <%=Rs(11)%> |
| Special Instructions: | <%=Rs(12)%> |
| Jobs Category: | <%=Rs(15)%> |
|
If your interested in this position, please fill in an Application form. |
|
| Category Search: |
|
|