Hi

I have following XML file:

===========================
- <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>
=============================

Using this Code:

=============================
Set objXMLDoc = CreateObject("Microsoft.XMLDOM")
objXMLDoc.async = False
objXMLDoc.load Server.MapPath("../test/countries.xml")
varCountry = 1

set nodes=objXMLDoc.selectNodes("/CountriesCities/Countries[CoID='"&varCountry&"']")

for each x in nodes
response.write(x.xml) & "<br>"
next
=============================

When varCountry = 1
I get this result:

1 AUSTRALIA

If the varCountry is 111
I get this result:

111 ALBANIA

=============================

I would like to get if varCountry = 1

1 ADELAIDE
4 MELBOURNE
6 SYDNEY

and If VarCountry = 111

1478 TIRANA

Anyone can point me in some direction?

Regards, Zoreli

Add /Cities to the end of your path expression, then select the required attributes from your application code using getAttribute().

Michael Kay
http://www.saxonica.com/
Author, XSLT Programmer's Reference and XPath 2.0 Programmer's Reference

Hi

I am trying something like this :

==============================================

Set objXMLDoc = CreateObject("Microsoft.XMLDOM")
objXMLDoc.async = False
objXMLDoc.load Server.MapPath("../test/countries.xml")
varCountry = 2

set nodes=objXMLDoc.selectNodes("/CountriesCities/Countries[CoID='"&varCountry&"']/Country")

    for each x in nodes
        response.write(x.xml)
            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
    next


==============================================
But without any sucess. What I am doing wrong?

Regards, Zoran

getElementsByTagName gets all the Cities in the document, not just those that are children of "x".

Michael Kay
http://www.saxonica.com/
Author, XSLT Programmer's Reference and XPath 2.0 Programmer's Reference

Hi Michael

Thanks for the help. However, I am looking at this peace of the code so many hours, and I can't find the solution. :(

Can you please help me with some snipet code?

This is my first serous project with XML and I have problem to figure out how the thins works in XML.

Thanks

I don't actually program in VB myself so I can't give you the exact code, all I can do is spot your obvious errors.

Michael Kay
http://www.saxonica.com/
Author, XSLT Programmer's Reference and XPath 2.0 Programmer's Reference

Hi,
I do not program in VB but in C# and I only can help you with a peace of console code that I wrote to explain you how you can do it. The only thing you have to do is try to implement it in VB.

Below is the XML file I have used (named test.xml), copied from above:

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

and here is the code in C#:

using System;
using System.Xml;

public class test
{
    public static void Main()
    {
       XmlDataDocument xmlddoc = new XmlDataDocument();
       xmlddoc.Load("test.xml");
       XmlNodeList nlst = xmlddoc.DocumentElement.SelectSingleNode("//Countries[CoID=1]").SelectNodes("Cities");
       foreach (XmlNode x in nlst)
       {
           Console.Write(x.Attributes.GetNamedItem("CiID").Va lue+" ");
           Console.Write(x.Attributes.GetNamedItem("City").Va lue+"\n");
       }
    }
}

and of course the output:

C:\>test
1 ADELAIDE
4 MELBOURNE
6 SYDNEY

Regards,
.NETmateur
Electrical Engineer