Actually, CF totally ignores "empty" list elements. So, if you're using listToArray(), you'd just use it like normal.
<cfset myString = "AB__BC_CD" /> <cfset myArr = listToArray(myString, "_") /> <cfdump var="#myArr#" /> you'd need to do a replace() function on the string first to replace > any instances of the delimiter appearing twice in succession with > something like a space. > > <cfset myString = "AB__BC_CD" /> > <cfset myString = replace(myString, '__', '_ _', 'all') /> > > > > On 3/9/07, Deepak Gupta <[EMAIL PROTECTED]> wrote: > > What if i have > > AB__BC_CD > > > > and instead of that blank after AB_ i want to replace this with a new > value when i update this in database. Using arrays it won't take it right? > > > > and when i make a check in my update statement for neq "" . it doesnt > work because it doesnt have any? > > > > do you have any suggestion then of storing these values and then looping > them, and finally updating in DB > > > > > > DG > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create Web Applications With ColdFusion MX7 & Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272257 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
