|
<%
if Session("LoggedIn") = "TRUE" then
%>
<%
else
%>
<%
end if
%>
|
 |
|
|
Welcome to the AUCAlumni Career Center. By popular demand we have developed the career center as a resource to assist in landing job opportunities with major corporations across North America!
This is a new member service and we are constantly enhancing and updating. If you do not find the job you are looking for, please check back.
<%
dim conn
dim rs
Set conn = Server.CreateObject("ADODB.Connection")
Set rs = Server.CreateObject("ADODB.Recordset")
conn.Open "dsn=aucjobs"
jobCountSQL ="SELECT job_skey FROM jobs WHERE job_skey > 1 AND job_open = true"
jobSQL = "SELECT a.job_skey, a.contact_skey, a.job_title, a.job_type, a.job_desc, " &_
" a.job_code, a.job_city, a.job_state, a.job_open, a.job_postdate, " &_
" b.contact_phone, b.contact_fax, b.contact_email " &_
" FROM jobs a, jobcontacts b " &_
" WHERE a.job_skey ="&job_skey &_
" AND a.contact_skey = b.contact_skey"
'response.write (jobCountSQL&"
")
rs.Open jobCountSQL,conn, 1, 2
jobcount=0
WHILE NOT rs.EOF
jobcount = jobcount + 1
'finaltitle = to_rtf(rs(2))
'finaljobdesc = to_rtf(rs(4))
'response.write (rs(0)&","&rs(1)&","&rs(6)&"
")
rs.MOVENEXT
WEND
rs.Close
if jobcount <= Session("ShowJobSearchCount") then
Set rs = Server.CreateObject("ADODB.Recordset")
jobSQL = "SELECT a.job_skey, a.contact_skey, a.job_title, a.job_type, a.job_desc, " &_
" a.job_code, a.job_city, a.job_state, a.job_open, a.job_postdate, " &_
" b.contact_phone, b.contact_fax, b.contact_email " &_
" FROM jobs a, jobcontacts b " &_
" WHERE a.job_skey > 1" &_
" AND a.contact_skey = b.contact_skey " &_
" AND a.job_open = true " &_
"ORDER BY a.job_postdate"
'response.write (jobSQL&"
")
rs.Open jobSQL,conn, 1, 2
jobcount = 0
WHILE NOT rs.EOF
jobcount = jobcount + 1
finaltitle = to_rtf(rs(2))
finaljobdesc = to_rtf(rs(4))
'response.write (rs(0)&","&rs(1)&","&rs(6)&"
")
if (jobcount Mod 2) = 0 then
strBGColor = "#eeeeee"
else
strBGColor = "#ffffff"
end if
if jobcount = 1 then
%>
Select from the listing of currently available positions below.
| Posted |
 |
Job Title |
|
Location |
| <%= rs(9) %> |
|
<%= rs(2) %> |
|
<%= rs(6) %> <%= rs(7) %> |
<%
else
%>
| <%= rs(9) %> |
|
career_jobdetails.asp?jk=<%= rs(0) %>"><%= rs(2) %> |
|
<%= rs(6) %> <%= rs(7) %> |
<%
end if
rs.MOVENEXT
WEND
rs.close
conn.close
if jobcount=0 then
%>
There are no jobs in our job database at this time. Please check back as we continue to add new jobs.
<%
else
%>
<%
end if
elseif jobcount > Session("ShowJobSearchCount") then
if noJobsFound = "n" then
%>
No jobs were found using the keywords you entered. You can click search without entering any keywords to view all jobs.
<%
end if
%>
<%
end if
%>
Employers! Post your jobs for FREE! Let us connect you with some of the top candidates Atlanta has to offer. Contact us for more information.
|
| |
|
| |
| SITE SPONSORS |
 |
|
