View Single Post
 
Old July 21st, 2006, 09:51 AM
zoreli zoreli is offline
Registered User
Points: 25, Level: 1
Points: 25, Level: 1 Points: 25, Level: 1 Points: 25, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jul 2006
Location: , , .
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I solve this part and just in case that anyone may need this solution here it is:
================================================== ======
Set states = objXMLDoc.getElementsByTagName("Cities")
n_states = states.length

For i = 1 To n_states

Set state = states.NextNode
attr = state.getAttribute("CiID")
attr2 = state.getAttribute("City")
Response.write(attr +"&nbsp;"+ attr2 + "<br>")
Next
================================================== ======
But Now, I have other problem to solve. How can I select
Cities where Country code is for example 111? Anyone can help me with this?

Here is the sample of my XML file:

<?xml version="1.0" encoding="utf-8" ?>
- <CountriesCities>
- <Countries>
  <CoID>111</CoID>
  <Country>ALBANIA</Country>
  <Cities CiID="1478" City="TIRANA" />
  </Countries>
- <Countries>
  <CoID>1</CoID>
  <Country>AUSTRALIA</Country>
  <Cities CiID="1" City="ADELAIDE" />
  <Cities CiID="4" City="MELBOURNE" />
  <Cities CiID="6" City="SYDNEY" />
  </Countries>
- <Countries>