主题:感谢各位高手来解决此问题
用以实现一下拉列表,从中选择对应的栏目,各位看看有啥错误的,,
<%
list=trim(replace(request("list"),"'",""))
id=trim(replace(request("id"),"'",""))
%>
<%
set rs=server.createobject("adodb.recordset")
sql = "select * from sblx where sblx='"&list&"' and lxjb<>1 order by sbbh asc"
rs.open sql,conn,1,1
%>
<span class="black">
<select name="select" class="td">
<option selected value="0">请选择类别</option>
<%do while not rs.eof%>
<OPTION value="<%=trim(rs("sbmc"))%>" <%if rs("sbmc")=rs("sbmc") then%>selected<%end if%>><%=trim(rs("sbmc"))%></OPTION>
<%
rs.movenext
loop
rs.close
set rs=nothing
%>
<%
list=trim(replace(request("list"),"'",""))
id=trim(replace(request("id"),"'",""))
%>
<%
set rs=server.createobject("adodb.recordset")
sql = "select * from sblx where sblx='"&list&"' and lxjb<>1 order by sbbh asc"
rs.open sql,conn,1,1
%>
<span class="black">
<select name="select" class="td">
<option selected value="0">请选择类别</option>
<%do while not rs.eof%>
<OPTION value="<%=trim(rs("sbmc"))%>" <%if rs("sbmc")=rs("sbmc") then%>selected<%end if%>><%=trim(rs("sbmc"))%></OPTION>
<%
rs.movenext
loop
rs.close
set rs=nothing
%>