"" and ziduan "" then
sql="select * from ty where "&ziduan&" like '%"&key&"%' order by id desc"
end if
if ziduan"" and sex"" and bumen"" then
sql="select * from ty where "&ziduan&" like '%"&key&"%' "
end if
if key=""then
sql="select * from ty order by ID desc"
end if
set rs=server.CreateObject("adodb.recordset")
rs.open sql,conn,1,1
if rs.eof then
response.write"没有记录"
response.end
end if
rs.PageSize=20
pagecount=rs.PageCount
page=int(request.QueryString ("page"))
if page
想在页面里现实 一车间 男或一车间 在职
bumen=一车间zaizhi=在职 sex=男
部门
bumen=一车间
在职
zaizhi=在职
性别
sex=男
if key"" and ziduan "" then
sql="select * from ty where "&ziduan&" like '%"&key&"%' order by id desc"
end if
这里怎么修改呀 ?