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
>
> >A one stop solution might be listToArray()
> >
> ><cfset stringAry = listToArray("aa_bb_cc","_")>
> >
> ><cfoutput>#stringAry[2]#</cfoutput>
> >--------------
> >Ian Skinner
> >Web Programmer
> >BloodSource
> >www.BloodSource.org
> >Sacramento, CA
> >
> >---------
> >| 1 | |
> >--------- Binary Sudoku
> >| | |
> >---------
> >
> >"C code. C code run. Run code run. Please!"
> >- Cynthia Dunning
> >
> >Confidentiality Notice: This message including any
> >attachments is for the sole use of the intended
> >recipient(s) and may contain confidential and privileged
> >information. Any unauthorized review, use, disclosure or
> >distribution is prohibited. If you are not the
> >intended recipient, please contact the sender and
> >delete any copies of this message.
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs
http://www.adobe.com/products/coldfusion/flex2/
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272176
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
