queryColumnList

Returns the column names of a query as a list.

queryColumnList(query [, delimiter]) → returns string

Member Function Syntax

query.columnList([delimiter])

  1. CFDocs
  2. Functions
  3. Query Manipulation Functions
  4. queryColumnList
  5. Lucee
  6. BL 1.0.0+
  7. 0 Issue
  8. Edit
See Also:   queryColumnList   queryColumnCount   queryColumnExists   valueArray

Argument Reference

query query
Required

delimiter string
Default: ,

Examples
Sample code invoking the queryColumnList function 

myQuery = queryNew( 'ID,name,age' );
writeOutput( queryColumnList( myQuery ) );

Expected Result: ID,name,age

myQuery = queryNew( 'ID,name,age' );
writeOutput( myQuery.columnList() );

Expected Result: ID,name,age

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

Fork me on GitHub