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

PgsqlResult Object Description

This class encapsulates the result of a Postgres database operation, executed through PgsqlConnection.exec(SQL_statement). Instances of this class contain the basic status information providing success/failure of an operation, and also an interface to read individual row information from a SQL query.

Details of how to us the Whtebeam Postgres interface can be found in our tutorial dealing with this specific topic.

Also see PgsqlConnection

Methods

PgsqlResult.clear() Clear a result set.
PgsqlResult.fetchRowObject() Read an indexed row from the result set, returned as a JavaScript 'Object'.
PgsqlResult.fetchRowArray() Read an indexed row from the result set, returning the result as JavaScript array of columns.

Object Properties

Name Type/Value Range/Length Description
successbool  Required. The success (true) or failure (false) status of this request. If this is 'true' then Postgres reported no errors with the operations executed on the database.
statusstring  Required. Returns a string representation of operation result code stored in the PgsqlResult object.
errorstring  Required. If PgsqlResult.success has the value 'false' (the database operation failed) then this property will contain a human readable description of the error that occurred. This will contain an empty string if the operation succeeded.
numRowsnumber  Required. The number of rows returned in a SQL query. This value will be zero for operations that update database (INSERT etc). This returns the number of rows of a table returned, for example, as the result of a SELECT query.
affectedRowsnumber  Required. Number of rows changed by a SQL operation.

Whitebeam release 1.3.36
(loadtime : 25ms)