ASP in a Nutshell, 2nd Edition

Recordset

A Recordset object represents the records returned from a query (or table) and a cursor into those records. When instantiating a Recordset object, you can automatically create a connection to the underlying data provider on opening the recordset. However, if you use an already open Connection object for your recordset, you can significantly reduce your memory consumption overhead, since each Connection object can maintain multiple recordsets. However, if you open a recordset without using an already open Connection object, that connection can support only that single recordset. You can read more about this feature in the section on the Open method of the Recordset object. Table 12.20, Table 12.21, and Table 12.22 list the Recordset object's properties, collections, and methods, respectively.

Table 12.20. Recordset Object Properties

Property	Description
AbsolutePage	Allows you to determine the exact page of records in which the current record resides. Each recordset is broken up by the data provider and ADO into pages of PageSize number of records, with the last page possibly containing fewer records. This is a read-only value of type Long.
AbsolutePosition[17]	The ordinal number of the current record in the recordset. This is a read/write value of type Long.
ActiveCommand	Read-only property containing the name of the Command object that was used to create the current Recordset object.
ActiveConnection[17]	The currently open Connection object to which the ...