Published:
Warning: This blog entry was written two or more years ago. Therefore, it may contain broken links, out-dated or misleading content, or information that is just plain wrong. Please read on with caution.
A few weeks ago I needed to modify a list to wrap each list element with single quotes. Normally you would do this when outputting the data in a view but in this case that was not an option.
I was about to write a function to to this when I decided to take a chance that someone had already written this for me. A quick google later and I discovered that ColdFusion has a builtin function for exactly this purpose named "listQualify()".
Example
unqualifiedList = "dog,cat,bird,pig";
qualifiedList = listQualify(unqualifiedList, "'");
unqualifiedList: dog,cat,bird,pig
qualifiedList: 'dog','cat','bird','pig'
It seems even after all these years I am still learning new things about cfml.
Reader Comments
Friday, May 15, 2015 at 7:45:57 AM Coordinated Universal Time
how to insert multiple rows into single sql server
Wednesday, July 13, 2022 at 2:40:06 PM Coordinated Universal Time
7 years later and still relevant. Thank you Steve for writing this short and sweet post :)