问题描述
- 用以下代码实现的三级联动下拉菜单[调用数据库数据],没有显示菜单内容,帮我看看是哪里出问题了?谢谢!
-
三个表:
P_BigClass(字段:BigClassID,BigClassName,descid),
P_SmallClass(字段:SmallClassID,BigClassName,SmallClassName,descid),
P_Sales(字段:SalesID,SmallClassName,SalesName,descid)
var arrSel=["BigClassName","SmallClassName","SalesName"];//arrSel定义了要修改的下拉框和xml数据的节点名称
<%
do while not rsP_BigClass.eof
%>
">
<%
set rsP_SmallClass=server.CreateObject("adodb.recordset")
rsP_SmallClass.open "Select * From P_SmallClass Where BigClassName='" & rsP_BigClass("BigClassName") & "' order by descid",conn,1,3
if not(rsP_SmallClass.bof and rsP_SmallClass.eof) then
do while not rsP_SmallClass.eof
%>
">
<%
set rsP_Sales=server.CreateObject("adodb.recordset")
rsP_Sales.open "Select * From P_Sales Where smallClassName='" & rsP_SmallClass("smallClassName") & "' order by descid",conn,1,3
if not(rsP_Sales.bof and rsP_Sales.eof) then
do while not rsP_Sales.eof
%>
"><%
rsP_Sales.movenext
loop%>
<%else%><%
end if
rsP_Sales.close
set rsP_Sales=nothing
%><%
rsP_SmallClass.movenext
loop
end if
rsP_SmallClass.close
set rsP_SmallClass=nothing
%><%
rsP_BigClass.movenext
loop
%>
解决方案
asp么?代码问题很多,比如说sql查询,字符串没有带引号
也没有在下拉改变的时候调用onchange