RS.RecordCount always returns -1

[jl]

Hello,
I am trying to determine if a recordset is empty or not, and if
it is empty print out a message saying no records found. I thought
I could use rs.RecordCount but it always seems to return -1 no
matter if there are records in the rs or not. Does anyone have
any ideas as to why this doesn't work and how to get it to work.
Thanks in advance. The code is below.
Joe

Const adOpenStatic = 3
Const adLockReadOnly = 1
Dim frmFileType, frmCategory, frmEvent, frmUser, objConn2, objRS5
Dim tmpsql5, strSQL5
frmFileType = request.form("fileType")
frmCategory = request.form("category")
frmEvent = request.form("theevent")
frmUser = request.form("theUser")
if frmUser = "ALL" then
userPart = ""
Else
userPart = "And user_id = " & frmUser
End if
tmpsql5 = "Select * from table where type_id = " & frmFileType & " AND
category_id = " & frmCategory & " AND event_id = " & frmEvent &
userPart
strSQL5 = tmpsql5
Set objConn2=Server.CreateObject("ADODB.Connection")
Set objRS5=Server.CreateObject("ADODB.Recordset")
objConn2.Open strConnect
objRS5.Open strSQL5, objConn2, adOpenStatic, adLockReadOnly
i=objRS5.RecordCount
response.write("The number of records is: " & i)

[Curt_C [MVP]]

jl wrote:

Hello,
I am trying to determine if a recordset is empty or not, and if
it is empty print out a message saying no records found. I thought
I could use rs.RecordCount but it always seems to return -1 no
matter if there are records in the rs or not. Does anyone have
any ideas as to why this doesn't work and how to get it to work.
Thanks in advance. The code is below.
Joe

Perhaps...
http://www.aspfaq.com/show.asp?id=2193

--
Curt Christianson
site: http://www.darkfalz.com
blog: http://blog.darkfalz.com

[Dave Anderson]

Curt_C [MVP] wrote:

I am trying to determine if a recordset is empty or not,
and if it is empty print out a message saying no records
found. I thought I could use rs.RecordCount...

http://www.aspfaq.com/show.asp?id=2193

While this article addresses the RecordCount problem, it seems like an
over-engineered solution to the simple problem of determining if there are
any results present.

Given the question and the code sample provided by the OP, shouldn't it
suffice for him to examine objRS5.EOF?

--
Dave Anderson

Unsolicited commercial email will be read at a cost of $500 per message. Use
of this email address implies consent to these terms. Please do not contact
me directly or ask me to contact you directly for assistance. If your
question is worth asking, it's worth posting.

[Aaron Bertrand [SQL Server MVP]]

> I am trying to determine if a recordset is empty or not, and if

it is empty print out a message saying no records found. I thought
I could use rs.RecordCount

Why not use the EOF property?

set rs = conn.execute(sql)
if rs.eof then
Response.Write "no results"
else
...
end if

[jl]

Hello,
EOF is what I ended up using.
Thanks for all of your suggestions.
Joe