Re: XML stored in a field

[Michael Grant]

Since it's XML you'll notice that left angle brackets are stored as "<"
and right angle brackets are stored as ">" etc. You'll need to do a
replace on the string to get this to show as proper HTML.

Eg: Replace("&lt;","<","ALL") etc.

I'm no good with regex but I bet there's a much more elegant way than a
bunch of Replace statements.

On Mon, Jan 26, 2009 at 1:23 PM, Erika L. Walker <elwal...@ruwebby.com>wrote:

> since you said I could. :)
>
>
> Here's the sample of the content xml field:
>
> <content><![CDATA[&lt;p&gt;The government has released a video from the
> health service citizen's jury on 18 September 2007. The video features an
> address from&amp;nbsp;Gordon Brown.&lt;/p&gt;
> &lt;p&gt;A&amp;nbsp;thousand citizens, patients, doctors and nurses
> met&amp;nbsp;in Birmingham to discuss the future of the health service.
> &lt;/p&gt;]]></content>
>
>
> I've imported that into my MSSQL table, then when outputting, I actually
> need to have the HTML work the way it's supposed to and not display this on
> the page:
>
> <p>The cleanyourhands campaign in NHS hospitals in England and Wales is
> currently&nbsp;beginning the first phase of the campaign&rsquo;s rollout to
> other health and social care settings. </p> <p>The campaign&rsquo;s
> extension&nbsp;is&nbsp;into primary care, ambulance, mental health and care
> trusts as well as care homes and hospices in England and Wales. <br /><br
> />Nineteen &lsquo;pioneer&rsquo; organisations have been selected to
> represent the mix of different healthcare settings and test the campaign
> prior to wider roll-out in early 2008. Work is also underway to test the
> campaign in general practice. </p> <p><em><a href="
> http://www.npsa.nhs.uk/cleanyourhands";><u><font
> color="#800080">Source:&nbsp;&nbsp; Clean Your
> Hands</font></u></a></em></p>
>
>
> I assume I am missing a step ... of course. :)
>
>
> Thank you!
>
>
>
> On Mon, Jan 26, 2009 at 12:40 PM, Michael Grant <mgr...@modus.bz> wrote:
>
> > No problem. Any time!
> >
> >
>
>
> 

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-community/message.cfm/messageid:286700
Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.5