Parameter
Last updated on
Oct 27, 2023
Description
This function converts the values of a specified column of a query into an array.
Returns
An array of column values.
Category
History
New In Adobe ColdFusion (2016 release)
Syntax
ValueArray (Object query, String columnName)
ValueArray (Object query, String columnName)
ValueArray (Object query, String columnName)
Parameters
|
|
Req/Opt |
Description |
|
query |
Required |
The query to be iterated over. |
|
columnName |
Required |
The name of the column whose values you want to return. |
Example 1
<cfscript>
myQuery = queryNew("id,name,amount","Integer,Varchar,Integer",
[
{id=1,name="One",amount=15},
{id=2,name="Two",amount=18},
{id=3,name="Three",amount=32},
{id=4,name="Four",amount=53}
]);
// Convert the values in the column Address into the array myColumn
arrayList=ValueArray(myQuery,"name")
// Display array values
writeDump(arrayList)
</cfscript>
<cfscript>
myQuery = queryNew("id,name,amount","Integer,Varchar,Integer",
[
{id=1,name="One",amount=15},
{id=2,name="Two",amount=18},
{id=3,name="Three",amount=32},
{id=4,name="Four",amount=53}
]);
// Convert the values in the column Address into the array myColumn
arrayList=ValueArray(myQuery,"name")
// Display array values
writeDump(arrayList)
</cfscript>
<cfscript>
myQuery = queryNew("id,name,amount","Integer,Varchar,Integer",
[
{id=1,name="One",amount=15},
{id=2,name="Two",amount=18},
{id=3,name="Three",amount=32},
{id=4,name="Four",amount=53}
]);
// Convert the values in the column Address into the array myColumn
arrayList=ValueArray(myQuery,"name")
// Display array values
writeDump(arrayList)
</cfscript>
Output
Example 2
<cfscript>
// Execute a query from table Orders
myQuery=QueryExecute("select * from orders",[],{datasource="cfartgallery"});
// Convert the values in the column Address into the array myColumn
myColumn=ValueArray(myQuery,"Address");
// Display array values
writedump(myColumn);
</cfscript>
<cfscript>
// Execute a query from table Orders
myQuery=QueryExecute("select * from orders",[],{datasource="cfartgallery"});
// Convert the values in the column Address into the array myColumn
myColumn=ValueArray(myQuery,"Address");
// Display array values
writedump(myColumn);
</cfscript>
<cfscript>
// Execute a query from table Orders
myQuery=QueryExecute("select * from orders",[],{datasource="cfartgallery"});
// Convert the values in the column Address into the array myColumn
myColumn=ValueArray(myQuery,"Address");
// Display array values
writedump(myColumn);
</cfscript>
Output
Note:
Before the implementation of ValueArrray member function, you could also use query["column"] to convert the column values into an array, as shown below:
<cfscript>
a=[];
q = queryNew("foobar", "", [["foo"],["bar"]]);
a.append(q["foobar"], true);
writeDump(a);//returns same result as q.valueArray("foobar")
</cfscript>
<cfscript>
a=[];
q = queryNew("foobar", "", [["foo"],["bar"]]);
a.append(q["foobar"], true);
writeDump(a);//returns same result as q.valueArray("foobar")
</cfscript>
<cfscript>
a=[];
q = queryNew("foobar", "", [["foo"],["bar"]]);
a.append(q["foobar"], true);
writeDump(a);//returns same result as q.valueArray("foobar")
</cfscript>
