replace(list_string,"||","| |","all")
At 05:46 AM 3/9/2007, Deepak Gupta wrote: >HI >I have this pipe delimited list >suppose A||C >Now the middle one is blank. How can i store this list so that i can track the >middle one as blank and later when i update the DB i can update this null as >something else in DB? > >ARray i guess wont work because they will consider this as 2 elements only >rather than 3 > >How i can approach this. > >Thanks >DG > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272155 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
