Question

ASP 怎样获得所查寻的记录的总数

set aa=server.createobject("adodb.recordset")
tm=(Request.Form("select"))

if tm="全部题目"or tm="模拟考试" then
ss="select * from question "
else
ss="select * from question where subjectname='"&tm&"'"
end if
aa.open ss,conn,1,1

response.write("记录总数:")
response.write("记录总数:")

有多少条记录

Answer 1

set aa=server.createobject("adodb.recordset")
tm=(Request.Form("select"))

if tm="全部题目"or tm="模拟考试" then
ss="select * from question "
else
ss="select * from question where subjectname='"&tm&"'"
end if
aa.open ss,conn,1,1

AllNum=rs.recordcount '取得总数量
response.write("记录总数:"&tm&"")

Answer 2

Select Count(ID) from quest “ID”是一个字段，用Count这个命令来得到记录总数

Answer 3

response.write("记录总数:" & aa.recordcount )

Answer 4

<%=rs.recordcount%>