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.getCellByIndex() 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.rowByIndex()
  • query.rowData() Returns a struct with the data from a query for a given row number
  • query.rowDataByIndex()
  • query.setCell() Sets a cell to a value. If no row number is specified, the cell on the last row is set.
  • query.setRow() Adds a row to a query, either by struct or array
  • 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
  • string.encodeForSQL() Encodes the given string for safe output in a query to reduce the risk of SQL Injection attacks. _This method is not recommended_ - the use of query parameters are strongly encouraged as a stronger alternative.

Objects

Categories

  • ORM Object-relational mapping

Functions

  • DbPoolClear() clears all existing datasource connection
  • EncodeForSQL() Encodes the given string for safe output in a query to reduce the risk of SQL Injection attacks. _This method is not recommended_ - the use of query parameters are strongly encouraged as a stronger alternative.
  • GetMetadata() Returns back meta information depending on the object passed in
  • IsQuery() Determines whether value is a query.
  • IsValid() Tests whether a value meets a validation or data type rule.
  • iswithintransaction() Determines whether the current thread is within a transaction block or not.
  • Query() Create and populate 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
  • QueryClose() When using lazy="true", it is important to close the resultset during a request or it will continue to use heap memory.
  • 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.
  • 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
  • QueryGetCellByIndex() 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 query.
  • 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.
  • QueryRowByIndex() Since 5.3.4.23
  • QueryRowData() Returns a struct with the data from a query for a given row number
  • QueryRowDataByIndex()
  • QuerySetCell() Sets a cell to a value. If no row number is specified, the cell on the last row is set.
  • QuerySetRow() Adds a row to a query, either by struct or array
  • 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 an 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