Jaxer.DB.ResultSet

Results returned from executed SQL statements are returned as an instance of Jaxer.DB.ResultSet.

Constructor

Instances of this class are created and returned from with the Jaxer framework.

Properties

  • Jaxer.DB.ResultSet.columns
  • An array of column names for all rows in this resultSet.

  • Jaxer.DB.ResultSet.finalRow
  • This returns the data in the last row of the resultSet as an object, or else it contains an empty object.

  • Jaxer.DB.ResultSet.firstRow
  • This returns the data in the first row of the resultSet as an object, or else it contains an empty object.

  • Jaxer.DB.ResultSet.hasData
  • True if this resultSet contains any data, false otherwise.

  • Jaxer.DB.ResultSet.rows
  • The array of rows in the resultSet in the order retrieved from the database. Each row has properties corresponding to the column names in the returned data.

  • Jaxer.DB.ResultSet.rowsAsArrays
  • An alternate representation of the rows of the resultSet: each row is itself an array, containing the values (cells) in that row in the same order as the columns array.

  • Jaxer.DB.ResultSet.singleColumn
  • This returns the data in each of the first columns of the resultSet as an array, or else it contains an empty array.

  • Jaxer.DB.ResultSet.singleResult
  • This contains the first value (cell) in the first row in the resultSet, if any, or else it contains null.

  • Jaxer.DB.ResultSet.singleRow
  • This contains the data in the first row of the resultSet as an object, or else it contains an empty object.

    Methods

    Values associated with instances of this class are refferenced through the properties. Methods are intended for the internal framework.