这是subtree.asp的代码
<% dim conn,rs,s,cls,href
dim nodeid
nodeid=request.querystring("id")
set conn = Server.CreateObject("ADODB.Connection")
conn.Open "driver={SQL Server};server=192.168.0.4;uid=sa;pwd=;database=qas"
set rs = Server.CreateObject("ADODB.Recordset")
rs.Open "select *,(select count(*) from deeptree where parentid = T.id) as children from deeptree T where parentid='"&nodeid&"' and id<>'"&(nodeid)&"' ",conn,1,3
'以些文件来测试程序
Set fso = CreateObject("Scripting.FileSystemObject")
Set f1 = fso.CreateTextFile("c:\13.txt", True)
' 写入一行。
f1.WriteLine "select *,(select count(*) from deeptree where parentid = T.id) as children from deeptree T where parentid='"&nodeid&"' and id<>'"&(nodeid)&"' "
dim node_html
node_html="<table id='t"&nodeid&"' border='0' style='position:relative;left:18' cellspacing='0' cellpadding='0'>"
do while not rs.eof
if rs("id")<>rs("parentid") then
if rs("children")=0 then
s="."
cls="dirNode"
else
s="+"
cls="dirclose"
end if
end if
'修改expand部分加上两个双引号。。
node_html=node_html&"<tr><td id='node"&rs("id")&"' class='td_node'><span class='"&cls&"' id='dir"&rs("id")&"' onclick='expand("""&rs("id")&""")'>"&s&"</span><span class='node' id='s"&rs("id")&"' onclick='expand("""&rs("id")&""")' title='"&rs("content")&"' href='"&rs("link")&"'>"&rs("content")&"</span></td></tr>"
if rs("children")>0 then
node_html=node_html&"<tr id='load_"&rs("id")&"' style='display:none'><td class='td_node'><table border='0' cellspacing='0' cellpadding='0' style='position:relative;left:18;top:0'><tr><td class='td_node'><span class='dirNode'>.</span><span class='load'>Loading..s.</span></td></tr></table></td></tr>"
end if
rs.movenext
loop
node_html=node_html&"</table>"
f1.WriteLine node_html
set rs=nothing
set rs = Server.CreateObject("ADODB.Recordset")
rs.open "select link from deeptree where id='"&nodeid&"'",conn,1,3
%>
<script>
if(parent.document.getElementById("load_"+"<%=nodeid%>")){
parent.document.getElementById("load_"+"<%=nodeid%>").style.display="none"
parent.document.getElementById("node"+"<%=nodeid%>").innerHTML+="<%=node_html%>"
}
</script>
<%