账号通
    

账号  

密码  

2194

查看

1

回复
主题:KesionEshop V9.0x 订单查询(shop/myorder.asp)无法查询团购订单的修正。 [收藏主题]  
科汛官方 当前离线

47268

主题

145

广播

405

粉丝
添加关注
级别:管理员

用户积分:101604 分
登录次数:7935 次
注册时间:2006/12/7
最后登录:2023/12/14
科汛官方 发表于:2013/5/13 11:04:08   | 显示全部帖子 查看该作者主题 楼主 
做在线知识付费 选科汛云开店

出错提示:


错误 '80020009'

/shop/myorder.asp,行 274


解决方法:


打开 shop/myorder.asp 找到 274 行,如下代码


  OrderDetailStr=OrderDetailStr & "    <td width='*'><a href='" & KS.Setting(3) & "item/show.asp?m=5&d=" & RSi("proid") & "' target='_blank'>" & Conn.execute("select top 1 title from ks_product where id=" & rsi("proid"))(0)


修改为:


If rs("OrderType")=1 Then
  OrderDetailStr=OrderDetailStr & "    <td width='*'><a href='" & KS.Setting(3) & "shop/groupbuyshow.asp?id=" & RSi("proid") & "' target='_blank'>" & Conn.execute("select top 1 subject from ks_groupbuy where id=" & rsi("proid"))(0)
  Else  
  OrderDetailStr=OrderDetailStr & "    <td width='*'><a href='" & KS.Setting(3) & "item/show.asp?m=5&d=" & RSi("proid") & "' target='_blank'>" & Conn.execute("select top 1 title from ks_product where id=" & rsi("proid"))(0)
  End If




再往下找到306行左右,如下代码:

  OrderDetailStr=OrderDetailStr & "    <td width='45' align=center>"& Conn.execute("select unit from ks_product where id=" & rsi("proid"))(0) & "</td>               <td width='55' align='center'>" & rsi("amount") &"</td>    "

修改为

  If RS("OrderType")="1" Then
  OrderDetailStr=OrderDetailStr & "    <td width='45' align=center>件</td>"
  Else
  OrderDetailStr=OrderDetailStr & "    <td width='45' align=center>"& Conn.execute("select unit from ks_product where id=" & rsi("proid"))(0) & "</td>"
     End If
  OrderDetailStr=OrderDetailStr & "<td width='55' align='center'>" & rsi("amount") &"</td>"

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