GetRows method
Restore multiple records of the RecordSet object to an array.
grammar
Array = RecordSet.Getrows (Rows, Start, Fields)
return value
Returns the two-dimensional array.
parameter
Rows optional, long integer expression, specifying the number of records to retrieve. The default is adGetrowsRest (-1).
START optional, string or long integer, calculates a bookmark that is recorded at the beginning of the getRows operation. You can also use the following bookmarkenum values.
Constant Description AdbookMarkCurrent starts from the current record. AdbookMarkFirst starts from the first record. AdbookMarkLast starts from the tail record.
Fields optional, variable body, represent a single field name, sequential location, field name or sequential location number. ADO only returns data in these fields.
Description
Use the getRows method to copy the record from the Recordset to a two-dimensional array. The first subscript identification field, the second, identifies the record number. The array variable will be automatically adjusted to the correct size when the getRows method returns data.
If you do not specify the value of the ROWS parameter, the GetRows method will automatically retrieve all records in the Recordset object. If the requested record is more than available, GetRows only returns the number of available records.
If the Recordset object supports bookmarks, you can specify which record will start retrieving data by transmitting the BookMark property value of the record.
To limit the fields returned by getRows call, you can transfer a single field name / number or field name / number array in the fields parameter.
After calling getRows, the next unread record becomes the current record, or if there is no more records, the EOF property is set to TRUE.
Call this function to get an array, the following process is the same as the root PHP practice ...
