I'm impressed with CFMX's XML features (although I think Macromedia missed a trick in not providing a dbtype = "xml" option for CFQUERY). I've rewritten my CF_XMLQUERY tag using CFMX's native XML functions: it's attached, along with a demonstration page, to this email.
Tom -----------------+ tom dyson t: +44 (0)1608 811870 m: +44 (0)7958 752657 http://torchbox.com > Has anyone looked into CFMX's use of XML? How well does CFMX perform > with XML? > > Thanks - > > Tom Schreck > 817-252-4900 > [EMAIL PROTECTED]
xmlq.cfm
Description: Binary data
<cfset myxml = '
<article_xml>
<person age = "28" gender = "male">tom<color>blue</color></person>
<person age = "28" gender = "female" color = "red">sofia</person>
<person age = "27" gender = "female">jane</person>
</article_xml>'>
<cfoutput><strong>myxml:</strong>#replace(xmlformat(myxml),chr(10),'<br>','all')#<hr>
<strong>xpath:</strong> article_xml/person</cfoutput><hr>
<cf_xmlq name = "xmlq" xpath = "article_xml/person" xml = "#myxml#">
<strong>Query results:</strong><hr>
<cfoutput query = "xmlq">
person: #person# <br>
age: #person_age# <br>
gender: #person_gender# <br>
colour: #person_color#<hr>
</cfoutput>
