You should try this question on the asp_databases list.

Stephen

"Peili Zhang" <peili_z@y...> wrote in message news:167372@g..._live...
>
> Dear Sir:
>
> I love your books very much!
>
> I have not taken the ASP class, but I need to write the ASP in my
projects, so I bought the book, Beginning Active Server Pages 3.0. From
learning the Chapter 15, I quickly make some ASP pages.
>
> Thank you so much!
>
> However, I met a problem: I don't know why my recordset cannot use the
RecordCount to get the records number. Then, I study Chapter 13, 14, and see
the RecordCount is working there.
>
> My ASP database is in the SQL Server, and I don't know why the RecordCount
alway is -1.
>
> So, I have to use loop to get the records number.
>
> Wish you can help me to tell me how I can make the RecordCount to work,
not using the loop.
>
> Best Regards!!!
>
> Your reader,
>
> Peili Zhang
>
>
>
> ---------------------------------
> Do You Yahoo!?
> Yahoo! Games - play chess, backgammon, pool and more