Here's one way you could do it: <cfset myXML = XMLParse(theData)> <cfoutput>#myXML.data.content.xmlText#</cfoutput>
On Mon, Jan 26, 2009 at 9:54 AM, Erika L. Walker <[email protected]>wrote: > Hey guys ... looking for a quickie. > > I've got an XML record stored in a field. I need to pull in some info from > the nodes. > Before I waste time playing - in CFMX7, can I use XMLParse() to get to each > entry in the entry? > > Sample entry in the field: > > <data><title><![CDATA[How explaining properly saves NHS > > cash]]></title><url><![CDATA[]]></url><news_date><![CDATA[1188284400]]></news_date><archive_date><![CDATA[1190962800]]></archive_date><content><![CDATA[<p>A > BBC news story about how Tower Hamlets PCT reduced A&amp;E admissions > by > talking to local residents. Click <a target="_blank" > href=" > http://news.bbc.co.uk/1/hi/health/6895792.stm">here</a> for > more.</p> > <p>&nbsp;</p>]]></content><pagetitle><![CDATA[How > explaining > properly saves NHS cash]]></pagetitle><keywords><![CDATA[NHS, GP, > A&E]]></keywords><description><![CDATA[How explaining properly saves > NHS > cash]]></description></data> > > I particularly need what's stored for <content>. > > Thanks! > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:286650 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
