Xml – How to SelectNodes with multiple attribute crieria using XML in ASP classic

asp-classicxml

I know how to selectnodes where a specific attribute has a specific value. For example, I know how to select nodes "person" nodes which have a value of strID for attribute id;

Set oDOM = Server.CreateObject("MSXML2.DomDocument")
oDOM.loadXML strXML

Set oNodes = oDOM.selectNodes("/people/person[@id='" & strID & "']")

Now suppose person nodes also had an attribute name. How would I select "person" nodes where id has value strID and name has value strName?

Best Answer

Try this:-

Set oNodes = oDOM.selectNodes("/people/person[@id='" & strID & "' and @name='" & strName & "']")

Related Solutions

Classic Asp Web Service Problem

You might consider writing a bit of .NET wrapper code to consume the web service. Then expose the .NET code as a COM object that the ASP can call directly. As you've seen, there is no tooling to help you in classic ASP, so consider using as much .NET as possible, for the tooling. Then, use COM to interoperate between the two.

XML selectNodes using Classic ASP

The code I'm using is:

Set NodeList = objXML.documentElement.selectNodes("agents/agent/properties/property")
For Each Node In NodeList
    Set AddrNode = Node.selectSingleNode("address/street/text()")
    if not AddrNode Is Nothing then response.write AddrNode.nodeValue & "<br/>"
    set AddrNode = nothing

    Set AddrNode = Node.selectSingleNode("address/region/text()")
    if not AddrNode Is Nothing then response.write AddrNode.nodeValue & "<br/>"
    set AddrNode = nothing

    For Each ImgNode In Node.selectNodes("images/image")
        Set ThNode = ImgNode.selectSingleNode("thumbnail/text()")
        if not ThNode Is Nothing then response.write ThNode.nodeValue & "<br/>"
        set ThNode = nothing
        Set ThNode = ImgNode.selectSingleNode("image/text()")
        if not ThNode Is Nothing then response.write ThNode.nodeValue & "<br/>"
        set ThNode = nothing
        Set ThNode = ImgNode.selectSingleNode("alttext/text()")
        if not ThNode Is Nothing then response.write ThNode.nodeValue & "<br/>"
        set ThNode = nothing
    next
Next

I hope someone else finds its useful!

Best Answer

Related Solutions

Classic Asp Web Service Problem

XML selectNodes using Classic ASP

Related Topic