Programming ColdFusion

Name

QueryAddColumn — New as of ColdFusion 4.01

Synopsis

QueryAddColumn(query, columnname, arrayname)

Adds a new column called columnname to query and populates its rows with data from a one-dimensional array specified by arrayname. The following example adds a new column to a query and populates it with data from an array:

<CFSET Products = QueryNew("ProductName, Color, Price, Qty")> <CFSET NewRows = QueryAddRow(Products, 3)> <CFSET temp = QuerySetCell(Products, "ProductName", "Widget", 1)> <CFSET temp = QuerySetCell(Products, "Color", "Silver", 1)> <CFSET temp = QuerySetCell(Products, "Price", "19.99", 1)> <CFSET temp = QuerySetCell(Products, "Qty", "46", 1)> <CFSET temp = QuerySetCell(Products, "ProductName", "Thingy", 2)> <CFSET temp = QuerySetCell(Products, "Color", "Red", 2)> <CFSET temp = QuerySetCell(Products, "Price", "34.99", 2)> <CFSET temp = QuerySetCell(Products, "Qty", "12", 2)> <CFSET temp = QuerySetCell(Products, "ProductName", "Sprocket", 3)> <CFSET temp = QuerySetCell(Products, "Color", "Blue", 3)> <CFSET temp = QuerySetCell(Products, "Price", "1.50", 3)> <CFSET temp = QuerySetCell(Products, "Qty", "460", 3)> <CFSET ShippingArray = ArrayNew(1)> <CFSET ShippingArray[1] = "1.99"> <CFSET ShippingArray[2] = "3.48"> <CFSET ShippingArray[3] = "5.00"> <CFSET MyNewColumn = QueryAddColumn(Products, "Shipping", ShippingArray)> <TABLE> <TR> <TH>Product</TH><TH>Color</TH><TH>Price</TH><TH>Quantity</TH><TH>Shipping</TH> </TR> <CFOUTPUT QUERY="Products"> <TR> <TD>#ProductName#</TD><TD>#Color#</TD><TD>#Price#</TD><TD>#Qty#</TD> ...