Get XML values according to given xPath query
xmlSearch(xmlNode, xpath [, params])
→ returns array
XPath extracts 'name' property from every user given in the XML collection
<cfsavecontent variable="xmlstring">
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<users>
<user id="1">
<name>Me</name>
</user>
<user id="2">
<name>You</name>
<address>
<street>Long Road</street>
</address>
</user>
</users>
</cfsavecontent>
<cfscript>
xml = XMLParse(xmlstring);
result = xmlSearch(xml,'users//name');
userlist = '';
for(i = 1; i <= ArrayLen(result); i++) {
userlist = ListAppend(userlist,result[i].XmlText);
}
writeOutput(userlist);
</cfscript>
Expected Result: Me,You
Signup for cfbreak
to stay updated on the latest news from the ColdFusion / CFML community. One email, every friday.