<% set rs=server.CreateObject("adodb.recordset") rs.open "select * from province",conn,3,1 Response.Write("<select id='select0' style='WIDTH: 182px' tabIndex='0' size='1' name='province' onchange='FillData()'>") Response.Write("<option value ='' selected></option>") do while not rs.eof Response.Write("<option value='"&rs(2)&"'") if Request("province")=rs(2) then Response.Write("selected") end if Response.Write(">"&rs(2)&"</option>") rs.movenext loop Response.Write("</select></td>") %>
<td><font size="2">所在城市</font></td> <td>
<% set rs=server.CreateObject("adodb.recordset") set rs1=server.CreateObject("adodb.recordset") rs.open "select count(*) number from city",conn,3,1 rs1.Open "select province,city from city",conn,3,1 strNum=rs("number") dim strarry() 'Response.Write strNum redim strarry(strNum,2)
i=0 do while not rs1.EOF strarry(i,0)=rs1("province") strarry(i,1)=rs1("city") ' Response.Write rec("cname")&"<br/>" 'Response.Write strarry(i,1)&"<br/>" rs1.movenext i=i+1 loop rs.close rs1.close
%> <select id="select1" style="WIDTH: 162px" name="city"><option selected></option></select></td></tr> <script language=Javascript> <!-- function FillData() { var bb="<%=Request.form("city")%>"; //msgbox(bb); var aa=org.select0.value; var t=0 var subcat=new Array(); <%for i=0 to strNum%> subcat[<%=i%>]=new Array("<%=strarry(i,0)%>","<%=strarry(i,1)%>"); <%next%> //window.alert(subcat[3][1]) org.select1.length=0 ccc="<%=strNum%>" for (i=0;i < ccc; i++) { if (subcat[i][0] == aa) { org.select1.options[org.select1.length] = new Option(subcat[i][1], subcat[i][1]) if (bb==subcat[i][1]) { org.select1.options[t].selected=true; } t=t+1; } } } function cc() { window.alert("ok") } --> </script>
<option value="0" <%if(subcat[i].equals("0")){%>selected<%}%>>value</option>
set rs=server.CreateObject("adodb.recordset")
rs.open "select * from province",conn,3,1
Response.Write("<select id='select0' style='WIDTH: 182px' tabIndex='0' size='1' name='province' onchange='FillData()'>")
Response.Write("<option value ='' selected></option>")
do while not rs.eof
Response.Write("<option value='"&rs(2)&"'")
if Request("province")=rs(2) then
Response.Write("selected")
end if
Response.Write(">"&rs(2)&"</option>")
rs.movenext
loop
Response.Write("</select></td>")
%>
<td><font size="2">所在城市</font></td>
<td>
<%
set rs=server.CreateObject("adodb.recordset")
set rs1=server.CreateObject("adodb.recordset")
rs.open "select count(*) number from city",conn,3,1
rs1.Open "select province,city from city",conn,3,1
strNum=rs("number")
dim strarry()
'Response.Write strNum
redim strarry(strNum,2)
i=0
do while not rs1.EOF
strarry(i,0)=rs1("province")
strarry(i,1)=rs1("city")
' Response.Write rec("cname")&"<br/>"
'Response.Write strarry(i,1)&"<br/>"
rs1.movenext
i=i+1
loop
rs.close
rs1.close
%>
<select id="select1" style="WIDTH: 162px" name="city"><option selected></option></select></td></tr>
<script language=Javascript>
<!--
function FillData()
{
var bb="<%=Request.form("city")%>";
//msgbox(bb);
var aa=org.select0.value;
var t=0
var subcat=new Array();
<%for i=0 to strNum%>
subcat[<%=i%>]=new Array("<%=strarry(i,0)%>","<%=strarry(i,1)%>");
<%next%>
//window.alert(subcat[3][1])
org.select1.length=0
ccc="<%=strNum%>"
for (i=0;i < ccc; i++)
{
if (subcat[i][0] == aa)
{
org.select1.options[org.select1.length] = new Option(subcat[i][1], subcat[i][1])
if (bb==subcat[i][1])
{
org.select1.options[t].selected=true;
}
t=t+1;
}
}
}
function cc()
{
window.alert("ok")
}
-->
</script>
<option value="0" <%if(subcat[i].equals("0")){%>selected<%}%>>value</option>
******//正解