<% if request.form("actionid")="sc" then Num=request.form("ID").count for i=1 to num sql="insert into mailing (job_id,job_username,resume_id,resume_username,adddate,state,direction) VALUES("&request.form("ID")(i)&","&"'"&setall(request.form("ID")(i),"bjjob","job_id","job_username")&"'"&","&request.form("ID")(i)&","&"'"&session("username")&"'"&",'"&now()&"','collect','应聘')" conn.execute(sql) next else end if if request.form("actionid")="td" then Num=request.form("ID").count for i=1 to num sql="insert into mailing (job_id,job_username,resume_id,resume_username,adddate,state,direction) VALUES("&request.form("ID")(i)&","&"'"&setall(request.form("ID")(i),"bjjob","job_id","job_username")&"'"&","&request.form("ID")(i)&","&"'"&session("username")&"'"&",'"&now()&"','job','应聘')" conn.execute(sql) next else end if set rs=server.createobject("adodb.recordset") if request("keywordtype")=1 then sql = "select * from bjjob where job_username=(select companyname from bjcompany where com_title like '%"&trim(request("keyword"))&"%')" else sql = "select * from bjjob" sql=sql&" where job_name like '%"&trim(request("keyword"))&"%'" if request("job_trade")="0" or request("job_trade")="" then else sql=sql&" and job_trade in ("&request("job_trade")&")" end if if request("in_sort_id")="0" or request("in_sort_id")="" then else sql=sql&" and in_sort_id in ("&request("in_sort_id")&")" end if if request("job_rank")="0" or request("job_rank")="" then else sql=sql&" and job_rank="&request("job_rank") end if if request("job_city")="0" or request("job_city")="" then else sql=sql&" and job_city="&request("job_city") end if if request("issuedate")="0" or request("issuedate")="" then else sql=sql&" and job_add_date>=#"&date()-Cint(request("issuedate"))&"#" end if sql=sql& " and job_state=1 order by job_id desc" end if rs.open sql,conn,1,1 'response.write sql %>