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 Cross Site Scripting attacks.

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 Cross Site Scripting attacks.
  • 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.
  • 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

  • Cache a query for the current request Cache a Query for the current request
  • Lazy Queries How to use lazy queries
  • Lucee Sql Types SQL types supported by lucee.
  • Query Handling In Lucee How to do SQL Queries with Lucee
  • Query of Queries (QoQ) Query of queries (QoQ) is a technique for re-querying an existing (in memory) query without another trip to the database.
  • Query of Query Sucks ## Query of Query Sucks ## This document explains why Query of Query is not the best approach and provides simple example about QoQ. The main reason you would not want to use query of query is that it is very slow. Update, the performance of QoQ has been dramatically improved in 5.3.8! ### Example : ### ```lucee+trycf q = QueryNew("name, description"); loop times=3 { getFunctionList()
  • Query return type This document explains the different return types for a query with some examples.

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