<%
countSum = "0"
priceSum = "0.00"
set GetShop = server.CreateObject("adodb.recordset")
sql = "select sum(C_goodscount) as countSum,sum(C_goodscount*C_price) as priceSum from web_cart where C_cartId='"&session("shoppingCart")&"'"
'response.Write sql
'response.End()
GetShop.open sql,conn,1,1
if not GetShop.eof and GetShop("countSum")<>"" and GetShop("priceSum")<>"" then
countSum = GetShop("countSum")
priceSum = GetShop("priceSum")
end if
GetShop.close
set GetShop = nothing
%>