大家帮我看一下这段代码,为什么节点装得顺序不对 将整个页面代码都拿出来吧,我们好帮你调 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 瀛樺偍杩囩▼CREATE PROC sp_ListFile(@Child_node int) As SET NOCOUNT ON --declare var DECLARE @lvl smallint --灞傛鍏崇郴 DECLARE @c_ID int DECLARE @article bit --鏄惁涓烘枃绔犵殑鏍囧織 DECLARE @title varchar(150) --鏍囬 --create temporary table CREATE TABLE #stack (Child_node int,Lvl smallint) --create target table CREATE TABLE #FileList (lvl smallint, Child_node_ID int, Article bit, Title varchar(150) ) --initial INSERT INTO #stack VALUES(@Child_node,0) SELECT @Lvl = 0 --main loop WHILE @Lvl > -1 BEGIN IF EXISTS(SELECT * FROM #stack WHERE Lvl = @Lvl) BEGIN SELECT @Child_node = Child_node FROM #stack WHERE Lvl = @Lvl SELECT @article = article,@title = title FROM some_table WHERE Child_node = @Child_node INSERT INTO #FileList VALUES(@Lvl,@Child_node, @article,@title) DELETE FROM #stack WHERE Lvl = @Lvl AND Child_node = @Child_node INSERT INTO #stack SELECT Child_node,@Lvl + 1 FROM some_table WHERE Parent_node = @Child_node IF @@ROWCOUNT > 0 SELECT @Lvl = @Lvl + 1 END ELSE SELECT @Lvl = @Lvl - 1 END DELETE FROM #FileList WHERE Lvl = 0 SELECT * FROM #FileList 杈撳嚭缁撴灉锛?lvl Child_node Article Title 1 1 0 Program 2 2 0 Visual Basic 3 5 1 ADO Control 2 3 0 Power Builder 2 4 0 C++ Builder 鐪嬩笅鍒椾唬鐮侊細Dim GetRSStringDim cnnDim rsDim l_IDl_ID = "1" '琛ㄧず鏍硅妭鐐?Set cnn = Server.CreateObject("ADODB.Connection")Set rs = Server.CreateObject("ADODB.RecordSet")cnn.Open "Provider=SQLOLEDB;.......................鐣?rs.Open "sp_listfile " & l_ID,cnnGetRSString = rs.GetString(2,,"?quot;","~~") 'adClipStringrs.CloseSet rs = Nothingcnn.CloseSet cnn = NothingResponse.Write "<FORM id='rs' name='rs'>" &_"<INPUT type='hidden' id='rsCache' name='rsCache' value='" & GetRSString & "'></FORM>" &_"<SCRIPT language=JavaScript src='Listfile.js'></SCRIPT>" &_"<Script language=Javascript>LoadRecords(" + l_ID + ");</Script>"鍦ㄤ笂闈㈢殑浠g爜涓紝鐢?GetString 鐨勬柟娉曞緱鍒颁簡浠??quot;鍜寏~ 鍒嗛殧鐨勫瓧绗︿覆锛屽苟鐢ㄩ殣钘忚〃鍗曡繘琛屽瓨鍌ㄣ€?Listfile.js 閲岀殑鑴氭湰瀹炵幇浜嗘垜浠兂瑕佸緱鍔熻兘锛孡oadRecords 鏄叾涓殑涓€涓嚱鏁般€?2. Listfile.js 涓殑鑴氭湰杩欐槸鍏ㄩ儴浠g爜锛?function ToggleDisplay(oButton, oItems){if ((oItems.style.display == "") || (oItems.style.display == "none")){oItems.style.display = "block";oButton.src = book_open.src;} else{oItems.style.display = "none";oButton.src = book_close.src;}}function LoadRecords(l_ID) {var strRecords=document.all("rsCache").value;var arrRecords=strRecords.split("~~");var arrFields;var Current_level;var Current_ID;var strTemp;var strList;var Prior_ID;var Prior_level=-1;var i;var j;Prior_ID=l_ID;strList = "<TABLE><TR><TD height=300 valign=top class=Newscontents><!--" + l_ID + "-->";for (i=0;i<arrRecords.length;i++) {arrFields=arrRecords[i].split("?quot;");Current_level = arrFields[0];Current_ID = arrFields[1];if (arrFields[2] == 0){strTemp = "<DIV><IMG SRC='images/plus.gif' ID='i_" + Current_ID + "' onclick='ToggleDisplay(i_" + Current_ID + ",f_" + Current_ID + "_d);' width=31 height=15 style='position:relative;left:" + (Current_level*17) + ";top:3;cursor:hand;'> <A ID='f_" + Current_ID + "' style='position:relative;left:" + (Current_level*17) + ";cursor:hand;' onclick='ToggleDisplay(i_" + Current_ID + ",f_" + Current_ID + "_d);'>" + arrFields[3] + "</A></DIV><DIV ID='f_" + Current_ID + "_d' style='display: none;'><!--" + Current_ID + "--></DIV>";if (Current_level > Prior_level) {strTemp += "<!--LEVEL" + Current_level + "-->";strList = strList.replace("<!--" + Prior_ID + "-->",strTemp);}else {if (Current_level == Prior_level) {strTemp += "<!--LEVEL" + Current_level + "-->";strList = strList.replace("<!--LEVEL" + Current_level + "-->",strTemp );}else{for (j=parseInt(Current_level)+1;j<=Prior_level;j++) {strList = strList.replace("<!--LEVEL" + i + "-->","")} strTemp += "<!--LEVEL" + Current_level + "-->";strList = strList.replace("<!--LEVEL" + Current_level + "-->",strTemp );}}}else {strTemp = "<DIV><IMG SRC='images/message.gif' width=11 height=14 style='position:relative;left:" + (Current_level*17+20) + ";top:2;cursor:hand;'> ";strTemp += "<A ID='f_" + Current_ID + "' HREF='page.asp?article=" + arrFields[3] + "' TARGET=MAIN style='position:relative;left:" + (Current_level*17 +16) + ";cursor:hand;'>" + arrFields[3] + "</A></DIV><!--LEVEL" + Current_level + "-->";if (Current_level > Prior_level)strList = strList.replace("<!--" + Prior_ID + "-->",strTemp);elsestrList = strList.replace("<!--LEVEL" + Current_level + "-->",strTemp);}Prior_ID = Current_ID;Prior_level = Current_level;}strList += "</TD></TR><TR><TD height=10><img style='display:none;' " +"src='images/plus.gif' id=book_close><img style='display:none;' " +"src='images/minus.gif' id=book_open> </TD></TR></TABLE>";document.write(strList);} js效果与ajax有冲突。。。走不动 用Node.js写了一个静态文件服务器[100行,2K] js调用xml出错! js代码冲突求解! iframe刷新后并跳转页 js修改标签属性 javascript调用MSXML2的时候,系统出现提示“没有权限”。具体内详。。。。忘高手指点。 怎样在modal窗口中进行頁面转換?在線等````急!!!!!!! 怎样让一个IE窗口自动关闭而不出现是否关闭页面的提示! 一个关于table显示的问题 请问检验中文字的函数是什么? 急!!!6小时后要交!!!300分求助。(另开贴加200分)
瀛樺偍杩囩▼CREATE PROC sp_ListFile(@Child_node int) As SET NOCOUNT ON --declare var DECLARE @lvl smallint --灞傛鍏崇郴 DECLARE @c_ID int DECLARE @article bit --鏄惁涓烘枃绔犵殑鏍囧織 DECLARE @title varchar(150) --鏍囬
--create temporary table CREATE TABLE #stack (Child_node int,Lvl smallint)
--create target table CREATE TABLE #FileList
(lvl smallint,
Child_node_ID int,
Article bit,
Title varchar(150) )
--initial INSERT INTO #stack VALUES(@Child_node,0) SELECT @Lvl = 0
--main loop WHILE @Lvl > -1 BEGIN IF EXISTS(SELECT * FROM #stack WHERE Lvl = @Lvl) BEGIN SELECT @Child_node = Child_node
FROM #stack
WHERE Lvl = @Lvl SELECT @article = article,@title = title
FROM some_table
WHERE Child_node = @Child_node INSERT INTO #FileList
VALUES(@Lvl,@Child_node, @article,@title) DELETE FROM #stack
WHERE Lvl = @Lvl AND Child_node = @Child_node INSERT INTO #stack
SELECT Child_node,@Lvl + 1
FROM some_table
WHERE Parent_node = @Child_node
IF @@ROWCOUNT > 0
SELECT @Lvl = @Lvl + 1 END ELSE SELECT @Lvl = @Lvl - 1 END DELETE FROM #FileList
WHERE Lvl = 0
SELECT * FROM #FileList
杈撳嚭缁撴灉锛?lvl Child_node Article Title 1 1 0 Program 2 2 0 Visual Basic 3 5 1 ADO Control 2 3 0 Power Builder 2 4 0 C++ Builder 鐪嬩笅鍒椾唬鐮侊細Dim GetRSString
Dim cnn
Dim rs
Dim l_ID
l_ID = "1" '琛ㄧず鏍硅妭鐐?Set cnn = Server.CreateObject("ADODB.Connection")
Set rs = Server.CreateObject("ADODB.RecordSet")
cnn.Open "Provider=SQLOLEDB;.......................鐣?
rs.Open "sp_listfile " & l_ID,cnnGetRSString = rs.GetString(2,,"?quot;","~~") 'adClipString
rs.Close
Set rs = Nothing
cnn.Close
Set cnn = NothingResponse.Write "<FORM id='rs' name='rs'>" &_
"<INPUT type='hidden' id='rsCache' name='rsCache' value='" & GetRSString & "'></FORM>" &_
"<SCRIPT language=JavaScript src='Listfile.js'></SCRIPT>" &_
"<Script language=Javascript>LoadRecords(" + l_ID + ");</Script>"鍦ㄤ笂闈㈢殑浠g爜涓紝鐢?GetString 鐨勬柟娉曞緱鍒颁簡浠??quot;鍜寏~ 鍒嗛殧鐨勫瓧绗︿覆锛屽苟鐢ㄩ殣钘忚〃鍗曡繘琛屽瓨鍌ㄣ€?Listfile.js 閲岀殑鑴氭湰瀹炵幇浜嗘垜浠兂瑕佸緱鍔熻兘锛孡oadRecords 鏄叾涓殑涓€涓嚱鏁般€?2. Listfile.js 涓殑鑴氭湰杩欐槸鍏ㄩ儴浠g爜锛?function ToggleDisplay(oButton, oItems)
{
if ((oItems.style.display == "") || (oItems.style.display == "none"))
{
oItems.style.display = "block";
oButton.src = book_open.src;
}
else
{
oItems.style.display = "none";
oButton.src = book_close.src;
}
}function LoadRecords(l_ID)
{
var strRecords=document.all("rsCache").value;
var arrRecords=strRecords.split("~~");
var arrFields;
var Current_level;
var Current_ID;
var strTemp;
var strList;
var Prior_ID;
var Prior_level=-1;
var i;
var j;
Prior_ID=l_ID;
strList = "<TABLE><TR><TD height=300 valign=top class=Newscontents><!--" + l_ID + "-->";
for (i=0;i<arrRecords.length;i++)
{
arrFields=arrRecords[i].split("?quot;");
Current_level = arrFields[0];
Current_ID = arrFields[1];
if (arrFields[2] == 0)
{
strTemp = "<DIV><IMG SRC='images/plus.gif' ID='i_" + Current_ID +
"' onclick='ToggleDisplay(i_" + Current_ID + ",f_" +
Current_ID + "_d);' width=31 height=15 style='position:relative;left:" +
(Current_level*17) + ";top:3;cursor:hand;'> <A ID='f_" + Current_ID +
"' style='position:relative;left:" + (Current_level*17) +
";cursor:hand;' onclick='ToggleDisplay(i_" + Current_ID + ",f_" +
Current_ID + "_d);'>" + arrFields[3] + "</A></DIV><DIV ID='f_" +
Current_ID + "_d' style='display: none;'><!--" + Current_ID + "--></DIV>";
if (Current_level > Prior_level)
{
strTemp += "<!--LEVEL" + Current_level + "-->";
strList = strList.replace("<!--" + Prior_ID + "-->",strTemp);
}
else
{
if (Current_level == Prior_level)
{
strTemp += "<!--LEVEL" + Current_level + "-->";
strList = strList.replace("<!--LEVEL" + Current_level + "-->",strTemp );
}
else
{
for (j=parseInt(Current_level)+1;j<=Prior_level;j++)
{
strList = strList.replace("<!--LEVEL" + i + "-->","")
}
strTemp += "<!--LEVEL" + Current_level + "-->";
strList = strList.replace("<!--LEVEL" + Current_level + "-->",strTemp );
}
}
}
else
{
strTemp = "<DIV><IMG SRC='images/message.gif' width=11 height=14 style='position:relative;left:" +
(Current_level*17+20) + ";top:2;cursor:hand;'> ";
strTemp += "<A ID='f_" + Current_ID + "' HREF='page.asp?article=" + arrFields[3] +
"' TARGET=MAIN style='position:relative;left:" + (Current_level*17 +16) +
";cursor:hand;'>" + arrFields[3] + "</A></DIV><!--LEVEL" + Current_level + "-->";
if (Current_level > Prior_level)
strList = strList.replace("<!--" + Prior_ID + "-->",strTemp);
else
strList = strList.replace("<!--LEVEL" + Current_level + "-->",strTemp);
}Prior_ID = Current_ID;
Prior_level = Current_level;
}
strList += "</TD></TR><TR><TD height=10><img style='display:none;' " +
"src='images/plus.gif' id=book_close><img style='display:none;' " +
"src='images/minus.gif' id=book_open> </TD></TR></TABLE>";
document.write(strList);
}