实现asp2级联动菜单 后获取子菜单值的问题!大侠们帮忙
类似于省-城市的二级联动功能已经实现.但是用request( "城市 ")接收城市 菜单/列表值时 接收到的是省的值. 怎么解决啊.
<script language = "JavaScript ">
subcat=new Array();
<%
Dim i
i=0
set rs2=server.createobject( "adodb.recordset ")
sqltext= "select * from [shopxp_stype] "
rs2.open sqltext,conn,1,1
do while not rs2.eof
%>
subcat[ <%=i%> ]=new Array( " <%=rs2( "shopxpse_name ")%> ", " <%=rs2( "shopxpbe_id ")%> ", " <%=rs2( "shopxpse_id ")%> ");
<%
i=i+1
rs2.movenext
loop
rs2.close
%>
function changelocation(locationid)
...{
document.myform.shopxpse_id.length = 0;
var locationid=locationid;
var i;
for (i=0;i <subcat.length; i++)
...{
if (subcat[i][1] == locationid)
...{ //这句不是很理解
document.myform.shopxpse_id.options[document.myform.shopxpse_id.length] = new Option(subcat[i][0], subcat[i][2]);
}
}
}
</script>
<body>
<form name= "myform " method= "post " action= "adproductshopxp_do.asp " OnSubmit= "return checkkk() " >
<table width= "90% " border= "0 " cellpadding= "0 " cellspacing= "5 " bgcolor= "#F1F3F5 ">
<tr >
<td width= "30% " align= "right "> 选择商品的分类: </td>
<td width= "70% ">
大类:
<select name= "shopxpbe_id " size= "1 " id= "shopxpbe_id " onChange= "changelocation(document.myform.shopxpbe_id.options[document.myform.shopxpbe_id.selectedIndex].value) ">
<option selected value= "0 "> 请选择大类 </option>
<%sql= "select shopxpbe_id,shopxpbe_name from shopxp_btype "
set rs=server.CreateObject( "adodb.recordset ")
rs.open sql,conn,1,1
do while not rs.eof%>
<option value= " <%=rs(0)%> "> <%=rs(1)%> </option>
<%rs.movenext
loop
rs.close%>
</select>
小类:
<select name= "shopxpse_id ">
<option selected value= "0 "> 请选择小类 </option>
</select> </td>
</tr>
备注:数据库结构:
shopxp_btype表:shopxpbe_id,shopxpbe_name (看作父类)
shopxp_stype表:shopxpse_id,shopxpse_name,shopxpbe_id(看作子类)
[解决办法]
Request( "shopxpse_id ")取城市,Request( "shopxpbe_id ")取省份
[解决办法]
document.myform.shopxpse_id.options[document.myform.shopxpse_id.length] = new Option(subcat[i][0], subcat[i][2]);
赋值是赋了的,一个是name,一个是value,
你用
alert(subcat[i][0]);
alert(subcat[i][2]);
测试下看看有没有值。?