Parsing XML

[Wullie]

Hi all,

This is the first time I've ever needed to do anything with XML using Coldfusion and I'm getting a little stuck here.

The XML file I am parsing is the following: (This is a cut down version)

<?xml version="1.0" ?> 
   <Results>
     <ResultCode>0</ResultCode> 
     <ResultDescription>OK</ResultDescription> 
     <ResultData recordcount="1">
       <Record>
         <field name="AccountNumber">
           <value>TEST1</value> 
         </field>
         <field name="AccountType">
           <value>1</value> 
         </field>
         <field name="AccountStatus">
           <value>0</value> 
         </field>
       </Record>
     </ResultData>
   </Results>

Can anyone tell me the best way to parse this output? For example, let say I needed to return the value of AccountStatus.

I've tried a few ways and I always end up with strange errors or problems.

I'm using 6.1

Thanks in advance,

Wullie

 

[Wullie]

Hi all,

Just an update that I figured it out.

#mydoc.results.resultdata.record.field[1].value.XmlText#

Hope this helps,

Wullie

Fresh Look - Quality Coldfusion/Windows Hosting

The pessimist complains about the wind. The optimist expects it to change. The leader adjusts the sails. - John Maxwell

 

[TruthInSatire]

this is a great article, i refer to it when i'm stuck with CF and XML.

http://www.macromedia.com/devnet/mx/coldfusion/articles/xmlxslt.pdf

We've heard that a million monkeys at a million keyboards could produce the complete works of Shakespeare; now, thanks to the Internet, we know that is not true.