Ah.. it is an illegal character. OK. I used XMLFormat when the XML is created and stored in the database. Now when I parse it, it works.
Thanks for the help! -----Original Message----- From: Dominic Watson [mailto:[EMAIL PROTECTED] Sent: Monday, April 14, 2008 9:37 AM To: CF-Talk Subject: Re: & in my XML is causing error Try XmlFormat(). So: <cfset jobNoteXml = XmlParse( XmlFormat( getJobNotes.JobNote ) )> HTH Dominic On 14/04/2008, Chad Gray <[EMAIL PROTECTED]> wrote: > > I don't understand this error. Why is the & in my xml causing this > error? How do I escape the & in the xml so it will work? > > Error Info: > Message: An error occured while Parsing an XML document. > Detail: The entity name must immediately follow the '&' in the entity > reference. > > I am parsing the xml like this: > <cfset jobNoteXml = XmlParse(getJobNotes.JobNote)> > <cfset results = XmlSearch(jobNoteXml, "/JobNote/JobStep")> > <cfset localJID = results[1].JID.XmlText> > <cfset localDept = results[1].Dept.XmlText> > <cfset localDetails = results[1].Details.XmlText> > > Here is the XML: > <?xml version="1.0" encoding="UTF-8"?> > <JobNote> > <JobStep> > <JID>44207</JID> > <Dept>Desktop Editors</Dept> > <Details>EDITED, DISTORTED, MADE LASERS. MK LOOKED AT LASER & IS > MAKING 1 QUICK COLOR FIX.</Details> > </JobStep> > </JobNote> > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303294 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
