Alternatively, look at using .GetRows() if you also need the data, rather
than executing two queries.
..getRows places your Recordset data into a VBScript array. Then you can use
the UBound() function to work out how many records there are.
Cheers
Ken
"middletree" <mi********@htomail.com> wrote in message
news:%2****************@tk2msftngp13.phx.gbl...
: That did it; thanks
:
:
: "Ray at <%=sLocation%>" <myfirstname at lane34 dot com> wrote in message
: news:up**************@TK2MSFTNGP12.phx.gbl...
: >
http://www.aspfaq.com/2193
: >
: > Ray at work
: >
: > "middletree" <mi********@htomail.com> wrote in message
: > news:eG**************@TK2MSFTNGP11.phx.gbl...
: > > I'm simply trying to get a number of records returned in a recordset,
: and
: > > just get a -1. I have looke din a few books and other references,
can't
: > > seem to find any answers. Anyone have any idea why I can't get a real
: > > number? For the record, the recordset is not empty. In fact, it has
: many
: > > records which I can see plainly on the screen. But when I do
: > response.write
: > > rs.recordcount, it just shows -1
: > >
: > >
: >
: >
:
: