How do I output result of a query as double-quoted...
# cfml-beginners
e
How do I output result of a query as double-quoted comma-delimited list? I've tried <cfset myList = QuotedValueList(getDiv.style_id)>, but it shows single-quoted list
c
Wrap that with a
Replace()
or
ReplaceNoCase()
. Here's an example: https://www.trycf.com/gist/9ea2bed29fd022d38e8a68b6893b5011/acf2018?theme=monokai
a
Or use
listQualify
:
Copy code
doubleQuotedColumnValues = valueList(myQuery.myCoolColumn).listQualify('"')
https://cfdocs.org/listqualify
e
Thank you both
c
Oooh, I forgot about
listQualify()
. Nice!