急请高手:为什么我查询后rs.recordcount返回的总是-1呢?

[cnbill]

我把access转成oracle后,所有从数据库查询数据后rs.recordcount返回的都是-1,百思不得其解!
sql="select * from tbl_titles order by id desc"
set rs=server.CreateObject("adodb.recordset")
rs.Open sql,conn,3,3

查询到的记录都可以正常显示出来,但rs.recordcount的值却总是-1

[zc2cm]

<%
pgnm=rs1.pagecount
if page="" or clng(page)<0 Then
page=1
Else
if clng(page)>pgnm Then
response.write"<SCRIPT language=JavaScript>alert('请注意，页数超出范围！');"
response.Write"</SCRIPT>"
page=pgnm
End if
if pgnm>0 then
rs1.absolutepage=page
End if
End if
%>

[777dragon]

CursorType = adOpenStatic

[iwillsw]

是不是CursorType = adOpenStatic，rs.recordcount才能得到值？

[蒋健华]

http://blog.csdn.net/qunluo/archive/2004/07/21/47617.aspx

[antiking]

rs.Open sql,conn,1,1
response.write(rs.recordcount)看看是什么？？

[cnbill]

TO: 回复人： antiking(anyuting):
rs.Open sql,conn,1,1
response.write(rs.recordcount)看看是什么？？
##得到的还是-1

TO: 777dragon(风林火山)
执行CursorType = adOpenStatic 后也还是-1

TO: 蒋健华(xxrl.mblogger.cn) , 你提供的文章不错,还正在看:)

谢谢各位了!

[QQgenie]

<%
sql="select * from tbl_titles order by id desc"
set rs=conn.execute(sql)

aResults = rs.GetRows '//取得数据集，加快以后操作

rs.close '//关闭
set rs=nothing '//释放

iRows = UBound(aResults, 2) '//记录数=iRows+1 '//最好用了
icols = UBound(aResults, 1) '//字段数
%>
<%'//显示----全出来了
response.write "<table width='95%'>"
for i=0 to iRows
response.write "<tr>"
for j=0 to iCols
response.write "<td>"&aResults(j,i)&"</td>" '//以字符方式读出
next
response.write "</tr>"
next
response.write "</table>"
response.write "共有记录："&(iRows+1)&"条"
%>

[ltayo]

试试
sql="select * from tbl_titles order by id desc"
set rs=server.CreateObject("adodb.recordset")
rs.Open sql,conn,1,3

[hellobcb]

rs.CursorLocation = adUseClient

[QQgenie]

rs.open sql,conn,1,1 '-----------应该可以的,测试环境:iis5,MADC2.8,ORA9i