Description
Creates an empty query (query object).
Returns
An empty query with a set of named columns, or an empty query.
Creates an empty query (query object).
An empty query with a set of named columns, or an empty query.
1 | QueryNew (columnlist [, columntypelist[, rowData]]) |
ColdFusion MX 7: Added columntypelist parameter.
ColdFusion 10: Added rowData parameter.
QueryAddColumn, QueryAddRow, QuerySetCell; Managing data types for columns in Query of Queries user guide in the Developing ColdFusion Applications
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:
|
rowData | (Optional) Specifies data to add to the new query. Can be one of:
See "Usage" for examples. |
If you specify an empty string in the columnlist parameter, use the QueryAddColumn function to add columns to the query.Adobe 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.Enhancements in ColdFusion 10 lets you initialize the query data. You can specify a struct, an array of structs, or arrays with single or multiple dimensions to initialize the query as shown in the following example:
1 2 3 4 5 6 7 8 | myQuery1 = queryNew ( "id,name" , "Integer,Varchar" , {id=1,name= "One" }); myQuery2 = queryNew ( "id,name" , "Integer,Varchar" , [ {id=1,name= "One" }, {id=2,name= "Two" }, {id=3,name= "Three" } ]); myQuery3 = queryNew ( "id,name" , "Integer,Varchar" , [ [1, "One" ], [2, "Two" ], [3, "Three" ] ]); |
Example
The following example uses the QueryNew function to create an empty query with three columns. It populates two rows of the query and displays the contents of the query object and its metadata.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 | <!--- Create a new three-column query, specifying the column data types ---> < cfset myQuery = QueryNew ( "Name, Time, Advanced" , "VarChar, Time, Bit" )> <!--- Make two rows in the query ---> < cfset QueryAddRow (MyQuery, 2)> <!--- Set the values of the cells in the query ---> < cfset QuerySetCell (myQuery, "Name" , "The Wonderful World of CMFL" , 1)> < cfset QuerySetCell (myQuery, "Time" , "9:15 AM" , 1)> < cfset QuerySetCell (myQuery, "Advanced" , False, 1)> < cfset QuerySetCell (myQuery, "Name" , "CFCs for Enterprise Applications" , 2)> < cfset QuerySetCell (myQuery, "Time" , "12:15 PM" , 2)> < cfset QuerySetCell (myQuery, "Advanced" , True, 2)> <h4>The query object contents</h4> < cfoutput query = "myQuery" > #Name# #Time# #Advanced# </ cfoutput > <h4>Using individual query data values</h4> < cfoutput > #MyQuery.name[2]# is at #MyQuery.Time[2]# </ cfoutput > <h4>The query metadata</h4> < cfset querymetadata= getMetaData (myQuery)> < cfdump var= "#querymetadata#" > |