Hello and thanks for your time (again),
I have an XML file (at least it looks like one) with a whole lot of additional stuff within the syntax which I assume it put there because it is being returned via SOAP. I am trying to figure out how to traverse this xml file to extract the data. I have parsed using xmlParse() to get it down to the XML Document Object structure. I'm not used to targeting the nodes in this manner. Is it as simple as using dot syntax to drill down to the area I need? Every node is called "data". How do I target a node that has the same tag name as every other node?
Check it out...(small snippet)
CODE
<?xml version="1.0" encoding="UTF-8"?>
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<soapenv:Body>
<ns1:getSubordinatesResponse soapenv:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" xmlns:ns1="ocrs">
<getSubordinatesReturn xmlns:ns2="http://rpc.xml.coldfusion" xsi:type="ns2:QueryBean">
<columnList soapenc:arrayType="xsd:string[3]" xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/" xsi:type="soapenc:Array">
<columnList xsi:type="xsd:string">ID</columnList>
<columnList xsi:type="xsd:string">CMD_TYPE</columnList>
<columnList xsi:type="xsd:string">PLA</columnList>
</columnList>
<data soapenc:arrayType="xsd:anyType[][17]" xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/" xsi:type="soapenc:Array">
<data soapenc:arrayType="xsd:anyType[3]" xsi:type="soapenc:Array">
<data xsi:type="soapenc:int">1182</data>
<data xsi:type="soapenc:int">1</data>
<data xsi:type="soapenc:string">NAVMEDINFOMGTCEN BETHESDA MD</data>
</data>
<data soapenc:arrayType="xsd:anyType[3]" xsi:type="soapenc:Array">
<data xsi:type="soapenc:int">1183</data>
<data xsi:type="soapenc:int">1</data>
<data xsi:type="soapenc:string">NAVMEDLOGCOM FT DETRICK MD</data>
</data>
<data soapenc:arrayType="xsd:anyType[3]" xsi:type="soapenc:Array">
<data xsi:type="soapenc:int">1185</data>
<data xsi:type="soapenc:int">1</data>
<data xsi:type="soapenc:string">NAVMEDSUPPCOM JACKSONVILLE FL</data>
</data>
<data soapenc:arrayType="xsd:anyType[3]" xsi:type="soapenc:Array">
<data xsi:type="soapenc:int">1186</data>
<data xsi:type="soapenc:int">1</data>
<data xsi:type="soapenc:string">NAVMED EAST PORTSMOUTH VA</data>
</data>
</data>
</getSubordinatesReturn>
</ns1:getSubordinatesResponse>
</soapenv:Body>
</soapenv:Envelope>
I was able to do the following...
CODE
<!--- Read the file and convert it to an XML document object --->
<cfset myDoc=XMLParse("http://localhost:8500/practice/xml/ncdb/ncdb.xml", false)>
<!--- get an array of commands --->
<cfset id = myDoc.XmlRoot.XmlChildren[1].XmlChildren[1].XmlChildren[1].XmlChildren[2].XmlChildren>
<cfdump var="#id#">
<cfset size = ArrayLen(id)>
<cfoutput>
Number of Commands = #size#
<br>
</cfoutput>
<br>
<!--- create a query object with the command data --->
<cfset myquery = QueryNew("id") >
<cfset temp = QueryAddRow(myquery, #size#)>
<cfloop index="i" from = "1" to = #size#>
<cfset temp = QuerySetCell(myquery, "id",
#myDoc.XmlRoot.XmlChildren[1].XmlChildren[1].XmlChildren[1].XmlChildren[2].XmlChildren[i]#, #i#)>
</cfloop>
<!--- Dump the query object --->
Contents of the NCDB Query object: <br>
<cfdump var=#myquery#>
<br><br>
Display entire query
<cfquery name="ncdbTest" dbType="query">
SELECT *
FROM myquery
</cfquery>
<!--- Dump the query results --->
<cfdump var=#ncdbTest#>
But this just gets all of the data. I want to be able to manipulate different pieces of the data individually. Thanks for an info!
This post has been edited by midasxl: 5 May, 2009 - 10:39 AM
Forum Index:
Programming Help |
C and C++ |
VB6 |
Java |
VB.NET |
C# |
ASP.NET |
PHP |
ColdFusion |
Perl and Python |
Ruby |
Databases |
Other Languages |
Game Programming |
Mobile Development |
Software Development |
Computer Science |
Industry News |
Programming Tutorials |
C++ Tutorials |
Visual Basic Tutorials |
Java Tutorials |
VB.NET Tutorials |
C# Tutorials |
Linux Tutorials |
PHP Tutorials |
ColdFusion Tutorials |
Windows Tutorials |
HTML/JavaScript Tutorials |
CSS Tutorials |
Flash Tutorials |
Web Promotion Tutorials |
Graphic Design & Photoshop Tutorials |
Software Development Tutorials |
Database Tutorials |
Other Language Tutorials |
ASP.NET Tutorials |
Game Programming Tutorials |
WPF & Silverlight Tutorials |
5 May, 2009 - 10:38 AM
| 
