Object is closed. Why?

myself · July 5th, 2006, 03:13 PM

Hi,
I get the following message:

Error Type:
ADODB.Recordset (0x800A0E78)
Operation is not allowed when the object is closed.
/TheMiddlePath/searchresults1.asp, line 16

myCount = myRS.RecordCount

I have a Select Case at the bottom:

Code:

<%
Select Case myGen
    Case "brother" %>

        <% Case Else %>

    <% end Select %>

Any clues, please?:)

Steweb · July 10th, 2006, 05:50 PM

Hi,

..post all your code !

Steweb

Visit my web site !
www.steweb.net

adam_kahtava · July 10th, 2006, 06:16 PM

It sounds like you didn't open your RecordSet.

Try:

myRS.Open
myCount = myRS.RecordCount

- Adam Kahtava [http://adam.kahtava.com]