Comma-Space as delimiter
When working with Lists, I'm finding that you can't specify a delimiter of comma-space (, ). CF is treating this as , OR . How do I tell it to delimit as comma-space? The ListAppend function in the Reference states you can use , CHR(32) in the delimiter parameter but it doesn't work. -- Bruce Holm Web Developer Lattice Semiconductor [EMAIL PROTECTED] -- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: Comma-Space as delimiter
You can't. You must use replace() to replace the comma/space with a single character that you can use as the delimiter. The bell character works well since it can't be typed (chr(7)). +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Bruce Holm [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 10:45 AM To: CF-Talk Subject: Comma-Space as delimiter When working with Lists, I'm finding that you can't specify a delimiter of comma-space (, ). CF is treating this as , OR . How do I tell it to delimit as comma-space? The ListAppend function in the Reference states you can use , CHR(32) in the delimiter parameter but it doesn't work. -- Bruce Holm Web Developer Lattice Semiconductor [EMAIL PROTECTED] -- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Re: Comma-Space as delimiter
sub-optimal but Replace(String,', ',chr(07),'all') would leave you a bell delimited list... How do I tell it to delimit as comma-space? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Comma-Space as delimiter
Thanks for the help! Bruce Holm -Original Message- From: Joseph Thompson [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 10:58 AM To: CF-Talk Subject: Re: Comma-Space as delimiter sub-optimal but Replace(String,', ',chr(07),'all') would leave you a bell delimited list... How do I tell it to delimit as comma-space? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com