asp sql语句求一个数据项的集合 - Web 开发 / ASP

我想查询数据库表 中的所有价格的总和 并赋值给一个变量 应该怎样做 

VBScript code:

<%
set rs_FriceSum=server.createobject("adodb.recordset")
sql="select * from sum(Goods_price) as [Sum] Cart where Cart.user_id="&session("user_id")&""
rs_FriceSum.open,sql,1,1

%>


<% rs_FriceSum("Frice_Sum") %>










想求个价格的和 怎么获得啊

<% rs_FriceSum("Frice_Sum") %>

---

<%
set rs_FriceSum=server.createobject("adodb.recordset")
sql="select sum(Goods_price) as [Sum] from Cart where user_id="&session("user_id")&""
rs_FriceSum.open,sql,1,1
   
%>
   

<% rs_FriceSum(0)%>

---

HTML code:
<%
sql="SELECT SUM(Goods_price) as totalamount from [Cart] where Cart.user_id="&session("user_id")
set rs=conn.execute(sql)
if not rs.eof then totalamount =rs("totalamount") else totalamount =0
set rs=nothing
conn.close: set conn=nothing
%>
总额:<%=totalamount%>