<script language="JavaScript">
<!--
var subcat = new Array();
<%
strSql="SELECT * FROM Vocation WHERE IfDelete='0' AND fatherid<>'0'";
objRs.Open(strSql,objConn,adOpenStatic,adLockReadOnly,1);
if(!objRs.Eof){
i=0;
while (i < objRs.RecordCount) {
Response.Write("subcat["+i+"] = new Array('"+objRs("fatherid")+"','"+objRs("VocationName")+"','"+objRs("VocationId")+"')\n");
i++;
objRs.MoveNext();
}
}
objRs.Close();strSql="SELECT DISTINCT(fatherid) AS VocationId,'' AS Style FROM Vocation WHERE IfDelete='0' AND fatherid<>'0' Union SELECT VocationId,'none' AS Style FROM Vocation WHERE IfDelete='0' AND fatherid='0' AND VocationId NOT IN (SELECT DISTINCT(fatherid) FROM Vocation WHERE IfDelete='0' AND fatherid<>'0')";
objRs.Open(strSql,objConn,adOpenStatic,adLockReadOnly,1);
var style="";
while (!objRs.Eof){
style+="if (locationid == "+objRs("VocationId").value+"){\n";
style+=" document.form1.SubVocation.style.display=\""+objRs("Style").value+"\";\n";
style+="}\n";
objRs.MoveNext();
}
objRs.Close();
%>
function changeselect1(locationid){
<%=style%>
document.form1.SubVocation.length = 0;
document.form1.SubVocation.options[0] = new Option('==请选择==','');
for (i=0; i<subcat.length; i++){
if (subcat[i][0] == locationid){
document.form1.SubVocation.options[document.form1.SubVocation.length] = new Option(subcat[i][1], subcat[i][2]);
}document.form1.SubVocation.style.display="";
}
}
//-->
</script>
<%
%>
<form name="form1" method="post" action="PropertySet.asp" onSubmit="return sub();">
<tr bgcolor="#FFFFFF">
<td width="20%">选择行业业态</td>
<td width="80%">
<select name="Vocation" onChange="changeselect1(this.value)">
<option value="">==请选择==</option>
<%
strSql="SELECT * FROM NQR_Vocation WHERE IfDelete='0' AND fatherid='0'";
objRs.Open(strSql,objConn,adOpenStatic,adLockReadOnly,1);
while (!objRs.Eof){
Response.Write ("<option value=\""+objRs("VocationId").Value+"\">"+objRs("VocationName").Value+"</option>");
objRs.MoveNext();
}
objRs.Close();
%>
</select>
<select name="SubVocation" style="display:none">
<option value="">==请选择==</option>
</select>
</td>
</tr>
</form>自己改改SQL语句
<!--
var subcat = new Array();
<%
strSql="SELECT * FROM Vocation WHERE IfDelete='0' AND fatherid<>'0'";
objRs.Open(strSql,objConn,adOpenStatic,adLockReadOnly,1);
if(!objRs.Eof){
i=0;
while (i < objRs.RecordCount) {
Response.Write("subcat["+i+"] = new Array('"+objRs("fatherid")+"','"+objRs("VocationName")+"','"+objRs("VocationId")+"')\n");
i++;
objRs.MoveNext();
}
}
objRs.Close();strSql="SELECT DISTINCT(fatherid) AS VocationId,'' AS Style FROM Vocation WHERE IfDelete='0' AND fatherid<>'0' Union SELECT VocationId,'none' AS Style FROM Vocation WHERE IfDelete='0' AND fatherid='0' AND VocationId NOT IN (SELECT DISTINCT(fatherid) FROM Vocation WHERE IfDelete='0' AND fatherid<>'0')";
objRs.Open(strSql,objConn,adOpenStatic,adLockReadOnly,1);
var style="";
while (!objRs.Eof){
style+="if (locationid == "+objRs("VocationId").value+"){\n";
style+=" document.form1.SubVocation.style.display=\""+objRs("Style").value+"\";\n";
style+="}\n";
objRs.MoveNext();
}
objRs.Close();
%>
function changeselect1(locationid){
<%=style%>
document.form1.SubVocation.length = 0;
document.form1.SubVocation.options[0] = new Option('==请选择==','');
for (i=0; i<subcat.length; i++){
if (subcat[i][0] == locationid){
document.form1.SubVocation.options[document.form1.SubVocation.length] = new Option(subcat[i][1], subcat[i][2]);
}document.form1.SubVocation.style.display="";
}
}
//-->
</script>
<%
%>
<form name="form1" method="post" action="PropertySet.asp" onSubmit="return sub();">
<tr bgcolor="#FFFFFF">
<td width="20%">选择行业业态</td>
<td width="80%">
<select name="Vocation" onChange="changeselect1(this.value)">
<option value="">==请选择==</option>
<%
strSql="SELECT * FROM NQR_Vocation WHERE IfDelete='0' AND fatherid='0'";
objRs.Open(strSql,objConn,adOpenStatic,adLockReadOnly,1);
while (!objRs.Eof){
Response.Write ("<option value=\""+objRs("VocationId").Value+"\">"+objRs("VocationName").Value+"</option>");
objRs.MoveNext();
}
objRs.Close();
%>
</select>
<select name="SubVocation" style="display:none">
<option value="">==请选择==</option>
</select>
</td>
</tr>
</form>自己改改SQL语句
解决方案 »
- 执行session_start()网站很长时间没有反应
- 关于apache+PHP问题
- mysql导入问题?报ERROR
- 【求助大虾】问一下php的mysql_pconnect()函数
- 匹配括号里的内容为什么要写成${0}
- php5 使用soap,WSDL怎么解决啊??
- smarty 中数组循环嵌套调不是报错就是不显示
- The session id contains illegal characters, valid characters are a-z, A-Z, 0-9 and '-,'
- 把一大篇文章写入数据库后读出来发现部分文字有乱码
- 新手求救!
- 如何伪造PHPINFO信息
- 怎么判断数据库中是否存在某个表
建议你好好研究一下.
我在搜索