Solved

Using XPath to test if XML node exists

Posted on 2004-09-15
26
1,090 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
Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

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

Resolve Critical IT Incidents Fast

If your data, services or processes become compromised, your organization can suffer damage in just minutes and how fast you communicate during a major IT incident is everything. Learn how to immediately identify incidents & best practices to resolve them quickly and effectively.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Gulp not seeing Changes 4 73
applying error reporting code to see paypal error messages 13 90
Help with query 3 31
youtube blocking politics 4 55
Envision that you are chipping away at another e-business site with a team of pundit developers and designers. Everything seems, by all accounts, to be going easily.
Does your audience prefer people in photos or no people? How can you best highlight what you’re selling? What are your competitors doing, and what can you do that is different and unique from them?  Continue reading to learn how to make your images …
The viewer will learn how to dynamically set the form action using jQuery.
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.

860 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