Trabalhando com XML

[Anderson Nunes 0]

Tenho este xml.

 

 <product id="1857679301" categoryId="3482" totalSellers="19" fullDescription="false">
  <productName>Indomada - P. C.Cast (8576793016)</productName> 
  <currency abbreviation="BRL" /> 
  <priceMin>9.90</priceMin> 
  <priceMax>39.90</priceMax> 
- <links>
  <link type="product" url="http://compare.buscape.com.br/indomada-p-c-cast-8576793016.html?mdsrc=9262544" /> 
  <link type="xml" url="http://sandbox.buscape.com/service/findOfferList/564771466d477a4458664d3d/?productId=1857679301&keyword=livros&sourceId=9262544" /> 
  </links>
  <thumbnail url="http://imagem2.buscape.com.br/capas/livros/610/793/190x190_8576793016.jpg" /> 
- <rating>
- <userAverageRating>
  <numComments>0</numComments> 
  <rating>0.0</rating> 
- <links>
  <link type="xml" url="http://sandbox.buscape.com/service/viewUserRatings/564771466d477a4458664d3d/?productId=1857679301&keyword=livros&sourceId=9262544" /> 
  </links>
  </userAverageRating>
  </rating>
- <specification>
- <links>
  <link type="xml" url="http://sandbox.buscape.com/service/viewProductDetails/564771466d477a4458664d3d/?productId=1857679301&keyword=livros&sourceId=9262544" /> 
  </links>
  </specification>
  </product>

preciso pegar os seguintes valores.

 

productname

pricemin

priceMax

o valor q esta em "url" desta linha <link type="product" url="http://compare.buscape.com.br/indomada-p-c-cast-8576793016.html?mdsrc=9262544" />

o valor detA LINHA <thumbnail url="http://imagem2.buscape.com.br/capas/livros/610/793/190x190_8576793016.jpg" />

 

não estou conseguinte usando:

 

<% 
' creating an object of XMLDOM
Set objXML = Server.CreateObject("Microsoft.XMLDOM")
objXML.setProperty "ServerHTTPRequest", True 
objXML.async = False

' Locating our XML database
objXML.Load("http://sandbox.buscape.com/service/findProductList/564771466d477a4458664d3d/?keyword=livros")


Set objLst = objXML.getElementsByTagName("product")


 
For i = 1 To objLst.Length - 1 
 Set subLst = objLst.item(2)
 Response.Write "<strong>Produto:</strong> "&subLst.childNodes(0).Text
 Response.Write "<br><strong>Preço Mínimo: </strong> "&subLst.childNodes(3).Text
 Response.Write "<br><strong>Preço Máximo: </strong> "&subLst.childNodes(4).Text
 Response.Write "<br><strong>Link do Produto:</strong> "&subLst.childNodes(5).childNodes(0).attributes(1).Text
 Response.Write "<br><strong>Link da Imagem:</strong> "&subLst.childNodes(6).attributes(0).Text&"<br><br>"
 Next 
%>

desulpem o topico grande, depois eu edito ele.

Obrigado.

[xanburzum 169]

dá uma olhada neste link