|
<%
set objRsJobList = server.CreateObject("adodb.recordset")
objRsJobList.Open "select * from job_master where job_closed=0 order by job_title asc",objConn,1,3
%>
| Current Opportunities |
|
| Ref No. |
Brief Description |
Posted On |
View |
|
<%
if objRsJobList.EOF and objRsJobList.BOF then
%>
Sorry!!
Currently there are no opportunities. |
<%
else
slno = 0
bgCol = 0
bgColor = "#e9e9e9"
while not objRsJobList.EOF and not objRsJobList.BOF
slno = slno+1
bgCol = bgCol +1
if objRsJobList("job_refno") = "" then
RefNo = "Nill"
else
refNo = objRsJobList("job_refno")
end if
if isNull(objRsJobList("job_company")) or objRsJobList("job_company")="" then
jobCompany = "Not Specified"
else
jobCompany = objRsJobList("job_company")
end if
if bgCol=2 then
%>
<%
bgCol=0
else
%>
<%
end if
%>
| <%=refno%> |
" class="center-link"><%=objRsJobList("job_title")%> |
<%=formatDateTime(objRsJobList("job_postedon"),2)%> |
" class="center-link"> |
<%
objRsJobList.MoveNext()
wend
objRsJobList.Close
end if
%>
|
|
|
|
|