ASP下拉菜单----事件

来源：百度知道 编辑：UC知道 时间：2024/05/30 21:13:33
大体的意思是：我分类有2级分类。我想选择大类的时候。onChange 触发一个事件，大类相应的小类就自动显示。数据库：大类跟小类在一个表里面。我下面还有一个文本域。（数据库：文本域跟类别不在一个表里了。）在选择了相应的小类后，直接把数据那小类的数据提下面的文本域里面！求高手给个完整的代码看下！谢谢了！在线等待！

这个要自调本页面来实现.
给你段代码参考:
asp部分主要内容:
sysmd = request("sysmd")
submd = request("submd")
cmd_where_2 = ""
cmd_where_3 = ""

sql1 = "select distinct left(FormID,2) as sysmd from "& cstsales & "Formreg"

sql2 = "select distinct (case len(FormID) when 6 then substring(FormID,3,1) when 7 then substring(FormID,3,2) when 8 then substring(FormID,3,2) end) as submd from "& cstsales & "Formreg"

sql3 = "select distinct FormID,FormName from "& cstsales & "Formreg"

if sysmd = "" and submd = "" then
cmd_where_2 = " where left(FormID,2) = '" & sysmd & "'"
sql2 = sql2 & cmd_where_2
elseif sysmd <> "" and submd = "" then
cmd_where_2 = " where left(FormID,2) = '" & sysmd & "'"
sql2 = sql2 &