Replacing comma delimiters with single quotes.

[Guest]

Hi,

I need to replace all the occurences of comma delimter in my list (i.e, "one,two,three,four") with a single quote,

The output should be like this,

'one','two','three','four'

Can anybody shed some light here?

[Dan_Bracuk]

Use the ListQualify function. Details are in the cfml reference manual.

Unless you are going to use this list in a query, in which case the list attribute of cfqueryparam is a better approach.