一个简单的二级联动

<%

dim rsdim sqldim countdim rs1dim sql1sql = "SELECT * FROM class where parentid<>0"set rs = conn.execute(sql)%><script language = "JavaScript">var onecount;onecount=0;subcat = new Array();        <%        count = 0        do while not rs.eof         %>subcat[<%=count%>] = new Array("<%= trim(rs("name"))%>","<%= trim(rs("parentid"))%>","<%= trim(rs("cid"))%>");        <%        count = count + 1        rs.movenext        loop        rs.close        set rs=nothing        %>onecount=<%=count%>;

function changelocation(locationid)    {    document.myform.sclassname.length = 0;

    var locationid=locationid;    var i;    document.myform.sclassname.options[0] = new Option('=二级类别=','');    for (i=0;i < onecount; i++)        {            if (subcat[i][1] == locationid)            {    //alert(subcat[i][1]);                document.myform.sclassname.options[document.myform.sclassname.length] = new Option(subcat[i][0], subcat[i][2]);            }                }

    }    </script>

 

<form action="" name="myform" method="post">

<table>

<tr>      <td><div align="right">产品类别：</div></td>      <td height="25"><label>        <select name="bclassname" onChange="changelocation(document.myform.bclassname.options[document.myform.bclassname.selectedIndex].value)">        <%                sql1 = "SELECT * FROM class where parentid=0"        set rs1 = conn.Execute (sql1)        do while not rs1.eof        %>        <option value="<%=trim(rs1("cid"))%>"><%=trim(rs1("name"))%></option>        <%        rs1.movenext        loop        rs1.close        set rs1 = nothing        conn.Close        set conn = nothing        %>    </select>    <select name="sclassname">        <option selected value="">=二级类别=</option>    </select><script LANGUAGE="javascript">     //changelocation(document.myform.bclassname.options[document.myform.bclassname.selectedIndex].value); </script>              </label></td>    </tr>

</table>

</from>