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]

[url]http://www.aspfaq.com/2193[/url]

Ray at work

"middletree" <middletree@htomail.com> wrote in message
news:eGxmhPzkDHA.3504@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
>
>

[Tom Kaminski [MVP]]

"middletree" <middletree@htomail.com> wrote in message
news:eGxmhPzkDHA.3504@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

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

--
Tom Kaminski IIS MVP
[url]http://www.iistoolshed.com/[/url] - tools, scripts, and utilities for running IIS
[url]http://mvp.support.microsoft.com/[/url]
[url]http://www.microsoft.com/windowsserver2003/community/centers/iis/[/url]

[middletree]

That did it; thanks


"Ray at <%=sLocation%>" <myfirstname at lane34 dot com> wrote in message
news:uplPESzkDHA.2216@TK2MSFTNGP12.phx.gbl...

> [url]http://www.aspfaq.com/2193[/url]
>
> Ray at work
>
> "middletree" <middletree@htomail.com> wrote in message
> news:eGxmhPzkDHA.3504@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
> >
> >

>
>

[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

"middletree" <middletree@htomail.com> wrote in message
news:%23iujuN0kDHA.3024@tk2msftngp13.phx.gbl...
: That did it; thanks
:
:
: "Ray at <%=sLocation%>" <myfirstname at lane34 dot com> wrote in message
: news:uplPESzkDHA.2216@TK2MSFTNGP12.phx.gbl...
: > [url]http://www.aspfaq.com/2193[/url]
: >
: > Ray at work
: >
: > "middletree" <middletree@htomail.com> wrote in message
: > news:eGxmhPzkDHA.3504@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
: > >
: > >
: >
: >
:
:

[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
news:uplPESzkDHA.2216@TK2MSFTNGP12.phx.gbl...
[url]http://www.aspfaq.com/2193[/url]

Ray at work

"middletree" <middletree@htomail.com> wrote in message
news:eGxmhPzkDHA.3504@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
>
>

[Ray at]

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

Ray at work

"Chris Barber" <chris@blue-canoe.co.uk.NOSPAM> wrote in message
news:ObbInf8kDHA.2772@TK2MSFTNGP12.phx.gbl...

> 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.

[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
news:ex1UzS%23kDHA.2456@TK2MSFTNGP09.phx.gbl...
It's not my site!!! [url]http://www.aspfaq.com/credits.asp[/url] But you're right.
It's an outstanding FAQ site...

Ray at work

"Chris Barber" <chris@blue-canoe.co.uk.NOSPAM> wrote in message
news:ObbInf8kDHA.2772@TK2MSFTNGP12.phx.gbl...

> 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]

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

"Chris Barber" <chris@blue-canoe.co.uk.NOSPAM> wrote in message
news:u9OMJi%23kDHA.708@TK2MSFTNGP10.phx.gbl...

> 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
> news:ex1UzS%23kDHA.2456@TK2MSFTNGP09.phx.gbl...
> It's not my site!!! [url]http://www.aspfaq.com/credits.asp[/url] But you're right.
> It's an outstanding FAQ site...
>
> Ray at work
>
> "Chris Barber" <chris@blue-canoe.co.uk.NOSPAM> wrote in message
> news:ObbInf8kDHA.2772@TK2MSFTNGP12.phx.gbl...

> > 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.

>
>
>