这样的问题如何解决

[afeng888]

我想实现下面的功能：当用户选择一级菜单时后面的二级菜单也随着改变，如一级菜单选1，二级为11，12，13；当一级菜单选2，二级为21，22，23；其中下拉单内容都是数据库里的，类似www.hand2hand.com.cn
如果有代码参考就太好了

[DeltaCat]

哪部分不能执行？

[icool8]

这是我写的，你看看！


<!--#include file="include/conn.inc.asp"-->
<%
dim mstrsql,rs,tmpclassname

%>

<script language="JavaScript1.2">
<!--
var arrclassname = new Array;
var arrclass2name = new Array;
var arrispaimai = new Array;
var j=0;
arrclassname[0]="请选择..."
<%
mstrsql="SELECT class.ispaimai,class.id as classid,class.class_name,class2.id as class2id,class2.class2_name FROM class left join class2 on class.id=class2.class_id"
set rs=conn.execute(mstrsql)
tmpclassname=""
while not rs.EOF
if tmpclassname <> rs("class_name") then
tmpclassname=rs("class_name")
if rs("ispaimai") then
%>
arrispaimai[j]=<%=rs("classid")%>
j=j+1;
<%
end if
%>
arrclass2name[<%= rs("classid") %>] = new Array;

arrclassname["<%=rs("classid")%>"]="<%= rs("class_name") %>";
<%
end if
if rs("class2_name") <> "" then
%>
arrclass2name[<%=rs("classid")%>][<%=rs("class2id")%>]="<%=rs("class2_name")%>";
<%
end if
rs.movenext()
Wend
rs.close()
set rs=nothing

%>
function classmenu()
{
var i;
var j=0;
class1 = document.form1.class1;
for(i = 0; i < arrclassname.length; i++)
{

if(arrclassname[i]=="" || arrclassname[i]== null)
{
j-=1;
}
else
class1.options[j] = new Option(arrclassname[i],i);
j+=1;

}
class1.length = j;
}

function selectclass()
{
isshow=false
class1 = document.form1.class1;
selclass = parseInt(class1.selectedIndex);
classindex = class1[selclass].value;
arrclass2namelist = arrclass2name[classindex];
class2 = document.form1.class2;
var j=1;

if(arrclass2namelist != null)
{
class2 = document.form1.class2;
if (arrclass2namelist.length>1)
{
class2.options[0] = new Option("请选择小分类",-1);
for(i = 0; i < arrclass2namelist.length; i++)
{
if(arrclass2namelist[i]=="" || arrclass2namelist[i]== null)
{
j-=1;
}
else
{
str = arrclass2namelist[i];
class2.options[j] = new Option(str, i);
}
j+=1;
}
class2.length = j;
}
else
{
str = arrclass2namelist[0];
class2.options[0] = new Option(str,str);
class2.length=1;
class2.options[0].selected;
}



}
else{
if (class2 != null){
class2.options[0] = new Option("请先选择大分类",-1);
class2.length = 1;}
}
}
-->
</script>


<form action="search.asp" method="post" name="form1" id="form1">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="15%">站内搜索：</td>
<td width="20%"> <select class="input" name="class1" id="class1" onChange="javascript:selectclass()">
</select> <script language="javascript">
classmenu();
</script></td>
<td width="20%"> <select class="input" name="class2" id="class2">
<option value=-1>请先选择大分类</option>
</select> <input name="action" type="hidden" id="action" value="search"></td>
<td width="25%"> <input class="input" name="msg" type="text" id="msg" value="请输入搜索内容" size="15">
</td>
<td width="20%"><input class="input" type="submit" name="Submit" value="搜 索"></td>
</tr>
</table>
</form>

[rexsp]

就是连动嘛。。
我找找，给你一串

<table width="150" border="0" cellspacing="0" cellpadding="2">
<form action='' method="post" name="search" >

<tr>
<td colspan="2" background="export/leftbg2.gif" class="lefttitle">搜索</td>
</tr>
<tr>
<td colspan="2" align="center" class="12-fix-gray">
<select name="user" class="textfield" onchange="SelectUser(this.value);">
<option value="0" selected>请选择用户类别</option>
<option value="1">用人单位</option>
<option value="2">学生</option>
</select></td>
</tr>
<tr>
<td colspan="2" align="center" class="12-fix-gray"><img src="export/space.gif" width="100" height="10"></td>
</tr>
<tr>
<td colspan="2" align="center" class="12-fix-gray">
<%dim sqls,rss,i
sqls="select collegeid,CollegeName from college order by collegeid "
set rss=server.createobject("adodb.recordset")
rss.open sqls,conn,1,1
if rss.eof then
response.write "没有信息"
else
dim TotalClass,Assay,rows
Assay=Rss.GetRows
Rows=Ubound(Assay,2)
end if
rss.close

sqls="select DepartName,collegeid,id from Depart order by collegeid desc "
rss.open sqls,conn,1,1
if rss.eof then
response.write"没有信息"
else
dim Assay2,rowdepartment
Assay2=Rss.GetRows
Rowdepartment=Ubound(Assay2,2)
end if
rss.close
set rss=nothing

%>

<TR>
<TD bgcolor="#4371AF">
<script language="JavaScript">
<!--
var subcat = new Array();
<%
for i=0 to Rowdepartment
response.write "subcat["&i&"] = new Array('"&Assay2(1,i)&"','"&Assay2(0,i)&"','"&Assay2(2,i)&"')"&chr(13)
next
%>
function changeselect1(locationid)
{
document.search.department.length = 0;
document.search.department.options[0] = new Option('==请选择==','');
for (i=0; i<subcat.length; i++)
{
if (subcat[i][0] == locationid)
{document.search.department.options[document.search.department.length] = new Option(subcat[i][1], subcat[i][2]);}
}
}

function SelectUser(idvalue)
{var userform=document.search.user;
var departform=document.search.department;
var collegeform=document.search.s1
if (idvalue==1)
{departform.disabled=true;
collegeform.disabled=true;
document.search.stuquery.disabled=false
document.search.action='companylist.asp'}
else if (idvalue==2)
{departform.disabled=false;
collegeform.disabled=false;
document.search.stuquery.disabled=false
document.search.action='stu_list.asp'}
else
{departform.disabled=true;
collegeform.disabled=true;
document.search.stuquery.disabled=true
}
}

//-->
</script><select name="s1" onChange="changeselect1(this.value)" disabled=true>
<option>请选择院系</option>
<%
for i=0 to Rows
response.write"<option value="&Assay(0,i)&">"&Assay(1,i)&"</option>"
next%></select></td>
</tr>
<tr><td><select name="department" disabled=true>
<option value="">请选择专业</option>
</select></td></tr>
<tr>
<td height="18" colspan="2" align="center" class="12-fix-gray"> </td>
</tr>
<tr>
<td colspan="2" align="center" class="12-fix-gray"><font color="#FFFFFF">
<INPUT TYPE="text" NAME="stuquery" size=15 disabled=true></TD>
</tr>
<tr>
<td width="66" align="center" class="12-fix-gray" colspan=2><input name="submit" type="submit" class="textfield" value="检索" ></td>

</tr>
</form>
</table>

[DeltaCat]

你看一下他的源代码就明白了，里面比较清楚

[afeng888]

我是这样的，但JAVASCRIPT不能检测，我说的是对表单的
<%@ Language=VBScript %>
<!--#include file="../conn/conn.asp"-->

<html>
<head>
<title>List</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="../css.css" type="text/css">

<%
dim rs
dim sql
dim count
dim rs1
dim sql1
sql = "select * from district order by locationid asc"
set rs = conn.execute(sql)
%>
<script language = "JavaScript">
var onecount;
onecount=0;
subcat = new Array();
<%
count = 0
do while not rs.eof
%>
subcat[<%=count%>] = new Array("<%= trim(rs("districtname"))%>","<%= trim(rs("locationid"))%>","<%= trim(rs("districtid"))%>");
<%
count = count + 1
rs.movenext
loop
rs.close
set rs=nothing
%>
onecount=<%=count%>;

function changelocation(locationid)
{
document.myform.smalllocation.length = 0;

var locationid=locationid;
var i;
document.myform.smalllocation.options[0] = new Option('====所有分类====','');
for (i=0;i < onecount; i++)
{
if (subcat[i][1] == locationid)
{
document.myform.smalllocation.options[document.myform.smalllocation.length] = new Option(subcat[i][0], subcat[i][2]);
}
}

}
</script>
</head>
<body>
<form name="myform" method="post" action="Ok_login.asp" onSubmit="return Check();" >
<table width="500" align="left" cellpadding="3" cellspacing="3">
<tr>
<td>标　　题：</td>
<td><input name="title" type="text" id="title" size="30" maxlength="100"></td>
</tr>

<tr>
<td width="66">分类</td>
<td width="411"> <select name="biglocation" onChange="changelocation(document.myform.biglocation.options[document.myform.biglocation.selectedIndex].value)">
<%

sql1 = "select * from location order by locationid asc"
set rs1 = conn.Execute (sql1)
do while not rs1.eof
%>
<option value="<%=trim(rs1("locationid"))%>"><%=trim(rs1("locationname"))%></option>
<%
rs1.movenext
loop
rs1.close
set rs1 = nothing
conn.Close
set conn = nothing
%>
</select> <select name="smalllocation">
<option selected value="">==所有分类==</option>
</select></td>
</tr>
<tr>
<td>说　　明：</td>
<td><textarea name="textarea" cols="30"></textarea></td>
</tr>
<tr>
<td> </td>
<td><input type="submit" name="Submit" value="提交">
　　
<input type="reset" name="Submit2" value="重置"></td>
</tr>
</table>
</form>
</td></tr></table>
<script LANGUAGE="javascript">
changelocation(document.myform.biglocation.options[document.myform.biglocation.selectedIndex].value);
</script>
</body>
</html>
<script LANGUAGE="javascript">
<!--
function checkspace(checkstr) {
var str = '';
for(i = 0; i < checkstr.length; i++) {
str = str + ' ';
}
return (str == checkstr);
}
function check()
{
if(checkspace(document.myform.title.value)) {
document.myform.title.focus();
alert("严重错误！没有输入标题！");
return false;
}

document.myform.submit();
}
//-->
</script>//不能执行

[afeng888]

帮忙看看啊

[afeng888]

下面的部分不能执行
<script LANGUAGE= "javascript " >
<!--
function checkspace(checkstr) {
var str = '';
for(i = 0; i < checkstr.length; i++) {
str = str + ' ';
}
return (str == checkstr);
}
function check()
{
if(checkspace(document.myform.title.value)) {
document.myform.title.focus();
alert( "严重错误！没有输入标题！ ");
return false;
}

document.myform.submit();
}
//-- >
</script >//不能执行

[afeng888]

帮帮忙啊