How to convert Query column to a list in ColdFusion

coldfusion cfquery
erikvold picture erikvold · Mar 30, 2011 · Viewed 41.8k times · Source

I'm trying to convert ColdFusion query column to a list, what is the best way to do so?

I thought that there is a built in function that allows one to easily convert a query's column in to a list, if there is what is it?

Answer

ale picture ale · Nov 23, 2011

There is a built-in function to do that: ValueList

<cfset myList = ValueList(query.columnname)>

As with all of the list functions, there's an optional delimiter attribute.

<cfset myList = ValueList(query.columnname,"|")>

If you need the values in the list to have double-quotes around them, use QuotedValueList.

<cfset myList = QuotedValueList(query.columnname)>

Related questions

Can I get a query row by index in ColdFusion?

I want to get a specific row in a ColdFusion Query object without looping over it. I'd like to do something like this: <cfquery name="QueryName" datasource="ds"> SELECT * FROM tablename </cfquery> <cfset x = QueryName[5]&…

Read More
ColdFusion inital value of currentrow when no index specified in cfloop

I am converting a ColdFusion application to C# (I'm a CF n00b). I have a script that performs a cfquery and then cfloop's through the results, and it appears to be trying to compare the current row to its …

Read More
How do I handle null values from ColdFusion queries?

If one of the columns in the returned coldfusion query result set has a NULL, how do we check if the value of this column being NULL? Should we just say <cfif queryname.columnname[i] EQ ''> OR &…

Read More