人才市场首页调用

个人求职改动了一下
代码：

dim c_id,p_id,c_name,p_job,c_job,p_tim,c_tim,p_iname,p_sex,isex
sql="select top 8 id,job,tim,iname,sex from person where hidden=1 order by tim desc"
set rs=conn.execute(sql)
do while not rs.eof
p_id=rs("id")
p_job=rs("job")
p_tim=rs("tim")
p_iname=rs("iname")
p_sex=rs("sex")
if p_sex=true then isex="男" else isex="女"
response.write vbcrlf&" <tr><td height='"&dim_num(6)&"' style='border-bottom:1px dotted #e0e0e0'><img src='skin/"&joekoe_cms.web_skin&"/small/h_forum.gif' border=0 align=absMiddle> "&p_iname&" ("&isex&") <a href='job_person_view.asp?id="&p_id&"' target=_blank alt='个人求职'>"&joekoe_cms.code_html(p_job,1,20)&"</a></td><td class=tims style='border-bottom:1px dotted #e0e0e0' align=right>"&joekoe_cms.time_type(p_tim,4)&"</td></tr>"
rs.movenext
loop
rs.close


大体代码,可选其一
dim c_id,p_id,c_name,p_job,c_job,p_tim,c_tim

'个人求职
sql="select top 10 id,job,tim from person  where hidden=1  order by tim desc"
set rs=jconn.execute(sql)
do while not rs.eof
p_id=rs("id")
p_job=rs("job")
p_tim=rs("tim")
response.write vbcrlf&" <tr><td height='"&dim_num(6)&"' style='border-bottom:1px dotted #e0e0e0'><img src='skin/"&joekoe_cms.web_skin&"/small/h_forum.gif' border=0 align=absMiddle><a href='job_person_view.asp?id="&p_id&"' target=_blank alt='个人求职'>"&joekoe_cms.code_html(p_job,1,20)&"</a></td><td class=tims style='border-bottom:1px dotted #e0e0e0' align=right>"&joekoe_cms.time_type(p_tim,4)&"</td></tr>"
rs.movenext
loop
rs.close
'企业招聘
sql="select top 10 id,job,tim from job where hidden=1 order by tim desc"
  set rs=conn.execute(sql)
  do while not rs.eof
  c_id=rs("id")
  c_job=rs("job")
  c_tim=rs("tim")
  response.write vbcrlf&" <tr><td height='"&dim_num(6)&"' style='border-bottom:1px dotted #e0e0e0'><img src='skin/"&joekoe_cms.web_skin&"/small/h_forum.gif' border=0 align=absMiddle><a href='job_view.asp?id="&c_id&"' target=_blank alt='企业招聘'>"&joekoe_cms.code_html(c_job,1,20)&"</a></td><td class=tims style='border-bottom:1px dotted #e0e0e0' align=center>"&joekoe_cms.time_type(c_tim,4)&"</td><td class=red align=right style='border-bottom:1px dotted #e0e0e0'>招聘</td></tr>"
  rs.movenext
  loop
  rs.close

文章来自: Original
引用通告: 查看所有引用 | 我要引用此文章
Tags:
相关日志: