XML Parsing

[ctlcal]

I am having no luck in Coldfusion in getting to the values of PID and ID in the following returned XML file. Any suggestions?

<cfxml variable="test">

<diffgr:diffgram xmlns:diffgr="urn:schemas-microsoft-com:xml-diffgram-v1" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">

<ProjectDataset xmlns=" http://tempuri.org/ProjectDataset.xsd">
<Project diffgr:id="Project1" msdata:rowOrder="0">
<PID>1234</PID>
<ID>1234</ID>
</Project>
</ProjectDataset>
</diffgr:diffgram>

</cfxml>

Thanks in advance...

[Newsgroup_User · Accepted solution]

<cfoutput>
#test['diffgr:diffgram']['ProjectDataset']['Project']['PID']['XMLText']#
#test['diffgr:diffgram']['ProjectDataset']['Project']['ID']['XMLText']#
</cfoutput>

<cfdump var="#test#" format="html">

This should get you started.

[ctlcal]

Thanks - that is exactly what I needed.

[Stressed_Simon]

Easy:-

[Newsgroup_User]

Stressed_Simon wrote:
> ...
> <cfset xTest = xmlParse(trim(test))>

I'll point out that xmlParse() is unnecessary here, since the <cfxml...>
tag already creates an xml object in ColdFusion.

It would be use if one was converting an XML string into an xml object.

[Stressed_Simon]

Good point. Only half read it!