recordcount -1

[middletree]

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

 

[Ray at]

http://www.aspfaq.com/2193

Ray at work

 

[Tom Kaminski [MVP]]

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

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

 

[middletree]

That did it; thanks

http://www.aspfaq.com/2193

Ray at work

 

[Ken Schaefer]

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

: That did it; thanks
:
:
: "Ray at <%=sLocation%>" <myfirstname at lane34 dot com> wrote in message
: : > http://www.aspfaq.com/2193
: >
: > Ray at work
: >
: > : > > 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
: > >
: > >
: >
: >
:
:

 

[Chris Barber]

That's a nice FAQ Ray.

Some day I must try and see if you have a searchable index [XML hopefully] I
can periodically [read 'automagically'] get hold of and put on my intranet /
website.

Chris.


"Ray at <%=sLocation%>" <myfirstname at lane34 dot com> wrote in message
http://www.aspfaq.com/2193

Ray at work

 

[Ray at]

It's not my site!!! http://www.aspfaq.com/credits.asp But you're right.
It's an outstanding FAQ site...

Ray at work

 

[Chris Barber]

Since you're always posting the FAQ ref's, I thought it was your site!
I had a vision of you knowing every FAQ number off by heart and just quoting
them ad hoc in the relevant posts.

LoL.

Chris.

"Ray at <%=sLocation%>" <myfirstname at lane34 dot com> wrote in message
It's not my site!!! http://www.aspfaq.com/credits.asp But you're right.
It's an outstanding FAQ site...

Ray at work

 

[Ray at]

Heh. I think I accuse Aaron of the same thing before. No, I link that that
site all the time because I think 95% of what I know came from there. Don't
forget to click the paypal link. :]

Ray at work

Since you're always posting the FAQ ref's, I thought it was your site!
I had a vision of you knowing every FAQ number off by heart and just quoting
them ad hoc in the relevant posts.

LoL.

Chris.

"Ray at <%=sLocation%>" <myfirstname at lane34 dot com> wrote in message
It's not my site!!! http://www.aspfaq.com/credits.asp But you're right.
It's an outstanding FAQ site...

Ray at work

That's a nice FAQ Ray.

Some day I must try and see if you have a searchable index [XML

hopefully]

I
can periodically [read 'automagically'] get hold of and put on my

intranet

/
website.

Chris.