Instead of the Replace, don't forget you can use ListChangeDelims. /CFDOCS/CFML_Reference/Functions137.html#1107244
======================================================================= Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email : [EMAIL PROTECTED] Yahoo IM : morpheus "My ally is the Force, and a powerful ally it is." - Yoda > -----Original Message----- > From: cf refactoring [mailto:[EMAIL PROTECTED]] > Sent: Friday, November 02, 2001 9:32 AM > To: CF-Talk > Subject: RE: commas in lists > > > 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 > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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
