> Maybe someone can help me. > I have a field that a customer fills out which is a comma delimited list. > Ex: wide,very deep,too easy,rugby > > This is fine, however, if the customer wants to put a comma in > the text, it > screws up list functions and list loops. Notice the , between very > and deep. > Ex: wide,very, deep,too easy,rugby > So, I say to him, if want to put commans in there, you have to quote the > text. > Ex: "wide","very, deep","too easy","rugby" > OR 'wide','very, deep','too easy','rugby' > > 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 The problem with this is that you may have to read through it yourself and not use a list function - maybe treat it as an array... Or, why use a comma as the delimiter - use a pipe instead (|), that way you can put whatever you want into the entries Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ********************************************************************** ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 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
