User Guide

798 Chapter 3: ColdFusion Functions

QueryNew

Description

Creates an empty query (query object).

Returns

An empty query with a set of named columns, or an empty query.

See also

QueryAddColumn

, QueryAddRow, QuerySetCell; “Managing data types for columns” in

Chapter 22, “Using Query of Queries,” ColdFusion MX Developer’s Guide

Parameters

Usage

If you specify an empty string in the columnlist parameter, you must use the QueryAddColumn

function to add columns to the query.

Macromedia recommends that you use the optional

columntypelist parameter. Without this

parameter, ColdFusion must try to determine data types when it uses the query object in a query

of queries. Determining data types requires additional processing, and can result in errors if

ColdFusion does not guess a type correctly.

Parameter Description

columnlist Comma-delimited list of column names, or an empty string.

columntypelist (Optional) Comma-delimited list specifying column data types. ColdFusion

generates an error if the data you add to the column is not of this type, or if it cannot

convert the data to this type. The following data types are valid:

• Integer: 32-bit integer

• BigInt: 64-bit integer

• Double: 64-bit decimal number

• Decimal: Variable length decimal, as specified by java.math.BigDecimal

• VarChar: String

• Binary: Byte array

• Bit: Boolean (1=True, 0=False)

• Time: Time

• Date: Date (can include time information)