Question

asp下拉列表，我想按在列表中选中的值，在数据库中查询怎么实现？我写的代码在下面，各位大哥帮忙指点

<select name="first">
<%
sql = "select [type_id],[type_name] from [type_tree]"
set rs = conn.execute(sql)'取得父类的ID及名称
if rs.eof or rs.bof then
response.write "<option>-----</option>" '如果没有记录，就显示-----
else
while not(rs.eof or rs.bof) '有记录，就将父名称列出来，形成下拉。
response.write ("<option value='?sec=" & rs(0) & "'")
if cstr(rs(0)) = request.querystring("sec") then
response.write "selected"
end if
response.write (">" & rs(1) & "</option>")
rs.movenext
wend
rs.movefirst '将游标移到第一条，以备下面之用。
end if
subrs.close
set subrs = nothing
rs.close
set rs = nothing
conn.close
set conn = nothing
%>
</select>

Answer 1

<select name="first" onChange=openn(this.value)>
<%
sql = "select [type_id],[type_name] from [type_tree]"
set rs = conn.execute(sql)'取得父类的ID及名称
if rs.eof or rs.bof then
response.write "<option>-----</option>" '如果没有记录，就显示-----
else
while not(rs.eof or rs.bof) '有记录，就将父名称列出来，形成下拉。
response.write ("<option value='?sec=" & rs(0) & "'")
if cstr(rs(0)) = request.querystring("sec") then
response.write "selected"
end if
response.write (">" & rs(1) & "</option>")
rs.movenext
wend
rs.movefirst '将游标移到第一条，以备下面之用。
end if
subrs.close
set subrs = nothing
rs.close
set rs = nothing
conn.close
set conn = nothing
%>
</select>
<script language=JavaScript>
function openn(){
var args = openn.arguments;
if(args[0] == 0) return;
location.href=(args[0]);
}
</script>

Answer 2

你的意思是1.选择下拉列表就出现查询结果 2.提交后 显示
1.方法一 <select onchange="javascript:location.href=this.value;">
</select>
方法二<select name="first" onChange=openn(this.value)>
</select>
<script language=JavaScript>
function openn(url){
location.href=url;
}
</script>
2.就获取结果就好了