请教一个动态下拉菜单生成的问题，在线等！！！

<%
        set cnn=server.CreateObject ("adodb.connection")
        set rs=server.createobject("adodb.recordset")
        cnn.open application("connectionstring")
%>
<script LANGUAGE="javascript">
<!--
var onecount;
onecount=0;
subcat = new Array();
<%
        strsql = "select * from tblbureau where 1=1 "
if session("middle_bureau")<>"" then
strsql = strsql & " and  middle_bureau='"  & session("middle_bureau") & "'"
end if
if session("essential_bureau")<>"" then
strsql = strsql & " and essential_bureau='" & session("essential_bureau") & "'"
end if
        set rs =cnn.execute(strsql)
dim i
i=0
do while not rs.eof %>
subcat[<%=i%>] = new Array("<%=rs("essential_bureau")%>","<%=rs("middle_bureau")%>","<%=rs("essential_bureau")%>");<%
i=i+1
rs.movenext
loop
%>
onecount=<%=i%>; function changelocation(locationid)
    {
    document.frmsetup.essential_bureau.length = 0;
    var locationid=locationid;
    var i;
    document.frmsetup.essential_bureau.options[0] = new Option('请选择','');
    for (i=0;i < onecount; i++)
        {
            if (subcat[i][1] == locationid)
            {
            document.frmsetup.essential_bureau.options[document.frmsetup.essential_bureau.length] = new Option(subcat[i][0], subcat[i][2]);
            }
        }     }
//-->
</script>
<form name=frmsetup>
          <tr class=tb2>
            <td width="15%" class=t1>&nbsp;所在区</td>
            <td width="35%" class=t1>&nbsp;<select size="1" name="settle_region" class=f1 onChange="changelocation(document.frmsetup.settle_region.options(document.frmsetup.settle_region.selectedIndex).value)">
                <option value="">请选择</option>
                <option value="罗湖">罗湖</option>
                <option value="福田">福田</option>
                <option value="南山">南山</option>
                <option value="盐田">盐田</option>
                <option value="宝安">宝安</option>
                <option value="龙岗">龙岗</option>
              </select>
            </td>
            <td width="15%" class=t1>&nbsp;所在所</td>
            <td width="35%" class=t1>&nbsp;<select size="1" name="essential_bureau" class=f1>
                <option value="">请选择</option>
              </select>
            </td>
          </tr>
  <script LANGUAGE="javascript">
  <!--
       changelocation(document.frmsetup.settle_region.options(document.frmsetup.settle_region.selectedIndex).value)
  //-->
  </script>
</form>

解决方案 »

  1.   

    <html>
    <head>
    <title>List</title>
    <meta http-equiv="Content-Type" content="text/html; charset=gb2312">
    <script LANGUAGE="javascript">
    <!--
    var onecount;
    onecount=0;
        
    subcat = new Array();
    subcat[0] = new Array("徐汇区","01","001");
    subcat[1] = new Array("嘉定区","01","002");
    subcat[2] = new Array("黄浦区","01","003");
    subcat[3] = new Array("南昌市","02","004");
    subcat[4] = new Array("九江市","02","005");
    subcat[5] = new Array("上饶市","02","006");onecount=6;function changelocation(locationid)
        {
        document.myform.smalllocation.length = 0;     var locationid=locationid;
        var i;
        document.myform.smalllocation.options[0] = new Option('====所有地区====','');
        for (i=0;i < onecount; i++)
            {
                if (subcat[i][1] == locationid)
                { 
                document.myform.smalllocation.options[document.myform.smalllocation.length] = new Option(subcat[i][0], subcat[i][2]);
                }        
            }
            
        }    //-->
    </script>
    </head>
    <body>
    <form name="myform" method="post">
        <select name="biglocation" onChange="changelocation(document.myform.biglocation.options[document.myform.biglocation.selectedIndex].value)">
            <option value="01" selected>上海</option>
            <option value="02">江西</option>
        </select>
        <select name="smalllocation"> 
            <option selected value="">==所有地区==</option>
        </select>
    </form>
    <script LANGUAGE="javascript"> 
    <!-- 
        changelocation(document.myform.biglocation.options[document.myform.biglocation.selectedIndex].value); 
    //--> 
    </script>
    </body>
    </html>
      

  2.   

    <html>
    <head>
    <title>List</title>
    <meta http-equiv="Content-Type" content="text/html; charset=gb2312">
    <script LANGUAGE="javascript">
    <!--
    var onecount;
    onecount=0;
        
    subcat = new Array();
    subcat[0] = new Array("徐汇区","01","001");
    subcat[1] = new Array("嘉定区","01","002");
    subcat[2] = new Array("黄浦区","01","003");
    subcat[3] = new Array("南昌市","02","004");
    subcat[4] = new Array("九江市","02","005");
    subcat[5] = new Array("上饶市","02","006");onecount=6;function changelocation(locationid)
        {
        document.myform.smalllocation.length = 0;     var locationid=locationid;
        var i;
        document.myform.smalllocation.options[0] = new Option('====所有地区====','');
        for (i=0;i < onecount; i++)
            {
                if (subcat[i][1] == locationid)
                { 
                document.myform.smalllocation.options[document.myform.smalllocation.length] = new Option(subcat[i][0], subcat[i][2]);
                }        
            }
            
        }    //-->
    </script>
    </head>
    <body>
    <form name="myform" method="post">
        <select name="biglocation" onChange="changelocation(document.myform.biglocation.options[document.myform.biglocation.selectedIndex].value)">
            <option value="01" selected>上海</option>
            <option value="02">江西</option>
        </select>
        <select name="smalllocation"> 
            <option selected value="">==所有地区==</option>
        </select>
    </form>
    <script LANGUAGE="javascript"> 
    <!-- 
        changelocation(document.myform.biglocation.options[document.myform.biglocation.selectedIndex].value); 
    //--> 
    </script>
    </body>
    </html>