刚才下载新的完整版看过了 同样少个and 补丁里ks.special.asp也是少and

感到这个SQL这样写更好些

SQLStr="Select R.ID,I.ChannelID,I.InfoID,I.Title,I.Tid,I.AddDate From KS_SpecialR R Inner Join KS_ItemInfo I On R.InfoID=I.InfoID and R.ChannelID=I.ChannelID  Where R.SpecialID=" & SpecialID & " Order by R.ID Desc"