Try this strategy: // default delimiter is a comma cfset myDelimiter="," //if If Find(yourList,'","') // replace "," by an unprintable character yourList = Replace(yourList,'","',CHR(7)) // Remove opening and closing " Replace(yourList,'"',"") // Change your delimiter to CHR(7) cfset myDelimiter=CHR(7) end if
Now pass in myDelimiter along with your list whenever you use CF's list manipulation functions P.S. I don't feel that this is a particular deficiency of CF. I think making it "smart" enough to not ignore quotes would be a bad thing. You just have to deal with it properly. > > > Well, this didn't work. CF ignors the quotes > and treats all > > > commas it finds as delimiters > > > > > > Any ideas how I can allow a comma in the list? > > > > CF is "stupid" about commas in lists, so, here's > an idea... > > > > put ", in front of the list ," at the end and use > "," as the delimiter > ===== I-Lin Kuo Macromedia CF5 Advanced Developer Sun Certified Java 2 Programmer ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
