TOMMYHU

错误信息如：


错误SQL：

SELECT ClassID,ClassName,ParentID,ParentPath,Depth,RootID,Child,PrevID,NextID,OrderID,(select top 1 ClassID from [LZ8_Class] b where b.ParentID=a.ClassID And ChannelID = 3 ORDER BY RootID,OrderID desc) AS EndCata,ClassType,LinkUrl,OpenTarget FROM [LZ8_Class] a Where ChannelID = 3 ORDER BY RootID asc,OrderID asc

子查询只能返回一条记录


出错原因：

栏目分类排序乱掉


解决办法：

inc/lz8_class.asp，行1651修改为如下：

       sql_d="SELECT ClassID,ClassName,ParentID,ParentPath,Depth,RootID,Child,PrevID,NextID,OrderID,(select top 1 ClassID from [LZ8_Class] b where b.ParentID=a.ClassID And ChannelID = "& Rs("ChannelID") &" ORDER BY RootID,OrderID,classid desc) AS EndCata,ClassType,LinkUrl,OpenTarget FROM [LZ8_Class] a Where ChannelID = "& Rs("ChannelID") &" ORDER BY RootID asc,OrderID asc"