set rs=server.CreateObject("adodb.recordset")
ziduan=trim(request("name")+"")

sql="select * from instrument where name like '%"+ziduan+"%' "

if len(ziduan)>=1 then
sql=sql+" and name like '%"+ziduan+"%' "
end if
set rs=server.CreateObject("adodb.recordset")
rs.open sql,conn
请问我输入上面的代码,为什么把表格中所有的信息的都显示出来的,根本就没达到查找的功能啊~~~~
到底哪错了,请各位高人指点哦