macromedia.coldfusion.database_access
[Top] [All Lists]

Data type stopping Coldfusion processing XML

Subject: Data type stopping Coldfusion processing XML
From: "Conners1" <webforumsuser@xxxxxxxxxxxxxx>
Date: Tue, 22 Jul 2008 14:25:38 +0000 (UTC)
Newsgroups: macromedia.coldfusion.database_access

Hi,

 I seem to have a problem with getting XML out of Coldfusion. I am using a 
access database, which I can get the XML out of directly. However when I run 
the query through coldfusion I get the following error.

 "An error occured while Parsing an XML document.  
 The reference to entity "C" must end with the ';' delimiter. "

 I have never seen this error before, I have had a look around the web and 
couldn't find any information and I am not sure where to start. I have narrowed 
it down to two fields in the database that have a datatype "memo" in the access 
database.

 I have detailed the coldfusion query below, and the XML nodes to help. The two 
node's I am having problems with are <RiskDes> and <Repsonsetxt>, both have a 
datatype of "memo" in the access database. If I take these two fields out of 
the query the request runs fine. 

 Do I have to do something different with the query with "memo" data types or 
am I barking up the worng tree? Any assistance would be greatly appreciated.

 XML detail:
 <tbl_risk_register>
 <RiskID>1</RiskID>
 <ProjectID>2</ProjectID>
 <RAIDTitle>a</RAIDTitle>
 <RiskDes>There is a risk that without a senior sponsor this project will not 
get the correct support within the business</RiskDes>
 <RiskImpact>High</RiskImpact>
 <RiskProbability>High</RiskProbability>
 <RiskServerity>High</RiskServerity>
 <Risk>High</Risk>
 <RAIDType>1</RAIDType>
 <Proximity>2006-09-19T00:00:00</Proximity>
 <Response>Prevention</Response>
 <Responsetxt>Establish a senior sponsor</Responsetxt>
 <Status>Open</Status>
 <Clientfacing>0</Clientfacing>
 </tbl_risk_register>


 Coldfusion CFC Query:
 <cfprocessingdirective suppresswhitespace="yes" pageencoding="utf-8">
  <cfquery name="allInfo" datasource="Projects">
     SELECT 
RiskID,ProjectID,RAIDTitle,RiskDes,RiskProbability,RiskServerity,Risk,RAIDType,P
roximity,Response,Status,Clientfacing
       FROM tbl_risk_register
   </cfquery>
   <cfxml variable="messageXML">
        <posters>
                <cfloop query="allInfo">
                  <cfoutput>
                    <posting>
                 <RiskID>#RiskID#</RiskID>
                                <ProjectID>#ProjectID#</ProjectID>
                                <RAIDTitle>#RAIDTitle#</RAIDTitle>
                                <RiskDes>#RiskDes#</RiskDes>
                                
<RiskProbability>#RiskProbability#</RiskProbability>
                                <RiskServerity>#RiskServerity#</RiskServerity>
                                <Risk>#Risk#</Risk>
                                <RAIDType>#RAIDType#</RAIDType>
                                <Proximity>#Proximity#</Proximity>
                                <Response>#Response#</Response>
                                <Status>#Status#</Status>
                                <Clientfacing>#Clientfacing#</Clientfacing>
                        </posting>
                  </cfoutput>
                </cfloop>
        </posters>  
   </cfxml>
   <cfoutput>#messageXML#</cfoutput>
 </cfprocessingdirective>


<Prev in Thread] Current Thread [Next in Thread>