Represents the results of a SQL query.
It contains a list for the column names of the results, and a list of JsonArray - one for each row of the
results.
AnythingResultSetBaseDataObjectBasicIdentifiableObjectAnythingno subtypes hierarchy
| Initializer |
ResultSet({String*}? columnNames = null, ResultSet? next = null, Integer? numColumns = null, Integer? numRows = null, JsonArray? output = null, {JsonArray*}? results = null, {JsonObject*}? rows = null)Parameters:
|
| Attributes | |
columnNames | shared {String*}? columnNamesGet the column names |
next | shared ResultSet? nextGet the next result set |
numColumns | shared Integer? numColumnsReturn the number of columns in the result set |
numRows | shared Integer? numRowsReturn the number of rows in the result set |
output | shared JsonArray? outputGet the registered outputs |
results | shared {JsonArray*}? resultsGet the results |
rows | shared {JsonObject*}? rowsGet the rows - each row represented as a JsonObject where the keys are the column names and the values are the column values. Beware that it's legal for a query result in SQL to contain duplicate column names, in which case one will overwrite the other if using this method. If that's the case use getResults instead. Be aware that column names are defined as returned by the database, this means that even if your SQL statement is for example: SELECT a, b FROM tablethe column names are not required to be: aand band could be in fact Aand B. For cases when there is the need for case insentivitity you should see getRows |
| Inherited Attributes |
Attributes inherited from: Objecthash, string |