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.

queryAddColumn(query, column_name [, datatype], array_name) → returns numeric

Member Function Syntax

someQuery.addColumn(column_name [, datatype], array_name)

CF4+

Lucee

BL 1.0.0+

Argument Reference

query query
Required

column_name string
Required

datatype string

Column data type.

Values:

Integer
Bigint
Double
Decimal
Varchar
Binary
Bit
Time
Date
Timestamp

array_name array
Required

Links more information about queryAddColumn

Adding A Column From Second Query To First Query

Examples
Sample code invoking the queryAddColumn function

Tag Example

<!--- Make a query. ---> 
 <cfset myQuery = queryNew("")> 
  <!--- Create an array. ---> 
 <cfset FastFoodArray = arrayNew(1)> 
 <cfset FastFoodArray[1] = "French Fries"> 
 <cfset FastFoodArray[2] = "Hot Dogs"> 
 <cfset FastFoodArray[3] = "Fried Clams"> 
 <cfset FastFoodArray[4] = "Thick Shakes"> 
 <!--- Use the array to add a column to the query. ---> 
 <cfset nColumnNumber = queryAddColumn(myQuery, "FastFood", "VarChar", FastFoodArray)> 
 <cfdump var="#myQuery#" />

member syntax example

add a column to a query using member syntax

books = queryNew("id,title", "integer,varchar");
books.addColumn("author", "varchar", []);
writeDump(books);

© 2012–present Foundeo, Inc. and the CFDocs contributors.
Licensed under the MIT License.
ColdFusion is a trademark of Adobe Systems Incorporated.
https://cfdocs.org/queryaddcolumn