|
|
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>
|
|