%>
<script language = "JAVAscript">
var onecount;
coecount=0;
function changelocation(locationid)
{
var locationid=this.classid.text;
tiaojian=locationid;
<%
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("Database/bgxt.mdb")
set db = Server.CreateObject("ADODB.Connection")
db.open strConnString
Set rs= Server.CreateObject("ADODB.Recordset")
sql="select * from class where Nclass like '"&tiaojian&"'"
rs.open sql,db,1,1
count=0
do while not rs.eof
%>
subcat[<%=count%>]=new array("<%=trim(rs("Nclass"))%>","<%= trim(rs("classid"))%>","<%= trim(rs("Nclassid"))%>");
<% rs.movenext
loop
rs.close
%>
onecount=<%=count%>;
document.myfrom.classid.length=0;
var locationid=locationid;
var i;
for(i=0;i<onecount;i++)
{
document.myform.classid.options[document.myform.classid.length]=new option(subcat[i][0],subcat[i][1]);
document.myform.classid.length=documen.myform.classid.lenght+1;
}
</script>
<form name="myform" method="post" action="temp1.asp">
<table width="75%" border="1">
<tr>
