| <%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>统计</title>
</head>
<!--本文所有信息都是由http://www.isee5.com Isee5音乐网提供-->
<body>
<%
Dim objConn,objRS
Set objRS = objConn.Execute("SELECT Sum(number) FROM table1") 'number是要统计的字段名, table1是表名， sum()是求和
Response.Write objRS(0) '输出统计后的数字
Set objRS = Nothing
objConn.Close
Set objConn = Nothing
%>
</body>
</html> |
