账号通
    

账号  

密码  

3930

查看

8

回复
主题:v6多模型文章关联临时解决方案~ [收藏主题] 本贴被认定为精华 转到:  
ha300400 当前离线

484

主题

3

广播

1

粉丝
添加关注
级别:四年级

用户积分:10644 分
登录次数:357 次
注册时间:2009/5/14
最后登录:2023/12/7
ha300400 发表于:2012/8/27 12:16:43   | 显示全部帖子 查看该作者主题 楼主 
科汛智能建站系统
以下是引用 jikeyshi在2009-10-8 14:38:00的发言:

Kesion.Label.FunctionCls.asp  190行左右:





If ModelID<>"0" Then

      Param = " Inner Join KS_ItemInfoR R On I.ID=R.RelativeID Where I.Verific=1 And I.DelTF=0 And R.InfoID=" & FCls.RefreshInfoID & " And R.RelativeChannelID=" & ModelID

    Else

      Param = " Inner Join KS_ItemInfoR R On I.InfoID=R.RelativeID Where I.Verific=1 And I.DelTF=0 And R.InfoID=" & FCls.RefreshInfoID



改为:

If ModelID<>"0" Then

      Param = " Inner Join KS_ItemInfoR R On I.ID=R.RelativeID Where I.Verific=1 And I.DelTF=0 And R.InfoID=" & FCls.RefreshInfoID & " And R.RelativeChannelID=" & ModelID &" and R.RelativeChannelID=I.ChannelID"

    Else

      Param = " Inner Join KS_ItemInfoR R On I.InfoID=R.RelativeID Where I.Verific=1 And I.DelTF=0 And R.InfoID=" & FCls.RefreshInfoID &" and R.RelativeChannelID=I.ChannelID"





Kesion.AdministratorCls.asp  817 行左右



SQLStr="Select TOP 200 I.ChannelID,I.InfoID,I.Title From KS_ItemInfo I Inner Join KS_ItemInfoR R On I.InfoID=R.RelativeID Where R.ChannelID=" & ChannelID &"  and R.InfoID=" & ID



改为:



SQLStr="Select TOP 200 I.ChannelID,I.InfoID,I.Title From KS_ItemInfo I Inner Join KS_ItemInfoR R On I.InfoID=R.RelativeID Where R.ChannelID=" & ChannelID &"  and R.InfoID=" & ID &" and R.RelativeChannelID=I.ChannelID"

 
  支持(0) | 反对(0) 回到顶部顶端 回到底部底部
<上一主题 | 下一主题 >
Powered By KesionCMS Version X1
厦门科汛软件有限公司 © 2006-2016 页面执行0.06494秒 powered by KesionCMS 9.0