query.addColumn()

Adds a column to a query and populates its rows with the contents of an one-dimensional array.

Pads query columns, if necessary, to ensure that all columns have the same number of rows.

query.addColumn( column [, datatype_or_array [, array ] ] )

Returns: Number

Argument Description
column
string, required

Alias: columnname

datatype_or_array
any, optional

Alias: datatype

array
any, optional

Examples

luceescript+trycf myquery = querynew("id,name"); myquery.addrow(); myquery.setcell("id","1"); myquery.setcell("name","item1"); myquery.addRow(); myquery.setcell("id","2"); myquery.setcell("name","item2"); myquery.addColumn("age",listtoarray("20,21")); myquery.addColumn("class",listtoarray("A,B")); writeDump(myquery);

See also