select count(*) from yourtable
...
response.write(rs(0))
-
select * from yourtable
...
response.write(rs.recordcount)
...
response.write(rs(0))
-
select * from yourtable
...
response.write(rs.recordcount)
调试欢乐多
select count(*) from yourtable返回一个int型的,返回表中的记录条数
select sum(1) from 表名
rs.getString(1)就可以取出来
select count(id) from table//对数据表里的记录数进行统计(我想你的意思应该是这个)