28,390
社区成员
发帖
与我相关
我的任务
分享
<%
dim cid,coid
cid=Request("cid")
coid=Request("coid")
Set rs=CreateObject("adodb.recordset")
rs.open "Select * from FittingsType",conn,1,1 '获取大类数据
strOption1 = " <option value= ''>=请选择分类= </option >"
do while not rs.eof
if cstr(rs("id")) = cstr(cid) then
strOption1 = strOption1 & " <option value='" & rs("id") & "' selected >" & rs("typename") & "</option >"
else
strOption1 = strOption1 & " <option value= '" & rs("id") & "'>" & rs("typename") & "</option >"
end if
rs.movenext
loop
rs.close
rs.open "Select * from mode",conn,1,1 '获取小类数据
%>
<script language="javascript">
<!--
//先定义大类和小类数组
var minclass=Array();
<%
js=0
do while not rs.eof%>
minclass[<%=js%>]=new Array("<%=rs("id")%>","<%=rs("mode")%>","<%=rs("typeid")%>");
<%rs.movenext
js=js+1
loop
rs.Close
Set rs=nothing
Conn.Close
Set Conn=nothing
%>
function changesmall()
{
var indexvalue=document.all("cid").options[document.all("cid").selectedIndex].value;
var j=0;
document.all("coid").length = 0;
document.all("coid").options[0]=new Option("=请选择型号=","0");
for(i=0;i<minclass.length;i++)
{
if(minclass[i][2]==indexvalue)
{
document.all("coid").options[document.all("coid").length]=new Option(minclass[i][1],minclass[i][0]);
}
}
}
function setvalue(cvalue)
{
var m,n;
m=document.all("coid").length;
for(n=0;n<m;n++)
{
if(document.all("coid").options[n].value==cvalue)
{
document.all("coid").selectedIndex=n;
return;
}
}
}
-->
</script>
<script language="javascript" defer="defer">
setvalue("<%=coid%>");
</script>
<select onchange="changesmall()" name="cid" > <%=strOption1%> </select >
<select name="coid">=请选择型号=</select>