Queries

Methods

  • query.addColumn() Adds a column to a query and populates its rows with the contents of a one-dimensional array. Pads query columns, if necessary, to ensure that all columns have the same number of rows.
  • query.addRow() Adds a specified number of empty rows to a query.
  • query.columnArray() return the column names as array
  • query.columnCount() column count of given query
  • query.columnData() Returns all the data in a query for a given column
  • query.columnExists() Determines whether a specific column is present in a query.
  • query.columnList() return the column names as list
  • query.currentRow() return the row where the pointer of the query is pointing ATM
  • query.deleteColumn() removes a row from a query and return removed row as array
  • query.deleteRow() Deletes the row within a query object. Modifies the original query object
  • query.each() call the given UDF/Closure with every row (struct) in the query.
  • query.every() This function calls a given closure/function with every element in a given query and returns true, if all of the closure calls returns true.
  • query.filter() This function creates a new Query that returns all rows from an query that match the given filter.
  • query.getCell() return the value of a specific query cell
  • query.getRow() this function is deprecated, use function QueryRowData instead.
  • query.keyExists() Determines whether a specific column is present in a query.
  • query.map() Calls the given closure with every row in the given query. the function returns a query that contains all values returned by the closure.
  • query.recordCount() row count of given query
  • query.reduce() Iterates over every row of the given query and calls the closure with that row. This function will reduce the query to a single value and will return this value.
  • query.rowData() Returns a struct with the data from a query for a given row number
  • query.setCell() Sets a cell to a value. If no row number is specified, the cell on the last row is set.
  • query.slice() creates a new query containing a part of the given query
  • query.some() This function calls a given closure/function with every element in a given query and returns true, if one of the closure calls returns true.
  • query.sort() Sorts the query based on the column specified and the order criteria given. Modifies the original query object

Objects

Categories

  • ORM Object-relational mapping

Functions

  • IsQuery Determines whether value is a query.
  • IsValid Tests whether a value meets a validation or data type rule.
  • Query create ans populates a query object in the form query(columnName1:[1,2,3],columnName2:[4,5,6])
  • QueryAddColumn Adds a column to a query and populates its rows with the contents of a one-dimensional array. Pads query columns, if necessary, to ensure that all columns have the same number of rows.
  • QueryAddRow Adds rows to a query, either empty row(s) or you can add a row with data
  • QueryColumnArray return the column names as array
  • QueryColumnCount column count of given query
  • QueryColumnData Returns all the data in a query for a given column
  • QueryColumnExists Determines whether a specific column is present in a query.
  • QueryColumnList return the column names as list
  • QueryConvertForGrid Use instead the function QuerySlice. Converts query data to a structure that contains a paged subset of the query.
  • QueryCurrentRow return the row where the pointer of the query is pointing ATM
  • QueryDeleteColumn removes a row from a query and return removed row as array
  • QueryDeleteRow Deletes the row within a query object. Modifies the original query object
  • QueryEach call the given UDF/Closure with every row (struct) in the query.
  • QueryEvery This function calls a given closure/function with every element in a given query and returns true, if all of the closure calls returns true.
  • QueryExecute Executes a SQL query, returns the result.
  • QueryFilter This function creates a new Query that returns all rows from an query that match the given filter.
  • QueryGetCell return the value of a specific query cell
  • QueryGetRow this function is deprecated, use function QueryRowData instead.
  • QueryKeyExists Determines whether a specific column is present in a query.
  • QueryMap Calls the given closure with every row in the given query. the function returns a query that contains all values returned by the closure.
  • QueryNew Creates an empty query (query object).
  • QueryRecordCount row count of given query
  • QueryReduce Iterates over every row of the given query and calls the closure with that row. This function will reduce the query to a single value and will return this value.
  • QueryRowData Returns a struct with the data from a query for a given row number
  • QuerySetCell Sets a cell to a value. If no row number is specified, the cell on the last row is set.
  • QuerySlice creates a new query containing a part of the given query
  • QuerySome This function calls a given closure/function with every element in a given query and returns true, if one of the closure calls returns true.
  • QuerySort Sorts the query based on the column specified and the order criteria given. Modifies the original query object
  • TransactionCommit commits a pending transaction
  • TransactionRollback rolls back a pending transaction
  • TransactionSetSavePoint Saves a specific state within a transaction
  • ValueArray Returns a array of all the values, for a given column within the query. this function is deprecated, use instead the function queryColumnData
  • ValueList Returns a list of all the values, for a given column within the query, delimited by the value given. this function is deprecated, use instead the function queryColumnData

Guides

Tags

  • <cfprocparam> Specifies parameter information, including type, name, value, and length. The cfprocparam tag is nested within a cfstoredproc tag.
  • <cfquery> Passes SQL statements to a data source. Not limited to queries.
  • <cfqueryparam> Checks the data type of a query parameter.
  • <cfstoredproc> Executes stored procedures by an ODBC or native connection to a server database. It specifies database connection information and identifies the stored procedure.
  • <cftransaction> Groups multiple queries into a single unit. The cftransaction tag provides commit and rollback processing.

See also