Arguments
- index
-
An integer between and the length of the RecordSet object minus one.
Returns
A row (i.e., a single record) of the RecordSet object.
Description
The getItemAt( ) method returns a full row of a recordset. The return value is a single record from the recordset, represented as an associative array whose keys correspond to the recordset's column names . You can retrieve individual fields by name from the row returned by this method.
Example
The following code returns a row of the recordset and then sets variables to the value of each field in the record:
var myRow = myRecordset.getItemAt(0); var myFirstName = myRow.FirstName; var myLastName = myRow.LastName; myTextField.text = "Hello " + myFirstName + " " + myLastName;
Individual fields can also be accessed through associative array notation, as in this example:
var myRow = myRecordSet.getItemAt(0); var myFirstName = myRow["FirstName"];
See Also
RecordSet.addItemAt( ) , RecordSet.getColumnNames( ), RecordSet.replaceItemAt( ) ; Chapter 4