求一个asp多条件查询代码?谢了
我的代码是这样的但用不了
<table width="84%" height="37" border="0" align="right" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
<form name="form2" method="post" action="research.asp">
<tr>
<td width="100%" align="right"> <input name="searchkey" type="text" class=wenbenkuang id="searchkey9" size="13">
<%set rs=server.CreateObject("adodb.recordset")
rs.open "select * from btype order by btype_idorder",conn,1,1
%>
<select name="btype_id" class="wenbenkuang">
<option value="0" selected>查讯产品大类</option>
<%do while not rs.eof%>
<option value="<%=rs("btype_id")%>"><%=trim(rs("btype_name"))%></option>
<%rs.movenext
loop
rs.close
set rs=nothing%>
</select>
<%set rs=server.CreateObject("adodb.recordset")
rs.open "select * from stype order by stype_idorder",conn,1,1
%>
<select class="wenbenkuang" name="select2">
<option value="0" selected>查讯产品小类</option>
<%do while not rs.eof%>
<option value="<%=rs("stype_id")%>"><%=trim(rs("stype_name"))%></option>
<%rs.movenext
loop
rs.close
set rs=nothing%>
</select>
<input class="go-wenbenkuang" type=submit name="submit2" value="搜索">
</td>
</tr>
</form>
参考答案:改为<%set rs=server.CreateObject("adodb.recordset")
sql="select * from btype order by btype_idorder"
rs.open sql,conn,1,1
%>
或者
<%set rs=server.CreateObject("adodb.recordset")
rs.execute ("select * from btype order by btype_idorder"),conn,1,1
%>