tracker issue : CF-4098246

It should've gone without saying that if you were implementing valueArray() then you also ought to have implemented quotedValueArray() at the same time, due to the analogy with valueList() / quotedValueList().

Vote by External U.

+1 - Thanks Nitin for filing this

Vote by External U.

I also really don't see harm in adding .valueList()/.quotedValueList(). Sometimes a list is all that's needed (i.e. if one is just outputting/writing the values as a string to somewhere instead of looping over them) and typing those would be shorter than chaining .valueArray().arrayToList(). If .valueList()/.quotedValueList() won't be added, then I'd deprecate valueList()/quotedValueList(). But if valueList()/quotedValueList() still have value (and I think they do if all one needs is a string), then .valueList()/.quotedValueList() should be added. Basically, I think it's best to have consistency and either support both or not support both. Thanks!, -Aaron

Comment by External U.

*bump* What about .valueList()/.quotedValueList()? valueList() and quotedValueList() are still useful when one only needs a string. Example: it's shorter than typing q.valueArray().arrayToList() and q.quotedValueArray().arrayToList(). Unnecessary typing. So these should also work: - valueList(query, "column") - q.valueList("column") - quotedValueList(query, "column") - q.quotedValueList("column") Thanks!, -Aaron

Comment by External U.

Regarding my previous post, I forgot about the delimiter parameter. Thus, the syntax would need to be (where delimiter parameter becomes a required parameter if columnName parameter exists): - valueList(query, columnName, delimiter) - q.valueList(columnName, delimiter) - quotedValueList(query, columnName, delimiter) - q.quotedValueList(columnName, delimiter) That is still shorter than typing q.valueArray(columnName).toList() (BTW, the .arrayToList(), in my previous comment, should've been .toList() - my bad) One use case for .valueList() is in a queryExecute() QoQ param. Example: {cfsqltype="cf_sql_integer", value=q1.valueList("id",","), list=true} that's shorter than (where getting as array, then converting to list, is unnecessary): {cfsqltype="cf_sql_integer", value=q1.valueArray("id").toList(), list=true} However.. it'd be even nicer if delimiter could be omitted when specifying column name. Thus, I guess I'll just wait until a language-clean-up version when we can change valueList()'s 1st parameter from "delimiter" to "columName". Thanks!, -Aaron

Comment by External U.

*bump*

Comment by Aaron N.