?? result.asp
字號:
<!--#include file="dbconn.asp"-->
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<script language="javascript">
function popwin1(id,path)
{ window.open("resume/resume.asp?userid="+id+"&ppath="+path,"","height=450,width=580,resizable=yes,scrollbars=yes,status=no,toolbar=no,menubar=no,location=no");
}
</script>
<script language="javascript">
function popwin2(id,path)
{ window.open("contact.asp?userid="+id+"&ppath="+path,"","height=450,width=580,resizable=yes,scrollbars=yes,status=no,toolbar=no,menubar=no,location=no");
}
</script>
<link rel="stylesheet" type="text/css" href="css/cdol.css">
<title>查詢結(jié)果</title>
</head>
<body bgcolor="#e6e5b8" text="#090171">
<p align="left">現(xiàn)在位置:<a href="index.asp">首頁</a>—記錄查詢結(jié)果
<%
session("email")=trim(Request("email"))
session("name")=trim(Request("name"))
workyear = cint(Request("work_year"))
area = TRIM(Request("job_area"))
age0 =cint(Request("old_year_1"))
age1 =cint(Request("old_year_2"))
jclass = TRIM(Request("jobclass_wish"))
sex = TRIM(Request("sex"))
gradu = TRIM(Request("gradu"))
edu = TRIM(Request("edu"))
dim rootRs
Set rootRs=Server.CreateObject("ADODB.RecordSet")
mySQL = "SELECT * FROM resume where date<getdate()"
if sex <> "" then
mySQL = mySQL & "AND sex='"& sex & "'"
end if
if age0 <> "" then
mySQL = mySQL & "AND old>='"& age0 & "'"
end if
if age1 <> "" then
mySQL = mySQL & "AND old<='"& age1 & "'"
end if
if gradu <> "" then
mySQL = mySQL & "AND gradu='"& gradu & "'"
end if
if edu <> "" then
mySQL = mySQL & "AND edu='"& edu & "'"
end if
if workyear <> "" then
mySQL = mySQL & "AND work_year>= '"& workyear & "'"
end if
if area <> "" then
mySQL = mySQL & "AND job_area='"& area & "'"
end if
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -