cfdocs

queryColumnList

Returns the column names of a query as a list.

queryColumnList(query [, delimiter])

returns string

Member Function Syntax

query.columnList([delimiter])

Argument Reference

Name	Type	Required	Default	Description
query	query	Yes
delimiter	string	No	,

Create a query and output the column list

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

Expected Result: ID,name,age

Using a member function

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

Expected Result: ID,name,age

This site is open source. Improve this page.