Hi
I am using this script to fetch value with xml. With this script i am able to find link and desc but also i want to find out image_src and price from the xml. But i am helpless for this two. Below is the script i am using.
set xmlDocument = getXml("aminofile.xml")
xPath = "//RES/R"
set result = xmlDocument.selectNodes(xPath)
for each record in result
link = record.selectSingleNode("U").text
desc = record.selectSingleNode("S").text
imgage = record.selectSingleNode("PAGEMAP").childNodes(1).a ttributes.getNamedItem("IMAGE_SRC").nodeValue
response.write "<tr><td width='300'>"& link & "</td>"
response.write "<td width='300'>"& desc & "</td></tr>"
response.write imgage
next
and the xml is
<R N="5">
<U>
http://www.solgar.co.uk/modules/catb...minoAcids.html
</U>
<UE>
http://www.solgar.co.uk/modules/catb...minoAcids.html
</UE>
−
<T>
Solgar <b>Amino</b> Acids - Solgar Vitamins Health Store
</T>
<RK>0</RK>
−
<S>
<b>Amino</b> 75 30 Capsules 75 <b>amino</b> acid solgar, <b>amino</b>, <b>amino</b> acid Balanced free-form <br> <b>amino</b> acid formula, containing essential <b>amino</b> acids SUGAR, SALT AND STARCH <b>...</b>
</S>
<LANG>en</LANG>
<Label>_cse_x0qmgd4mgeu</Label>
−
<HAS>
<L/>
<C SZ="26k" CID="1tJ11047rU8J"/>
<RT/>
</HAS>
</R>
<RG START="6" SIZE="1"/>
−
<R N="6">
−
<U>
https://www.solgar.co.uk/modules/sho...?prodcode=E162
</U>
−
<UE>
https://www.solgar.co.uk/modules/sho...rodcode%3DE162
</UE>
−
<T>
ArginineOrnithine 250 Vegicaps Discontinued by Solgar <b>Amino</b> Acids <b>...</b>
</T>
<RK>0</RK>
−
<S>
Arginine-Ornithine 250 Vegicaps - Discontinued by Solgar - LArginineLOrnithine <br> 500250 mg Vegicaps (Free Form)SUGAR, SALT AND STARCH FREE SUITABLE FOR <b>...</b>
</S>
<LANG>en</LANG>
<Label>_cse_x0qmgd4mgeu</Label>
−
<PageMap>
−
<DataObject type="image">
<Attribute name="image_src" value="http://www.solgar.co.uk//modules/shop/images/LARGINI1.jpg"/>
</DataObject>
−
<DataObject type="publication">
<Attribute name="price" value="48.05"/>
</DataObject>
</PageMap>
−
<HAS>
<L/>
<C SZ="28k" CID="yuhb8N-q7MgJ"/>
<RT/>
</HAS>
</R>