又是这个问题,烦,难道没有人可以救救我吗?特邀孔曰成仁,孟曰成E!
还是级联表单问题.本人采用孔曰成仁,孟曰成写的三个级联方法改编,由于本人水平比较陋野,现在是还没有解决.大家帮这看一下.分数没有问题,不够再加.
代码如下:
<%set conn=Server.CreateObject("ADODB.Connection")
StrCnn = "Provider=SQLOLEDB;Server=ahui;UID=sa;PWD=;Database=enterprise"
conn.open strcnn
sql1="select * from tb_city order by cityid"
sql2="select tb_city.citycode,tb_area2.paretid,tb_area2.area2name,tb_area2.area2id from tb_area2 ,tb_city where tb_area2.paretid='"&citycode&"'"
Set rs1= Server.CreateObject("ADODB.Recordset")
rs1.open sql1,conn,1,1
Set rs2= Server.CreateObject("ADODB.Recordset")
rs2.open sql2,conn,1,1
%>
<body>
<form name=form1 style="margin:0;" method="post">
<select name=city>
<%
if rs1.RecordCount >0 then
while not rs1.eof
Response.Write"<option value="&rs1("citycode")&">"&rs1("cityname")&"</option>"
citycode=request.Form("city")
if request.form("city")=rs1("citycode") then
response.Write("selected")
end if
rs1.movenext
wend
Else
Response.Write "没有配置"
end if
%>
</select>
<select name=area2 onchange=”ChangeLocationi(form1.area2.options[form1.area2.selectedIndex].value);”>
<option value=””>-------------</option>
<%
if rs2.RecordCount<0 then
response.write "<option value="""">库中没有部门!</option>"
else
while not rs2.eof
response.write "<option value="&rs2("paretid")&">" &rs2("area2name")&"</option>"
rs2.movenext
response.Write("selected")
wend
end if
%>
</select>
</form>
<%rs1.close
set rs1 = nothing
rs2.close
set rs2 = nothing%>