Wrox Home  
Search P2P Archive for: Go

  Return to Index  

proasp_howto thread: Counting records in a recordset and/or returning recordset + parameters together


Message #1 by "Walter Burrough" <w.burrough@h...> on Mon, 14 Aug 2000 10:31:54 +0100

> Ahh, waves of comprehension!
> Does _client_ refer to the web server (as a client of the database)? Or is
> this RDS and an MS IE only solution?

Clients and Server refer to data-servers and data-clients.

In this case, client refers to the OLEDB Cursor service (ie the one on your
webserver), and server refers to the underlying data source (eg you DBMS).

As I said before, if you use adUseClient, you get an adOpenStatic cursor,
which supports recordCound.

Otherwise, keep the adUseServer cursor, and use an adOpenStatic, or
adOpenKeyset cursor.

However, if you want to use adOpenForwardOnly, you'll need to use .getRows,
and evaluate the UBound() of the resulting array.

Cheers
Ken


  Return to Index