MACROMEDIA COLFUSION MX 7 - INSTALLING AND USING COLDFUSION MX, Reference

Page: 798 / 1108

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.
Category
Query functions
Function syntax
QueryNew ( columnlist [, columntypelist ])
History
ColdFusion MX 7: Added
columntypelist
parameter.
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)