rows count

[Aaron Bertrand - MVP]

Move the resultset to an array using getRows, and then use ubound.

See [url]http://www.aspfaq.com/2193[/url] and [url]http://www.aspfaq.com/2467[/url]






"swril" <ref@eynoi.com> wrote in message
news:3f1d6c3d$0$262$ba620e4c@reader0.news.skynet.b e...

> Hi,
>
> I'm starting with asp and I have a problem. When I try a query to a

database

> like this :
>
> query = "SELECT * FROM table1"
> set RS = conn.execute(query)
>
> How can I know the number of rows returned by the query ?
>
> Thanks,
>
>

[Ray at]

UBound +1, although I'm sure that's covered in your FAQ page...

Ray at work

"Aaron Bertrand - MVP" <aaron@TRASHaspfaq.com> wrote in message
news:OTJIoKHUDHA.2512@TK2MSFTNGP10.phx.gbl...

> Move the resultset to an array using getRows, and then use ubound.
>
> See [url]http://www.aspfaq.com/2193[/url] and [url]http://www.aspfaq.com/2467[/url]
>
>
>
>
>
>
> "swril" <ref@eynoi.com> wrote in message
> news:3f1d6c3d$0$262$ba620e4c@reader0.news.skynet.b e...

> > Hi,
> >
> > I'm starting with asp and I have a problem. When I try a query to a

> database

> > like this :
> >
> > query = "SELECT * FROM table1"
> > set RS = conn.execute(query)
> >
> > How can I know the number of rows returned by the query ?
> >
> > Thanks,
> >
> >

>
>

[Unregistered]

try RS.recordCount

eg <%Response.Write(RS.RecordCount)%>