请指教,急
<body><script language="javascript">
function query_onkeydown(){
if(window.event.keycode==13){
document.form1.btnquery.click();
}
}
</script>
<%
nquery=trim(request.Form("query"))
mm_conn= "provider=sqloledb;server=172.16.30.2;uid=aaa;pwd=123456;database=test"
set conn=server.CreateObject("adodb.connection")
conn.open mm_conn
set rs=server.CreateObject("adodb.recordset")
rs.open "select * from person order by userid ",conn,1,1
strquery="select *"
strquery=strquery & "from person"
rs.open strquery,conn,1,1
%>
<form action="" method="post" name="form1">
<p>请选择:
<select id="query" name="query" style="height:22px;width:180px">
<option selected value="all">全部内容</option>
<% do while not rs.eof %>
<option <%if rs.fields("userid")=nquery then%> selected <%end if%> value="<%=trim(rs.fields("userid"))%>"><%=rs.fields("userid")%></option>
<%rs.movenext
loop
'rs.close
%>
</select>
<input type="submit" id="btnquery" name="btnquery" value="开始查询">
</p>
<table border="1" cellpadding="0" cellspacing="0" bordercolor="gray" bgcolor="#99CCFF" width="800">
<tr align="center" height="20">
<td width="15%" height="29" align="middle">userid</td>
<td width="25%" align="middle">firstname</td>
<td width="25%" align="middle">lastname</td>
<td width="15%" align="center"> age</td>
<td width="20%" align="middle">adress</td>
</tr>
<%
do while not rs.eof
if isnull(nquery) or len(trim(nquery))<=0 or trim(nquery)="all" then
%>
<tr align="center" height="20">
<td width="15%" height="29" align="middle"><%rs(0)%></td>
<td width="25%" align="middle"><%=rs(2)%></td>
<td width="25%" align="middle"><%=rs(1)%></td>
<td width="15%" align="center"><%=rs(4)%></td>
<td width="20%" align="middle"><%=rs(3)%></td>
</tr>
<% else
strquery=strquery & "where userid='"& nquery &"'"
end if
strquery=strquery & " order by userid "
session("show")=strquery
'response.Write strquery
'response.end
rs.open strquery,conn,1,1
rs.movenext
i=i+1
loop
%>
</table>
</form>
</body>
请指教为什么不能显示所以记录和按要求查询??