建标签

 select top {$Param(0)} ID,Tid,Price,Title,Adddate from KS_Product where Tid = '{$CurrClassID}' and ID not in (select top {$Param(1)} ID from KS_Product where Tid = '{$CurrClassID}' order by Adddate desc ) order by Adddate desc

调用 {SQL_推荐NO2_10(9,1)}

前台效果是空白的

在线查询 select top 9 ID,Tid,Title,Adddate from KS_Product where Tid = '20086546818948' and ID not in (select top 1 ID from KS_Product where Tid = '20086546818948' order by Adddate desc ) order by Adddate desc

无内容

查询 select top 1 ID from KS_Product where Tid = '20086546818948' order by Adddate desc

结果该栏目下所有新闻ID都出来了

问题可能就出在这儿 但我不知道怎么弄 ？？？？？

 select top {$Param(0)} ID,Tid,Price,Title,Adddate from KS_Product where Tid = '{$CurrClassID}' and ID not in (select top {$Param(1)} ID from KS_Product where Tid = '{$CurrClassID}' order by Adddate desc ) order by Adddate desc

你这语句本身就有问题,栏目ID要等于当前栏目,又要满足产品ID不在当前栏目里的产品ID,自相矛盾

我是按照官方的教程改的啊http://www.kesion.com/tech/jc/175.html


--  作者：一生有你
--