Using Classic ASP to get value of a node attribute

Question

I have the following XML schema:

<?xml version="1.0" encoding="utf-8"?>
  <PageMapping>
    <Applications>
       <Application name="xxx">
         <Page name='Default.aspx' IsCaptured = "true" >
            <Control name="btnSearch" IsCaptured = "true"/>
            <Control name="btnSave" IsCaptured = "true"/>
            <Control name="btnClick" IsCaptured = "true"/>
         </Page>
         <Page name='Login.aspx' IsCaptured = "true">
            <Control name="btnSearch" IsCaptured = "true"/>
         </Page>
         <Page name='Home.aspx' IsCaptured = "true" >
            <Control name="btnSearch" IsCaptured = "true"/>
         </Page>
         <Page name='User.aspx' IsCaptured = "true" />
     </Application>
   </Applications>
 </PageMapping>

Using ASP, how would I get the value of "name" and "IsCaptured"? I have tried all sorts of different methods, but nothing seems to work. Any ideas?

We need more details: is this XML local file on the server? Or is it located on different machine/website? — user447356
– user447356, Commented Dec 20, 2011 at 9:06
@Shadow: Not quite. Subramani are you interested in the attributes on both Page elements and Control elements? — AnthonyWJones
– AnthonyWJones, Commented Dec 20, 2011 at 13:21

Rory McCrossan · Accepted Answer · 2011-12-20 09:07:43Z

2

Try this:

Set oXML = Server.CreateObject("MSXML2.DomDocument.4.0")
oXML.LoadXML(sXML) ' sXML is a variable containing the content of your XML file

For Each oNode In oXML.SelectNodes("/PageMapping/Applications/Application/Page")
    sName = oNode.GetAttribute("Name")
    sIsCaptured = oNode.GetAttribute("IsCaptured")

    ' Do something with these values here
Next

Set oXML = Nothing

edited Dec 20, 2011 at 9:07

user447356

answered Dec 20, 2011 at 9:06

Rory McCrossan

338k41 gold badges322 silver badges353 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

subramani Over a year ago

Its not working... the XML file is available on same virtual directory. anythink needs to include? Note: I am using IE 8

user447356 Over a year ago

@subramani just change oXML.LoadXML(sXML) to oXML.Load("filename.xml")

AnthonyWJones Over a year ago

@Shadow: you need Server.MapPath as well.

user447356 Over a year ago

@AnthonyWJones true, my bad! Rory can you please edit your post with this option as well?

subramani Over a year ago

<%@ Language=VBScript %><% Option Explicit %><HTML> <HEAD> </HEAD> <BODY> <% On Error Resume Next Dim oXML Set oXML = Server.CreateObject("Microsoft.XMLDOM") oXML.async = False oXML.load (Server.MapPath("/Test1/PortalConfiguration.xml")) Dim sName Dim sIsCaptured For Each oNode In oXML.SelectNodes("/PageMapping/Applications/Application/Page") sName = oNode.GetAttribute("name") sIsCaptured = oNode.GetAttribute("IsCaptured") response.write("SName" & sName) response.write("is" & sIsCaptured) Next Set oXML = Nothing %> </BODY> </HTML>.The aboce code is not working. Please correct me if i am wrong.

Luke · Accepted Answer · 2015-04-10 10:34:00Z

0

Change line 4 and 5 to these:

Dim sName : sName =  oNode.GetAttribute("Name")
Dim sIsCaptured : sIsCaptured =  oNode.GetAttribute("IsCaptured")

edited Apr 10, 2015 at 10:34

Luke

11.5k43 gold badges63 silver badges70 bronze badges

answered Apr 10, 2015 at 9:53

Chung_TheWebDeveloper

415 bronze badges

Collectives™ on Stack Overflow

Using Classic ASP to get value of a node attribute

2 Answers 2

5 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related