adminjobsdel.asp

来自「人才招聘系统,用asp做的」· ASP 代码 · 共 24 行

	<!--#include file=../../conn.asp-->
	<!--#include file=cookies.asp-->
	<link rel="stylesheet" type="text/css" href="../IMG/jobcn.css">
<%
dim rs,sql,id
id=request.cookies("ijob")("bmid")
set rs=server.createobject("adodb.recordset")
sql="delete from [jobs] where id='"&cstr(request("id"))&"' and comid='"&request.cookies("ijob")("comid")&"'"
rs.open sql,conn,1,3

sql="delete from [ApplyResume] where jobsid='"&trim(request("id"))&"' and comid='"&request.cookies("ijob")("comid")&"'"
rs.open sql,conn,1,3

sql="delete from [ApplyHistory] where jobsid='"&trim(request("id"))&"'"
rs.open sql,conn,1,3

sql="delete from [MyFavouriate] where jobsid='"&trim(request("id"))&"'"
rs.open sql,conn,1,3
conn.close
set conn=nothing
response.write "<br>"+"<li><font color=""#ff0000"">操作成功！</font>"
response.write "<br>"+"<li>正在返回....请稍等!!!!!"
response.write "<meta http-equiv=refresh content=""2;URL=listjobs.asp"">"
%>