ColdFusion XmlParse() Error - Content Is Not Allowed In Prolog
Posted September 25, 2006 at 12:04 PM
I was working on an XML database this weekend and was stuck for a bit on an error getting thrown during an XmlParse() call. The error was:
Content is not allowed in prolog.
The original code was trying to take an XML document object, convert it into a string and then parse it into a ColdFusion query object (for testing). That's where the XmlParse() method call came into play.
Launch code in new window » Download code as text file »
- <!---
- Try to convert the xml object to an xml string then
- into a query object the using XmlToQuery() UDF.
- --->
- <cfset qData = XmlToQuery( xmlDoc.ToString() ) />
I thought it was a white space problem prior to the XML doctype. I have run into that problem before. I tried to Trim() the content before I sent it in, but that did not help. The issue, I finally worked out, was the "ToString()" method call. I was calling it incorrectly - I always do that! You can't call the method from the XML document object. You have to call it PASSING IN the Xml document:
Launch code in new window » Download code as text file »
- <!---
- Try to convert the xml object to an xml string then
- into a query object using the XmlToQuery() UDF.
- --->
- <cfset qData = XmlToQuery( ToString( xmlDoc ) ) />
I finally figured this out because dumping out xmlDoc.ToString() resulted in:
#document: null
... which obviously was NOT a string representation of the XML document object.
Download Code Snippet ZIP File
Post Comment | Ask Ben | Permalink | Other Searches | Print Page
Newer Post
Skin Spider : A Kinky Approach To Learning ColdFusion Application Development
Older Post
Project HUGE : Week One Complete
Reader Comments
Actually - this used to work fine in CF 6, but not anymore in CF 7: http://www.bloginblack.de/archives/000749.cfm
I am also having a problem with getting a [#document: null] when attempting to 'save' the xml document to disk -
When i cfdump the xml object it looks fine - (cfmx 7).
But after I do a xmldoc.ToString() on it - the text it saves is the [#document: null].
How can I convert the created XML doc to a String (I had to do some 'funky' things prior to saving this xml doc, like merging it etc - so maybe that would be the cause, but either way, it renders fine in cfdump but I can't get it back to it's String representation.
ideas?
Ah - ok - I dind't realize toString() could be used like that -
so I did this toString(myxmldoc) and all is good now -
Thanks!
Kevin,
Instead of doing XML.ToString()... rock ToString( XML ). Give that a try.
I realize that this is a posting from a *long* time ago (I added myself to the "use it or lose it" e-mail), but I have run across this error before also. It turned out to be a problem within a webservice that I was writing, but had nothing to do with the "tostring" or with any whitespace before the XML...it just was throwing an error within the code itself, and, because the error was being thrown, was appearing to CF as if there was whitespace before the XML. I guess it makes sense, but it would have been nice if the actual error was thrown also :)
That's good to know. I don't have much experience with Web Services, so it's good for me to know where possible errors are coming from. But I agree, some of the errors that ColdFusion throws are not exactly the most illuminating.
Im not using toString, but am getting the same error, occasionally. Thats right occasionally! My webservice works 99% of the time, then I get these odd errors. At first I contributed it to the feed coming back in error, but then my isXML check would have caught that. So as of now, Im stumped.
In my experiences working with XML, i find that every once in a while, no matter if we cdata nodes or not - some data we get from xml can have high ascii characters in them - which may bomb out at the parse level. The xml may parse just fine in Internet Explorer or Firefox, but when that same xml is given to cf to xmlparse, it will throw an error. Removing of the often hidden character or character that appears in notepad as a 'box' character often fixes the problem -
Kevin has a good point. In addition to that, make sure that you are using XmlFormat() even for the content that is inside of CDATA[]. You might have to unescape somethings afterwards, though. However, it might help you to narrow down where the problem is.
If its a high-ascii value, I was just blogging on the topic of stripping out ascii values:
http://www.bennadel.com/index.cfm?dax=blog:1155.view
This error can also be caused by the BOM (byte order mark) character in the XML feed. I blogged about it last time I encountered this problem: http://www.stillnetstudios.com/2007/07/09/coldfusion-xml-prolog-error
trim(), extra #, blah blah blah... didn't work but the below works for me:
in CF Admin >> setting >> enable white space management
take that back....not working my eyes cheated me, only partial better coz at least the xml showing properly now, but still getting that error.
okay, fixed... if you are developing and can get hold of the xml try creating an empty file with notepad called test.txt. Copy and paste the xml into this .txt and change it into .xml.
You will notice there is an extra 1 byte of code that you can't see that is causing this error.
I want to also add, that you can get this if you are doing a cfhttp request to a URL that you expect to return XML, but returns something like a 'Connection Failure' or some other invalid data.
I just ran into this - and depending on your environment, can be quite tricky to debug as it may be a network configuration thing and not a code issue at all.
@Kevin,
Good point, thanks.
