Solved

Using XPath to test if XML node exists

Posted on 2004-09-15
26
1,086 Views
Last Modified: 2012-06-27
Using ASP, I'm trying to access specific XML nodes with .SelectSingleNode("//TAGNAME") and test if the tag exists. Accessing the nodes (when they exist) is no problem, but the test for existance has me stumped.
I tried:
set thisNode = xmlDoc.documentElement.SelectSingleNode("//TAGNAME")
      If StrComp("thisNode.Text", "" )<> 0 Then
            Response.Write thisNode.Text
      End If
but it gives me an 'object required' error

Should I use getElementsByTagName() instead?

I'm sure this is not a very difficult question for you experts, but I'm stuck on this and a quick solution is very important, so I'm assigning more points.
Thanks
0
Comment
Question by:Ezog
  • 13
  • 12
26 Comments
 
LVL 13

Expert Comment

by:davidlars99
ID: 12066057
do not use "set" (and maybe """ around thisNode.Text)
0
 
LVL 13

Expert Comment

by:davidlars99
ID: 12066095
and make sure you have

> Dim xmlDoc   As New XML.XMLDocument

before you do anything
0
 
LVL 13

Expert Comment

by:davidlars99
ID: 12066126
or
> Set xmlDoc=Server.CreateObject("microsoft.xmldom")
0
 
LVL 13

Expert Comment

by:davidlars99
ID: 12066184
if none of these help try

> thisNode = xmlDoc.documentElement.SelectSingleNode("//TAGNAME").Text

that's all I could think of.. :)
0
 

Author Comment

by:Ezog
ID: 12066289
I have:
set xmlDocL = CreateObject("Microsoft.XMLDom")
xmlDoc.async = False
Set xmlDoc = objXMLHTTP.responseXML

If I use
thisNode = xmlDoc.documentElement.SelectSingleNode("//TAGNAME").Text

I still get the 'object reqiured' error
0
 

Author Comment

by:Ezog
ID: 12066671
when I tried:

set objElements = xmlDoc.getElementsByTagName("TAGNAME")
        If objElements.Item(0) Is Nothing Then
              thisNode = ""           
        Else
             thisNode = objElements.Item(0).nodeTypeString
        End If
Response.Write thisNode

I get 'element' as response instead of the string value
0
 
LVL 13

Expert Comment

by:davidlars99
ID: 12067195
what line is that you getting error on..?
0
 
LVL 13

Expert Comment

by:davidlars99
ID: 12067248
> set xmlDocL = CreateObject("Microsoft.XMLDom")
 what's  xmlDoc-"L " shouldn't it be  xmlDoc
0
 

Author Comment

by:Ezog
ID: 12067613
the "L" - just a typo,

I get the error on the Response.Write line
0
 

Author Comment

by:Ezog
ID: 12067864
I also tried:

set thisNode = xmlDoc.documentElement.SelectSingleNode("//TAGNAME")
If len (thisNode.Text) >0 Then
       Response.Write thisNode.Text
End If

I get an error only when the tag does not exist.
0
 
LVL 13

Expert Comment

by:davidlars99
ID: 12069190
try
> Set xmlDoc = CreateObject("Msxml2.DOMDocument")

and something very important

> Set xmlDoc = objXMLHTTP.responseXML
after this xmlDoc is not an object anymore...



I think that correct way would be following...


Set xmlDoc = CreateObject("Msxml2.DOMDocument")
xmlDoc.load(path_to_the_same_file_which_is_loaded_into_objXMLHTTP)

set thisNode = xmlDoc.documentElement.SelectSingleNode("//TAGNAME")
If len (thisNode.Text) >0 Then
       Response.Write thisNode.Text
End If





0
 
LVL 13

Expert Comment

by:davidlars99
ID: 12069224
when you try "thisNode.Text" it's looking for the object, but with "Set xmlDoc = objXMLHTTP.responseXML"    "xmlDoc"  would never be the object
0
 

Author Comment

by:Ezog
ID: 12069521
I inserted
    Set xmlDoc = CreateObject("Msxml2.DOMDocument")
and replaced
    Set xmlDoc = objXMLHTTP.responseXML
with
    xmlDoc.load("http://URL")
path_to_the_same_file_which_is_loaded_into_objXMLHTTP

but get:
Microsoft VBScript runtime error '800a01a8'
Object required
/response.asp, line 49
which is:
    set thisNode = xmlDoc.documentElement.SelectSingleNode("//TAGNAME")

Also, I only received an error if the tag is missing.  If the tag exists, I can enter its value into the form with the following:
     Set rootNode = xmlDoc.documentElement
     Set thisNode = rootNode.SelectSingleNode("//TAGNAME")
      Response.Write thisNode.Text
0
DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

 
LVL 13

Expert Comment

by:davidlars99
ID: 12069663
how about


Set xmlDoc = CreateObject("Msxml2.DOMDocument")
xmlDoc.load(path_to_the_same_file_which_is_loaded_into_objXMLHTTP)
set xmlResponse=xmlDoc.responseXML  'also try without "set"

thisNode = xmlResponse.documentElement.SelectSingleNode("//TAGNAME")
If len (thisNode.Text) >0 Then
       Response.Write thisNode.Text
End If



0
 
LVL 13

Expert Comment

by:davidlars99
ID: 12069727
ok, ignore my last post and try this first


Set xmlDoc = CreateObject("Msxml2.DOMDocument")
xmlDoc.load(path_to_the_same_file_which_is_loaded_into_objXMLHTTP)

thisNode = xmlDoc.documentElement.SelectSingleNode("//TAGNAME")
If len (thisNode.Text) >0 Then
       Response.Write thisNode.Text
End If



is loading file XML or some other type..?
0
 

Author Comment

by:Ezog
ID: 12069747
I get with and without "set":
'Microsoft VBScript runtime error '800a01b6'
Object doesn't support this property or method: 'responseXML'
/response.asp, line 27
0
 
LVL 13

Expert Comment

by:davidlars99
ID: 12069815
did you try one above your post..?
0
 

Author Comment

by:Ezog
ID: 12069852
I'm getting a feed with about 30 possible tags but only about half of them are returned at any given time.  I don't want to use stylesheets so I try to find the missing tags with conditionals...
maybe I'm going about it the wrong way
0
 

Author Comment

by:Ezog
ID: 12069885
hm, I don't understand that comment.  What do you mean with "above your post"?
0
 
LVL 13

Expert Comment

by:davidlars99
ID: 12069963
I mean this one


Set xmlDoc = CreateObject("Msxml2.DOMDocument")
xmlDoc.load(path_to_the_same_file_which_is_loaded_into_objXMLHTTP)

thisNode = xmlDoc.documentElement.SelectSingleNode("//TAGNAME")
If len (thisNode.Text) >0 Then
       Response.Write thisNode.Text
End If
0
 

Author Comment

by:Ezog
ID: 12069998
I think I might have figured it out:
This one works with the old
    Set xmlDoc = objXMLHTTP.responseXML

set objElements = objXML.selectSingleNode("//ZONING")
        if objElements is nothing then
        Response.Write "(Not available)"
    else
        Response.Write objElements.Text
    end if
0
 
LVL 13

Accepted Solution

by:
davidlars99 earned 250 total points
ID: 12070012
so you got it working..?
0
 

Author Comment

by:Ezog
ID: 12070025
actualy, I rewrote the thing and used objXML instead of xmlDOC (just for reference or the code would not make sence!)
0
 

Author Comment

by:Ezog
ID: 12070058
I think it works... at least so far, but I would like to leave the treat open until I have done some more testing. Thank you so much for you help! I will award your points on closing.
0
 
LVL 3

Expert Comment

by:gnudiff
ID: 12072906
> Using XPath to test if XML node exists

Is there any reason for not using simply SelectSingleNode("count(//TAGNAME)") Xpath? It should return the count of TAGNAME nodes, 0 - if no such nodes exist...

0
 

Author Comment

by:Ezog
ID: 12074671
I tried the SelectSingleNode("count(//TAGNAME)") and got the following error:

    msxml3.dll error '80004005'
    Unknown method. -->count(//<--STATE)

0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Problem to be resolved in this article Currently, development of website and web application can be done without writing thousands of lines of programming code by hand. Description This can be done through by using a open source framework such …
Foreword (July, 2015) Since I first wrote this article, years ago, a great many more people have begun using the internet.  They are coming online from every part of the globe, learning, reading, shopping and spending money at an ever-increasing ra…
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…
The viewer will get a basic understanding of what section 508 compliance can entail, learn about skip navigation links, alt text, transcripts, and font size controls.

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now