reading an xml document in coldfusion

<!--- Covert to XML document object --->
<cfxml variable="xmlDoc"><?xml version="1.0" encoding="utf-8"?>
      <DataSet xmlns="http://tempuri.org/">
      <xs:schema id="NewDataSet" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
         <xs:element name="NewDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true">
            <xs:complexType>
                <xs:choice minOccurs="0" maxOccurs="unbounded">
                   <xs:element name="Table">
                       <xs:complexType>
                          <xs:sequence>
                             <xs:element name="DDOTDirector" type="xs:string" minOccurs="0" />
                          </xs:sequence>
                        </xs:complexType>
</xs:element>
</xs:choice>
</xs:complexType>
</xs:element>
</xs:schema>
</DataSet></cfxml>

<!--- Match the element whose name is 'element' and which has a type attribute whose value is 'xs:string'--->
<cfset elementArray=xmlSearch(xmlDoc, "//*[local-name() = 'element' and @type='xs:string']")>

<!--- <cfdump var="#elementArray#"> --->

<!--- Match the value of the attribute called 'name' --->
<cfoutput>#elementArray[1].xmlAttributes["name"]#</cfoutput>

I have had problems in the past with ColdFusion and processing XML data, I was required to create a webservice that communicated data in an XML format and it was frustrating at first but then when I had it working I was very happy.

Usually the first thing you do with XML data in ColdFusion is to use the function XMLPARSE.

However, this function will error when there are leading and following empty spaces or new lines before and after the XML data. To get rid of these you can use the TRIM function with the XMLPARSE function and that often cleans up the errors fairly well.

In this case, you can spend lots of aggravating time trying to determine what the problem is with your XML data, but using the TRIM function like the following can help.

For example:

<cfset XMLDATA = Some XML Data>

<cfset XMLOBJECT = XmlParse(Trim(XMLDATA))>

Hope this helps with your issues, let the forum know if you are able to solve your issue.

Michael G. Workman

michael.g.workman@gmail.com

Well come on... what have you tried so far?  We're here to help you with yor code, not write it for you!

--

Adam