想知以下代码是什么意思!

来源:百度知道 编辑:UC知道 时间:2024/06/07 08:04:48
<%dim dingdan
dingdan=request.QueryString("dan")
set rs=server.CreateObject("adodb.recordset")
rs.open "select shop_AA.shopid,shop_AA.shopname,shop_AA.shichangjia,shop_AA.huiyuanjia,shop_BB.actiondate,shop_BB.shousex,shop_BB.danjia,shop_BB.feiyong,shop_BB.fapiao,shop_BB.quyu,shop_BB.baojia,shop_BB.userzhenshiname,shop_BB.shouhuoname,shop_BB.dingdan,shop_BB.youbian,shop_BB.liuyan,shop_BB.zhifufangshi,shop_BB.songhuofangshi,shop_BB.zhifufangshi,shop_BB.songhuofangshi,shop_BB.zhuangtai,shop_BB.zonger,shop_BB.useremail,shop_BB.usertel,shop_BB.shouhuodizhi,shop_BB.shopcount from shop_AA inner join shop_BB on shop_AA.shopid=shop_BB.shopid where shop_BB.username='"&request.Cookies("snsn")("username")&"' and dingdan='"&dingdan&"' ",conn,1,1
if rs.eof and rs.bof then
response.write "<center>此订单中有商品已被管理员删除,无法进行正确计算。<br>订单取消,请通知管理员或重新下订单!</center>"
res

inner join
http://www.8esky.com/handbook/jetSQl/dasqlinnerjoin.htm

request.Cookies("snsn")("username")应该是输入的用户名

计算的