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.

For ACF compatibility, starting with version 6.0.0.207, the member function query.addColumn() returns the updated query (allowing method chaining). see LDEV-3581

query.addColumn( column=string, datatype_or_array=any, array=any )

Returns: Query

Argument Description
column
string, required

Name of the new column.

Alias: columnName
datatype_or_array
any, optional

Column data type.

Alias: datatype
array
any, optional

Name of an array whose elements populate the new column.

Examples

	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