JS 脚本:
-
หรี่แสง
dimsql
ลดน้อยลง
Dimrs1
dimsql1
SQL = "SELECT*FRONGIONORDYBYZONEIDASC"
setRs = server.createObject ("adodb.recordset"))
Rs.opensql, Conn, 1,3
-
<scriptLanguage = "JavaScript">
Varonecount;
onecount = 0;
subcat = newarray ();
-
นับ = 0
dowhilenotrs.eof
-
subcat [<%= count%>] = newarray ("<%= trim (rs (" regionname "))%>", "," <%= trim (rs ("zoneid"))%> "," <%= trim (rs ("regionid"))%> ");
-
นับ = นับ+1
Rs.Movenext
วง
Rs.close
setrs = ไม่มีอะไร
-
oneCount = <%= นับ%>;
FunctionChangelocation (ZONEID)
-
document.myform.region.length = 0;
varzoneid = zoneid;
Vari;
document.myform.region.options [0] = newOption ('-地区-', '');
สำหรับ (i = 0; i <onecount; i ++)
-
if (subcat [i] [1] == ZoneID)
-
document.myform.region.options [document.myform.region.length] = newoption (subcat [i] [0], subcat [i] [2]);
-
-
-
</script>
表单内容:
<table>
<form>
<tr>
<td>
<spanclass = "style1">*</span> 大区：
<selectName = "zone" size = "1" id = "zone" onChange = "changelocation (document.myform.zone.options [document.myform.zone.selectedIndex] .Value)"
<optiveValue = 0Selected> 请选择 </petion>
-
SQL1 = "SELECT*FromBigZoneOrderByzonenameasc"
setRs1 = server.createObject ("adodb.recordset"))
Rs1.opensql1, Conn, 1,3
-
<%whilenotrs1.eof%>
<optiveValue = "<%= rs1 (" zoneid ")%>"> <%= rs1 ("zonename")%> </portion>
<%rs1.movenext
ใช้
rs1.close
setrs1 = ไม่มีอะไร
-
</select> </td>
<tdwidth = "20%"> <spanclass = "style1">*</span> 地区：
<selectName = "region" size = "1" id = "ภูมิภาค">
<optiveValue = 0Selected> 请选择 </petion>
</เลือก>
</tr>
</form>
</table>