问题如题

解决方法：打开shop/limitbuy.asp

Loop
  RS.Close
  
  '==========================================================================================================
        '抢购结束的商品恢复状态
   conn.execute("update ks_product set islimitbuy=0 where LimitBuyTaskID in(select id from KS_ShopLimitBuy where datediff(" & DataPart_S &",LimitBuyEndTime," & SqlNowString&")>0)")
   

        SqlStr = "SELECT  top " & Num & " I.ID,I.Title,I.Fname,i.photourl,I.Tid,I.Price,I.Price_member,i.unit,I.IsLimitbuy,I.LimitBuyPrice,I.LimitBuyAmount,I.Unit,L.LimitBuyBeginTime,L.LimitBuyEndTime,L.TaskType FROM KS_Product I Inner Join KS_ShopLimitBuy L ON I.LimitBuyTaskID=L.id Where L.Status=1"
  If Id<>0 Then SqlStr=SqlStr & " and L.id=" & ID Else SqlStr=SqlStr & " order by l.id desc"
        RS.Open SqlStr, conn, 1, 1

增加上面红色的代码即可。