Question
Data type stopping Coldfusion processing XML
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.
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.
AdChoices