asp.跳转搜索功能问题!!!!!!!!!!!

来源:百度知道 编辑:UC知道 时间:2024/06/27 10:30:04
(1)这是从数据库读取分类显示的下拉菜单.(可能写法错误)
@@@@@@
<form method="post" name="form1">
<select name="leibie" >
<%
sql = "SELECT * FROM class where parentid = 0 order by classid asc"
Set rs = Server.CreateObject("ADODB.Recordset")
rs.OPEN sql,Conn,1,1
if rs.eof and rs.bof then
Response.Write"<option>还没有任何分类</option>"
else
do while not rs.eof
Response.Write"<option value='"&rs("classid")&"'"
if classid = rs("classid") then response.Write " selected "
response.Write ">"&rs("c_name")&"</option>"& vbcrlf
if rs("children")<>0 then
set rs2 = server.CreateObject("Adodb.Recordset")
sql2="select * from class where parentid = "& rs("classid&q

***************************************************
用递归法。
ASP演示:递归无限级分类(下拉菜单)
http://www.hngczy.cn/pgb/zhidaoanswer/digui/digui.asp
***************************************************