XPATH won't query through element?

EDN Admin

EDN Admin

Well-known member
Joined
Aug 7, 2010
Messages
12,794
Location
In the Machine
What is the XPATH expression to get the <DESCRIPTION> node from the following XML?
<div style="color:Black;background-color:White; <pre>
<span style="color:Blue; <<span style="color:#A31515; DiscoverResponse <span style="color:Red; xmlns<span style="color:Blue; =<span style="color:Black; "<span style="color:Blue; urn:schemas-microsoft-com:xml-analysis<span style="color:Black; " <span style="color:Red; xmlns:ddl2<span style="color:Blue; =<span style="color:Black; "<span style="color:Blue; http://schemas.microsoft.com/analysisservices/2003/engine/2<span style="color:Black; " <span style="color:Red; xmlns:ddl2_2<span style="color:Blue; =<span style="color:Black; "<span style="color:Blue; http://schemas.microsoft.com/analysisservices/2003/engine/2/2<span style="color:Black; "<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; return<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; root <span style="color:Red; xmlns<span style="color:Blue; =<span style="color:Black; "<span style="color:Blue; urn:schemas-microsoft-com:xml-analysis:rowset<span style="color:Black; " <span style="color:Red; xmlns:xsi<span style="color:Blue; =<span style="color:Black; "<span style="color:Blue; http://www.w3.org/2001/XMLSchema-instance<span style="color:Black; " <span style="color:Red; xmlns:xsd<span style="color:Blue; =<span style="color:Black; "<span style="color:Blue; http://www.w3.org/2001/XMLSchema<span style="color:Black; "<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; xsd<span style="color:Blue; :<span style="color:#A31515; schema<span style="color:Blue; >...<span style="color:Blue; </<span style="color:#A31515; xsd<span style="color:Blue; :<span style="color:#A31515; schema<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; row<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; CATALOG_NAME<span style="color:Blue; >C as2k5 new<span style="color:Blue; </<span style="color:#A31515; CATALOG_NAME<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; CUBE_NAME<span style="color:Blue; >C<span style="color:Blue; </<span style="color:#A31515; CUBE_NAME<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; CUBE_TYPE<span style="color:Blue; >CUBE<span style="color:Blue; </<span style="color:#A31515; CUBE_TYPE<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; LAST_SCHEMA_UPDATE<span style="color:Blue; >2010-12-31T17:44:06<span style="color:Blue; </<span style="color:#A31515; LAST_SCHEMA_UPDATE<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; LAST_DATA_UPDATE<span style="color:Blue; >2010-12-31T17:44:06<span style="color:Blue; </<span style="color:#A31515; LAST_DATA_UPDATE<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; DESCRIPTION<span style="color:Blue; >This is a new new test description<span style="color:Blue; </<span style="color:#A31515; DESCRIPTION<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; IS_DRILLTHROUGH_ENABLED<span style="color:Blue; >true<span style="color:Blue; </<span style="color:#A31515; IS_DRILLTHROUGH_ENABLED<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; IS_LINKABLE<span style="color:Blue; >true<span style="color:Blue; </<span style="color:#A31515; IS_LINKABLE<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; IS_WRITE_ENABLED<span style="color:Blue; >false<span style="color:Blue; </<span style="color:#A31515; IS_WRITE_ENABLED<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; IS_SQL_ENABLED<span style="color:Blue; >true<span style="color:Blue; </<span style="color:#A31515; IS_SQL_ENABLED<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; CUBE_CAPTION<span style="color:Blue; >C<span style="color:Blue; </<span style="color:#A31515; CUBE_CAPTION<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; CUBE_SOURCE<span style="color:Blue; >1<span style="color:Blue; </<span style="color:#A31515; CUBE_SOURCE<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; row<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; root<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; return<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; DiscoverResponse<span style="color:Blue; >
[/code]
Ive tried "DiscoverResponse/return/root/row/DESCRIPTION" but I dont get any results.


View the full article
 
Back
Top