• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

RecordSet.getItemAt( ) Method > RecordSet.getItemAt( ) Method

Name

RecordSet.getItemAt( ) Method

Synopsis

                     myRecordSet.getItemAt(index)

Arguments

index

An integer between 0 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;

PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint