|
Whitebeam Object Definition
|
Method Description
PgsqlResult.fetchRowArray()
Read an indexed row from the result set, returning the result as JavaScript array of columns.
See Also
PgsqlConnection,
PgsqlResult,
Whitebeam Posgres technote Syntax
stringArray = PgsqlResult.fetchRowArray(rowIndex)
Parameters
The 'PgsqlResult.fetchRowArray' method takes 1 parameter:
Name | Type/Value | Range/Length | Description | rowIndex | number | | Required. The index, starting from zero (0), of the row to retrieve |
Results
The 'PgsqlResult.fetchRowArray' method returns an array of string:
Type/Value | Range/Length | Description |
string |
  |
Returns a JavaScript array containing the columns from a specific row as an array.
|
Remarks Creates a JavaScript array to contain the contents of a specific row in the result set. Note that this
method only returns something sensible if the operation performed on the database (connection.exec)
returned query data from the database (eg a SQL SELECT statement). The Array subscripts are numbered from 0..n to reflect each successive column in the result set. | If the index value is out of range this method throws a catchable exception. The types of the fields returned will be numbers for numeric fields, binary objects for 'BYTEA' fields and strings for all other field types. |
|
|
(loadtime : 10ms) |