valueArray

Returns an array of values for the given query and column.

valueArray(query, column) → returns array

  1. CFDocs
  2. Functions
  3. ColdFusion 2016 New Functions and Tags
  4. valueArray
  5. CF2016+
  6. Lucee
  7. 0 Issue
  8. Edit
See Also:   queryColumnData   valueList

Argument Reference

query query
Required

A query object

column string
Required

The column name whose values you want

Compatibility

Lucee:

Lucee also supports passing query.columnName as the first argument, however it appears to be deprecated syntax. Use queryColumnData() instead.

Examples
Sample code invoking the valueArray function

Converts the id column values into an array

news = queryNew("id", "integer", [ {id:1}, {id:2} ]);
writeOutput( serializeJSON( valueArray(news, "id") ) );

Expected Result: [1,2]

Signup for cfbreak to stay updated on the latest news from the ColdFusion / CFML community. One email, every friday.

Fork me on GitHub