Thank you.
-----Original Message-----
From: tom dyson [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 13, 2002 12:10 PM
To: [EMAIL PROTECTED]
Subject: Re: [cf-xml] CFXML question
Hi Tom
> So, should you use <cfxml> to make the xml document that's stored in
> the database available for processing? I've successfully stored the
> xml document in my database using <cfsavecontent>. Now, I'm further
> along in my application and need to interact with the xml document.
> The examples I've seen with <cfxml> show it working by reading the xml
> document as if it were stored in a file (using <cffile>) versus
> pulling the document from a table. I've tried this:
>
> <cfxml variable="xmlDocument">#qry_GetXML.xmlDocument#</cfxml>
>
> But I get an error message stating Document root element is missing.
> I know the xml document has a root element. I can paste the xml
> document into an xml validator and it checks out. Any insight would
> be helpful please.
>
> I've also tested the document using IsXMLDoc() and it returns No.
>
> Should the xml document that's stored in the database have the XML
> Declaration, or will <cfxml> tag add the declaration automatically?
You don't need the XML declaration - MX's XML functions only require
that the document be well-formed. But you do need to enclose your
variable name in <cfoutput> tags:
<cfxml variable="xmlDocument">#qry_GetXML.xmlDocument#</cfxml>
will fail, but
<cfxml variable="xmlDocument">
<cfoutput>#qry_GetXML.xmlDocument#</cfoutput>
</cfxml>
will work.
Alternatively, you could do:
<cfset xmlDocument = xmlparse(qry_GetXML.xmlDocument)>
which is a lot cleaner.
Best wishes
Tom
-----------------+
tom dyson
t: +44 (0)1608 811870
m: +44 (0)7958 752657
http://torchbox.com
-----------------------+
cf-xml mailing list
http://torchbox.com/xml/list.cfm
-----------------------+
cf-xml mailing list
http://torchbox.com/xml/list.cfm