| |
 |
<%
sqlstr = "SELECT distinct(catname),jobtitle,a.catid as catids FROM jobopenings a,category_master b WHERE active_status='A' AND JobType=1 and a.catid = b.catid"
set rs = con.execute(sqlstr)
if not rs.eof then
catname = ""
marqueecontents =""
while not rs.eof
if(catname <> rs("catname")) then
catname = rs("catname")
marqueecontents = marqueecontents + " "& catname &" "
end if
marqueecontents = marqueecontents + " "& rs("jobtitle")& ""
rs.movenext
wend
end if
set rs = nothing
%>
|
|
 |
<%
sqlstr = "SELECT distinct(catname),jobtitle,a.catid as catids FROM jobopenings a,category_master b WHERE active_status='A' AND JobType=2 and a.catid = b.catid"
set rs = con.execute(sqlstr)
if not rs.eof then
catname = ""
marqueecontents1 =""
while not rs.eof
if(catname <> rs("catname")) then
catname = rs("catname")
marqueecontents1 = marqueecontents1 + " "& catname &" "
end if
marqueecontents1 = marqueecontents1 + " "& rs("jobtitle")& ""
rs.movenext
wend
end if
set rs = nothing
%>
|
|
|
|
<%
sqlstr = "SELECT distinct(catname),jobtitle,a.catid as catids FROM jobopenings a,category_master b WHERE active_status='A' AND JobType=3 and a.catid = b.catid"
set rs = con.execute(sqlstr)
if not rs.eof then
catname = ""
marqueecontents2 =""
while not rs.eof
if(catname <> rs("catname")) then
catname = rs("catname")
marqueecontents2 = marqueecontents2 + " "& catname &" "
end if
marqueecontents2 = marqueecontents2 + " "& rs("jobtitle")& ""
rs.movenext
wend
end if
set rs = nothing
%>
|
|
|
|
 |
|
|
|
Job
Alert |
|
Thank you for your interest in Iconium Consulting opportunities. Please provide the following information about your career needs to help us serve you better. This information will enable us to route your request to the appropriate person. |
|
| |
|
|
| |
|
|