CF 5.0 & XML

[aitai]

Hi, All

I am programming in Coldfusion 5.

I need to get the xml information in the attached file into Coldfusion for minipulation (display and
database input). The file is an .asp file that is fetched from a remote location with the <CFHTTP> tag. The elements (and their corresponding

values) that I want to work with are 'call_date_time_k' and 'answered_duration' (right click and view page source).

I have searched numerous forums and tried numerous custom tags without any success.

I would very much appreciate it if someone has insight to this problem, and can give me detailed instructions on how to achieve this goal with

the least amount of pain!

Our technical solution: CF 5.0, IIS 5, WIN2k Advanced Server.

Thank you.

PS the attached sample file is the saved version of the actual .asp file we will be using. I have removed the sensitive information in the first 2 lines of the xml document.

<-------- sample file------->
<xml xmlns:s=''
xmlns:dt=''
xmlns:rs='urn:schemas-microsoft-com:rowset'
xmlns:z='#RowsetSchema'>
<s:Schema id='RowsetSchema'>
<s:ElementType name='row' content='eltOnly'>
<s:AttributeType name='call_date_time_k' rs:number='1'
rs:writeunknown='true'>
<s:datatype dt:type='dateTime' rs:dbtype='timestamp'
dt:maxLength='16' rs:scale='0' rsrecision='19' rs:fixedlength='true'
rs:maybenull='false'/>
</s:AttributeType>
<s:AttributeType name='answered_duration' rs:number='2'
rs:nullable='true' rs:writeunknown='true'>
<s:datatype dt:type='int' dt:maxLength='4' rsrecision='10'
rs:fixedlength='true'/>
</s:AttributeType>
<s:extends type='rs:rowbase'/>
</s:ElementType>
</s:Schema>
<rs:data>
<z:row call_date_time_k='2002-06-15T12:18:48' answered_duration='220'/>
<z:row call_date_time_k='2002-06-15T12:16:46' answered_duration='366'/>
<z:row call_date_time_k='2002-06-15T12:10:14' answered_duration='9'/>
<z:row call_date_time_k='2002-06-15T12:09:52' answered_duration='151'/>
<z:row call_date_time_k='2002-06-15T12:06:58' answered_duration='143'/>
<z:row call_date_time_k='2002-06-15T12:06:36' answered_duration='187'/>
<z:row call_date_time_k='2002-06-15T12:06:36' answered_duration='13'/>
<z:row call_date_time_k='2002-06-15T12:03:24' answered_duration='85'/>
<z:row call_date_time_k='2002-06-15T12:01:32' answered_duration='279'/>
<z:row call_date_time_k='2002-06-15T12:00:12' answered_duration='185'/>
</rs:data>
</xml>

 

[csteinhilber]

What didn't work with the custom tags that you found?

devex.macromedia.com has several XML parsing tags. There's at least one that's generic enough were you should be able to get at the attributes you're after. I used one for something similar.

Of course... the other thing you could do is move to CF MX ;-) Working with XML in MX is a varitable breeze.