Using A Dynamic Column Name With ValueList() In ColdFusion

evaluate-valuelist.cfm

<cfscript>

	friends = queryNew( "" );

	// Add our name column with initial row values.
	queryAddColumn(
		friends,
		"name",
		"cf_sql_varchar",
		[ "Sarah", "Tricia", "Jill" ]
	);

	// Create a variable that holds our "dynamic" column reference.
	targetColumn = "name";

	// Use the evaluate() function to invoke the valueList() function
	// using our dynamic column reference.
	writeDump(
		evaluate( "valueList( friends.#targetColumn# )" )
	);

</cfscript>

misc-1.cfm

valueList( users.id );

misc-2.cfm

valueList( users[ "id" ] );

misc-3.cfm

column = users[ "id" ];
valueList( column );