关于表中记录数量的统计,怎么返回了负值 谢谢 搞定 给 50分! 谢谢!

[zhuowei]

我一个real表,其中会有用户的User_sort这个字段的值等于2
我现在就是要统计这个总数
我是这样写的 结果返回的是负1 郁闷````

代码```
set Ps = server.CreateObject("adodb.recordset")
sql3 = "select * from LeadBBS_real where User_sort = 2"
Ps.open sql3,Con,1,3
response.Write("<br><br>目前通过第二种方式认证的老用户一共有<font color = red >"&Ps.recordcount&"</font>位")
Ps.close
SET Ps = nothing

[zy51]

"select count(*) from leadbbs_real where user_sort=2"

[shine2000]

sql3 = "select count(user_sort) from real where user_sort = '2'"

[zhuowei]

怎么搞的
换成楼上二位也不行 还是一样的返回错误
不可能啊? 什么原因呢```

[xiaoyao888]

Ps.open sql3,Con,1,3后面加
Ps.movenext

[zhuowei]

select count(*) as n from LeadBBS_real where User_sort = 2

ps("n")

我用了存储过程的语句之后才搞定!

谢谢楼上几位!

[hnfz123]

sql3="select count(*) as n from LeadBBS_real where User_sort = '2'"
ps.open sql3,con,1,1

response.write Ps.recordcount

[happyczp]

我想取出就在今天三个表里的发布信息总数，这样写有什么不对么？请高手指点。
<!--#include file="chk1.asp"-->
<!--#include file="conn.asp"-->

<%
date1=now()
sql = "SELECT * FROM chuzu order by id desc"
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,1,3
date2=rs("time")
cha1=DateDiff("d",date2,date1)
%>
<%
sql1 = "SELECT * FROM qiuzu order by id desc"
set rs1=server.createobject("adodb.recordset")
rs1.open sql1,conn,1,3
date3=rs1("time")
cha2=DateDiff("d",date3,date1)
%>
<%
sql2 = "SELECT * FROM hezu order by id desc"
set rs2=server.createobject("adodb.recordset")
rs2.open sql2,conn,1,3
date4=rs2("time")
cha3=DateDiff("d",date4,date1)
%>
'以上是先从数据库中把当日发布的三个表（出租，求租，合租)里信息先准备好,接下来取数.
<%
sqla = "SELECT * FROM chuzu where cha1<=1"
set rsa=server.createobject("adodb.recordset")
rsa.open sqla,conn,1,3
count1=rsa.recordcount
%>
<%
sqlb = "SELECT * FROM qiuzu where cha2<=1"
set rsb=server.createobject("adodb.recordset")
rsb.open sqlb,conn,1,3
count2=rsb.recordcount
%>
<%
sqlc = "SELECT * FROM hezu where cha3<=1"
set rsc=server.createobject("adodb.recordset")
rsc.open sqlc,conn,1,3
count3=rsc.recordcount
%>
<%
countall=count1+count2
countall=countall+count3
response.Write("<br/><br/>今天发布的三个表里的总信息数一共有<font color = red >"&countall&"</font>位")
%>