| RecordCount is -1 problem in Oracle [message #373330] |
Wed, 11 April 2001 12:50 |
Harry
Messages: 17
Registered: March 2001
|
Junior Member |
|
|
Hi~ I would like to know why I couldn't use RecordCount and PageCount function in Oracle??
I try to use a very simple ASP to write out the RecordCount, the result in Oracle is -1 always but I can test this in ACCESS that the result is right. How come?? Is that the Oracle doesn't support RecordCount?? Thanks for your help~
My Example:
set conn = server.createobject("ADODB.Connection")
conn.Open "DSN=Test;UID=system;PWD=manager"
dim rs
Set rs = Server.CreateObject("ADODB.Recordset")
sql = "select * from test.test"
rs.Open sql, Conn, adOpenStatic, adLockReadOnly, adCmdText
Response.write rs.RecordCount
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
