select case show
case "0"
set rs=cn.execute(sql)
case "1"
rs.open SQL,cn,3,2
showResult
case "2"
rs.open SQL,cn,1,1
showResult
case "3"
rs.open SQL,cn,3,1
showResult
end select
if rs.state=1 then rs.close
cn.close
set rs=nothing
set cn=nothing
end if
sub showResult
response.Write "<table border=1><tr>"
for i=0 to rs.fields.count -1
response.Write "<td>"
response.Write rs(i).name
response.Write "</td>"
next
response.Write "</tr>"
do while not rs.eof
response.Write "<tr>"
for i=0 to rs.fields.count -1
response.Write "<td>"
response.Write rs(i).value
response.Write "</td>"
next
response.Write "</tr>"
rs.movenext
loop
response.Write "</table>"
end sub
%>
</body>
在页首加上
if request.form("Search")="搜索" then
set rs=conn.execute("select * from job where duix like '%们%'")
....
列出搜索值
else
显示搜索表单
end if
search改成你的搜索按钮的名字就可以了。。