Whitebeam Object Definition

Site Map
 
Home
 
Application Guide
Reference
  Installation
  Configuration
  XML Markup
  JavaScript Classes
  ROM
  Templates
  Environment
  Dev Process
  Tools
  External Links
  Example libraries
Community
Contact Whitebeam
To-Do
Download
Credits
Licence
Whitebeam Users
 
 
 

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
rowIndexnumber  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.

Whitebeam release 1.3.36
(loadtime : 29ms)