Function Description
IsQuery Determines whether a value is a query.
QueryAddColumn Adds a column to a query and populates its rows with the
contents of a one-dimensional array. 
QueryAddRow Adds a specified number of empty rows to a query.
QueryConvertForGrid Converts query data to a structure that contains a paged subset of the query.
QueryEach Calls each row of the query provided.
QueryExecute Executes a SQL query and returns the result.
QueryFilter Calls the provided function for each row of the provided query and removes the row from the query if the function returns false.
QueryGetRow Returns a struct having all the columns as keys and their corresponding values.
QueryGetResult Returns the metadata of a query.
QueryKeyExists Checks the query for a column with the same name as the key provided.
QueryMap Iterates over each row of a query and calls the closure function to work on row of the query. 
QueryNew Creates a query object.
QueryReduce Iterates over each row of a query and calls the closure function to work on the row of the query. 
QuerySetCell Sets a cell to a value. If no row number is specified, the cell on the last row is set.
QuerySort Sorts a query where the sorting algorithm is passed at runtime in the form of closure.
QuotedValueList Gets the values of each record returned from an executed query.
ValueArray Converts the values of a column into an array.
ValueList Inserts a delimiter between each value in an executed query.

This work is licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License  Twitter™ and Facebook posts are not covered under the terms of Creative Commons.

Legal Notices   |   Online Privacy Policy