<% '---- CursorTypeEnum Values ---- Const adOpenForwardOnly = 0 Const adOpenKeyset = 1 Const adOpenDynamic = 2 Const adOpenStatic = 3 '---- LockTypeEnum Values ---- Const adLockReadOnly = 1 Const adLockPessimistic = 2 Const adLockOptimistic = 3 Const adLockBatchOptimistic = 4 On Error Resume Next MyName = Request("NAME") MyID = Request("ID") If MyID <> "" Then sql = "SELECT * FROM tblMembers WHERE ID=" & MyID Set Conn = Server.CreateObject("ADODB.Connection") Set rs = Server.CreateObject("ADODB.RecordSet") Conn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" + Server.MapPath("./access_db/the-jobs-site.mdb") rs.Open sql, Conn, adOpenKeyset,adLockReadOnly If Not rs.EOF Then myHow = rs("Hear") myRecruiter = rs("Recruiter") myContact = rs("Name") myCompany = rs("Company") myCountry = rs("Country") myEmail = rs("Email") End If rs.Close Set rs = Nothing Conn.Close Set Conn = Nothing End If %> FREE JOBS LISTINGS IN THE UNITED STATES - Add Your Job Vacancies To The-Jobs-Site.com <% If MyID = "" Then %> <% Else %> <% End If %>
Not just a jobs site but the-jobs-site.com Home
<%If MyName <> "" And MyID <> "" Then %> Home <% Else %> Home <% End If %> <%If MyName <> "" And MyID <> "" Then %> Search the-jobs-site.com for Jobs <% Else %> Search the-jobs-site.com for Jobs <% End If %> Submit Your CV Resume To The CV Index All about the-jobs-site.com - How we work with you to fill those vacancies! Contact us at the-jobs-site.com Latest site news from the-jobs-site.com
  Add your jobs vacancy here.....
<% If MyID = "" Then %> <% End If %>
How did you hear about The Jobs Site?
If a Search Engine or Directory, tell us which one:
Are You A Recruitment Company?:
Your Name: "" Then %> READONLY VALUE="<%=MyName%>" <% End If %>>
Your Position:
Company Name: "" Then %> READONLY VALUE="<%=MyCompany%>" <% End If %>>
Full Company Address:
Your Country: <% If MyID = "" Then %> <% Else %> <% End If %>
Industry Type:
Your business Telephone No:
E-Mail: "" Then %> READONLY VALUE="<%=MyEmail%>" <% End If %>>
Web Site:
Which country/region should your vacancies be listed in?:
Job Title
Specific Location
Level
Job Description - Key Skills Required
Salary Package:
How many of these vacancies are there?:
How long is this vacancy to be displayed (days)?:
Type the characters shown in image for verification.