Question

ASP ACCESS 怎么求和

set rs=server.CreateObject("adodb.recordset")
sql="select sum(jiage) from db1 where a_id in(select b_id from db2 )"
conn.execute sql

Response.write "alert('价格是')" & VbCrlf
Response.end

%>
怎么把 sum(jiage)用 Response.write "alert('价格是')" 输出来了

Answer 1

方法一：
Dim TotalNum
set rs=server.CreateObject("adodb.recordset")
sql="select sum(jiage) from db1 where a_id in(select b_id from db2 )"
conn.execute sql
TotalNum=rs(0)
Response.write("<script>alert('价格是:"& TotalNum &"');</script>")
Response.end

方法二：
set rs=server.CreateObject("adodb.recordset")
sql="select sum(jiage) as TotalNum from db1 where a_id in(select b_id from db2 )"
conn.execute sql
Response.write("<script>alert('价格是:"& rs("TotalNum") &"');</script>")
Response.end

Answer 2

set rs=server.CreateObject("adodb.recordset")
sql="select sum(jiage) from db1 where a_id in(select b_id from db2 )"
rs.Open sql,conn,1,1
Response.write "<script type='text/javascript'>alert('价格是"&rs(0)&"')</script>"
Response.end

Answer 3

用 Response.write "alert('价格是')" 输出
答案：Response.write("<script>alert('价格是:');</script>")
Response.end

Answer 4

求和?sum?实在回答不起 但是我这么努力回来 给我几分吧