<%dim conndim rsdim sqldim countdim rs1dim sql1sql = "SELECT * FROM lei_area_table where paterid<>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("paterid"))%>","<%= trim(rs("id"))%>"); <% count = count + 1 rs.movenext loop rs.close set rs=nothing %>onecount=<%=count%>;
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) { //alert(subcat[i][1]); document.myform.smalllocation.options[document.myform.smalllocation.length] = new Option(subcat[i][0], subcat[i][2]); } }//保存选择参数 for (i=0;i<document.newform.city.length;i++){ //alert(document.myform.smalllocation[i].value); if (document.newform.city[i].value==document.newform.cityselect.value){ document.newform.city[i].selected=true; } } } </script></head><body><form name="myform" method="post"> <select name="biglocation" onChange="changelocation(document.myform.biglocation.options[document.myform.biglocation.selectedIndex].value)"> <% sql1 = "SELECT * FROM lei_area_table where paterid=0" set rs1 = conn.Execute (sql1) do while not rs1.eof %> <option value="<%=trim(rs1("id"))%>"><%=trim(rs1("name"))%></option> <% rs1.movenext loop rs1.close set rs1 = nothing conn.Close set conn = nothing %> </select> <select name="smalllocation"> <option selected value="">==所有地区==</option> </select></form><script LANGUAGE="javascript"> changelocation(document.myform.biglocation.options[document.myform.biglocation.selectedIndex].value); </script>
