ASP中SQL命令求一字段总和
<%
Set Conn=Server.CreateObject( "ADODB.Connection ")
Connstr= "DBQ= "+server.mappath( "jdgl.mdb ")+ ";DRIVER={Microsoft Access Driver (*.mdb)}; "
Conn.Open connstr
Set Rs = Server.CreateObject( "ADODB.RecordSet ")
dj=SELECT Sum(dj) FROM jdgl
rs.Open dj,conn,0,1
Response.Write(dj)
%>
上面变量定义有没有错
dj=SELECT Sum(dj) FROM jdgl 这里什么地方错了
在线等 谢谢
[解决办法]
set rs=server.createObject( "adodb.RecordSet ")
rsStr= "select sum(dj) from test "
rs.open rsStr,conn,1,1
Response.Write(rs(0))
rs.close
set rs=nothing
[解决办法]
dj= "SELECT Sum(dj) as sumdj FROM jdgl "
rs.Open dj,conn,1,1
Response.Write(rs( "sumdj "))
