账号通
    

账号  

密码  

4353

查看

8

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

263

主题

1

广播

2

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

用户积分:2479 分
登录次数:250 次
注册时间:2007/11/24
最后登录:2015/4/16
jikeyshi 发表于:2009/10/8 14:38:00   | 显示全部帖子 查看该作者主题 楼主 
科汛在线考试系统(NET)

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.06641秒 powered by KesionCMS 9.0