![]() |
![]() | ![]() | ![]() | Altova Mailing List Archives>Archive Index >microsoft.public.xml Archive Home >Recent entries >Thread Prev - selectNodes - How form query to get required data >Thread Next - Re: selectNodes - How form query to get required data Re: selectNodes - How form query to get required dataTo: NULL Date: 8/8/2007 4:12:00 PM
brian_harris wrote:
> This is an example of what XML data looks likes:
> <?xml version="1.0" ?>
> <headerDISCREPTABTYP xmlns:dt="urn:schemas-microsoft-com:datatypes">
> <DISCREPTABTYP heading="UNKNOWN" description="UNKNOWN EMPLOYEES IN UNIT" >
> <discrepancytype> <![CDATA[ UNKNOWN ]]> </discrepancytype>
> <empcode> <![CDATA[ 62009 ]]> </empcode>
> <startscan> <![CDATA[ 02/10/2006 09:24:16 am ]]> </startscan>
> </DISCREPTABTYP>
> <DISCREPTABTYP heading="BELONG" description="EMPLOYEES WHO BELONG AND ARE
> WORKING IN UNIT" >
> <discrepancytype> <![CDATA[ BELONG ]]> </discrepancytype>
> <empcode> <![CDATA[ 114351 ]]> </empcode>
> <startscan> <![CDATA[ 02/06/2006 08:56:01 am ]]> </startscan>
> </DISCREPTABTYP>
> <DISCREPTABTYP heading="BELONG" description="EMPLOYEES WHO BELONG AND ARE
> WORKING IN UNIT" >
> <discrepancytype> <![CDATA[ BELONG ]]>
> </discrepancytype>
> <empcode> <![CDATA[ 114351 ]]> </empcode>
> <startscan> <![CDATA[ 02/07/2006 08:34:21 am ]]> </startscan>
> </DISCREPTABTYP>
> <DISCREPTABTYP heading="BELONG" description="EMPLOYEES WHO BELONG AND ARE
> WORKING IN UNIT" >
> <discrepancytype> <![CDATA[ BELONG ]]> </discrepancytype>
> <empcode> <![CDATA[ 189191 ]]> </empcode>
> <startscan> <![CDATA[ ]]> </startscan>
> </DISCREPTABTYP>
> <DISCREPTABTYP heading="FLOATOUT" description="EMPLOYEES FLOAT OUT OF
> UNIT" >
> <discrepancytype> <![CDATA[ FLOATOUT ]]> </discrepancytype>
> <empcode> <![CDATA[ 114351 ]]> </empcode>
> <startscan> <![CDATA[ 02/10/2006 09:24:16 am ]]> </startscan>
> </DISCREPTABTYP>
> </headerDISCREPTABTYP>
Here is a sample with JScript using MSXML 3:
var xmlDocument = new ActiveXObject('Msxml2.DOMDocument.3.0');
xmlDocument.async = false;
if (xmlDocument.load('test2007080802.xml')) {
xmlDocument.setProperty('SelectionLanguage', 'XPath');
var nodes =
xmlDocument.selectNodes('headerDISCREPTABTYP/DISCREPTABTYP[contains(discrepancytype,
"BELONG") and contains(empcode, "114351")]');
alert('Found ' + nodes.length + ' node(s).');
}
else {
alert(xmlDocument.parseError.reason);
}
For your XML input the alert shows that two nodes are being found.
--
Martin Honnen --- MVP XML
http://JavaScript.FAQTs.com/
| ![]() | ![]() | ![]() |
| Company | Legal | Press | Partners | Careers | Sitemap | Contact Us | Altova Blog | |||
|
