<%
dim realname,sex,edu1,job_name,modify_date
strsql="select top 7 info_id,realname,edu1,job_name,modify_date from person_resume where checked='y' and work_age<>'应届毕业生' and edu1='本科' and active=1 order by modify_date desc"
RS.Open strSql,conn_member
for i=1 to 7
info_id=rs("info_id")
realname=trim(rs("realname"))
edu1=rs("edu1")
job_name=rs("job_name")
modify_date=datevalue(rs("modify_date"))
%>
 |
target=_blank class=b12h>
<%=realname%> |
<%=edu1%> |
<%=job_name%> |
<%
rs.movenext
next
rs.close
'set rs=nothing
'conn_member.close
'set conn_member=nothing
%>
|
 |
<%
strsql="select top 7 info_id,realname,edu1,job_name,modify_date from person_resume where checked='y' and edu1='硕士' and active=1 order by modify_date desc"
RS.Open strSql,conn_member
for i=1 to 7
info_id=rs("info_id")
realname=trim(rs("realname"))
edu1=rs("edu1")
job_name=rs("job_name")
modify_date=datevalue(rs("modify_date"))
%>
 |
target=_blank class=b12h>
<%=realname%> |
<%=edu1%> |
<%=job_name%> |
<%=month(modify_date)&"/"&day(modify_date)%> |
<%
rs.movenext
next
rs.close
'set rs=nothing
'conn_member.close
'set conn_member=nothing
%>
|
 |
<%
sql="select top 6 * from ershou_info where lei_xing='求职' and shen_he='Y' and sort=108 order by zhi_ding desc,input_date desc"
'set rs=server.createobject("Adodb.recordset")
rs.open sql,conn_info_free,2,3
for i=1 to 6
if rs.eof then exit for
%>
 |
<%=left(rs(9),14)%>..
|
<%=month(rs(12))&"/"&day(rs(12))%> |
<%
rs.movenext
next
rs.close
'set rs=nothing
conn_info_free.close
set conn_info_free=nothing
%>
|
|