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
|
edit
Name of the new column. Alias: columnName |
|
datatype_or_array
any,
optional
|
edit
Column data type. Alias: datatype |
|
array
any,
optional
|
edit
Name of an array whose elements populate the new column. |
Examples
edit 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);