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

  • DbPoolClear clears all existing datasource connection
  • 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.
  • 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 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.
  • 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

  • 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. ### Example : ### ```lucee+trycf q = QueryNew("name, description"); loop times=3 { getFunctionList()

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