Fetch attribute value from xml

[amitkeshari]

Hi

I require to fetch a value from xml with asp.

my xml data is as

<R N="1">
<U>http://www.solgar.co.uk/</U>
<UE>http://www.solgar.co.uk/</UE>
<T>Vitamins from Solgar Vitamin Supplements and Mineral Supplements <b>...</b></T>
<RK>0</RK>
<S>Vitamins from Solgar : Discount vitamin supplements from our online vitamin <br> store, including <b>amino</b> acids, vitamin b, vitamin c, vitamin e, <b>...</b></S>
<LANG>en</LANG>
<Label>_cse_x0qmgd4mgeu</Label>
<HAS>
<L />
<C SZ="46k" CID="-eDyAtQ5j8EJ" />
<RT />
</HAS>
</R>
<RG START="2" SIZE="1" />
<R N="2">
<U>https://www.solgar.co.uk/product/l-ornithine-500mg-50-capsules-E2060.html</U>
<UE>https://www.solgar.co.uk/product/l-ornithine-500mg-50-capsules-E2060.html</UE>
<T>L-Ornithine 500mg: 50 Capsules - <b>Amino</b> Acids - Solgar <b>Amino</b> Acids <b>...</b></T>
<RK>0</RK>
<S>L-Ornithine 500mg: 50 Capsules - LOrnithine 500 mg Vegicaps (Free Form) SUGAR, <br> SALT AND STARCH FREE · SUITABLE FOR VEGANSSolgar LOrnithine 500mg.</S>
<LANG>en</LANG>
<PageMap>
<DataObject type="image">
<Attribute name="image_src" value="http://www.solgar.co.uk/modules/shop/images/LORNITHI.jpg" />
</DataObject>
<DataObject type="publication">
<Attribute name="price" value="£12.86" />
</DataObject>
</PageMap>
<HAS>
<L />
<C SZ="28k" CID="kczLO08HM1AJ" />
<RT />
</HAS>
</R>


ASP Script:

xPath = "//RES/R"
set result = xmlDocument.selectNodes(xPath)
for each record in result
link = record.selectSingleNode("U").text
desc = record.selectSingleNode("S").text
set image = record.selectSingleNode("PageMap").childNodes(0).a ttributes.getNamedItem("image_src").nodeValue

Here with this script i am able to fetch value of <U> and <S>. But also i need to fetch value of image_src and price which is in <DataObject> of <PageMap>

Help is really required

[jhardman]

I was just thinking about this, and I don't know of a way to do that using standard XML controls. If you could get to the text of the xml you could access the properties using regular expressions.

Jared