Using XPath To Select A Node That Does Not Contain Another Node In ColdFusion

Posted March 25, 2010 at 10:09 AM by Ben Nadel

Tags: ColdFusion

Just a quick post on XPath in ColdFusion. This morning, when I was writing about screen-scraping movie showtimes off Fandango.com, I had to use an XPath query that looked for an XML node that did not contain another XML node. In the past, I've blogged about gathering nodes that did not contain a text node (or a given text value); but, I don't think I have ever talked about getting nodes that did not contain a given element node. As such, I wanted to throw together a very brief example of how this is done.

To quickly recap, XPath queries can contain predicates. These are qualitative queries, wrapped in brackets, that filter the given node into or out of the resultant node-set. For example, in the given XPath query:

//a[ @rel = 'home' ]

... we are looking for an "a" element node that has an href attribute that contains the value "home." The predicate, in this case, is the relative query, "[ @rel = 'home' ]". A predicate can contain just about anything so long as that can be boiled down to a truthy / falsey value.

If we want to search for a node that does not contain another node, we can use a negated XPath predicate. Populated node sets are truthy values. As such, if we want to find a node that does not contain a given node, we need to negate the predicate in which the node does contain the given node. In XPath, this negation can be performed by the not() function.

To see this in action, I am going to select from a collection a movies all movies that are not musicals:

  • <!--- Create the XML document. --->
  • <cfxml variable="movies">
  •  
  • <movies>
  • <movie>
  • <name>Terminator</name>
  • <genre>
  • <action />
  • <adventure />
  • </genre>
  • </movie>
  • <movie>
  • <name>De-Lovely</name>
  • <genre>
  • <musical />
  • </genre>
  • </movie>
  • <movie>
  • <name>Sex Drive</name>
  • <genre>
  • <comedy />
  • </genre>
  • </movie>
  • </movies>
  •  
  • </cfxml>
  •  
  •  
  • <!--- Query for all movies that are not musicals. --->
  • <cfset nonMusicals = xmlSearch(
  • movies,
  • "//movie[ not( genre/musical ) ]"
  • ) />
  •  
  • <!--- Output the selected movies. --->
  • <cfdump
  • var="#nonMusicals#"
  • label="Non-musical Movies."
  • />

As you can see, our XPath query is using the following search:

//movie[ not( genre/musical ) ]

Within each movie node, we are checking to see if the node contains the ancestor genre, "musical". Of course, since those are the movies that we specifically do not want to select, we then use the not() function to turn any matching musical node set from a truthy value into a false boolean value. This false then filters the given movie out of the resultant node set, returning only movies that do not contain the musical element node.

When we run the above code, we get the following CFDump output:

 
 
 
 
 
 
Selecing An XML Node With XPath That Does Not Contain Another Given Node. 
 
 
 

As you can see, De-Lovely, a musical, was not returned in the resultant node set. This is a minor, but powerful feature of XPath.




Reader Comments

Mar 25, 2010 at 7:38 PM // reply »
67 Comments

It's good to see there's always something new I can learn about XPath. Good post. Cheers.

--
Adam


Mar 26, 2010 at 7:57 AM // reply »
10,743 Comments

@Adam,

No problem my man. XPath is some cool stuff.


Post A Comment

Comment Etiquette: Please do not post spam. Please keep the comments on-topic. Please do not post unrelated questions or large chunks of code. And, above all, please be nice to each other - we're trying to have a good conversation here.

Please review the following issues:

Author Name:


Author Email:

Author Website:

Comment:

Supported HTML tags for formatting: <strong>bold</strong>   <em>italic</em>   <code>code</code>







  • Help Wanted - Find Your Next ColdFusion Job
InVision App - Prototyping Made Beautiful With Prototyping Tools Ben Nadel's Company - Epicenter Consulting Recent Blog Comments
May 16, 2012 at 8:18 PM
Best Of ColdFusion 10 Contest Entry - HTML Email Utility
Just found this, looks good! I'm trying to run it on local, it's the 64bit version and I'm experiencing horrible lag. On average the generate.cfm processes the content change in 60-90 seconds. I've ... read »
May 16, 2012 at 6:40 PM
Maintaining Sessions Across Multiple ColdFusion CFHttp Requests
I am trying to integrate this CFHTTPsession into an application that will log into zeekrewards.com to post ads and I am not having any luck. The code works perfectly for logging into other websites, ... read »
May 16, 2012 at 2:44 PM
Creating A Sometimes-Fixed-Position Element With jQuery
Thank you, very useful technique! Worked like a charm. ... read »
May 16, 2012 at 1:58 PM
Movies As A Religious Experience
Acting can, in a way, ruin the movie-goer's experience. I used to be able to get so caught up in movies and their plots, and totally engaged. But lately, I haven't been able to as much with a lot o ... read »
May 16, 2012 at 1:52 PM
The Science Of Optimal Post-Exercise Nutrition
children of this age eat very less vegetables so u can opt for salads they will like it also carrot ,cucumber,onion and as far as pulses are concerned u can boil them ,give him along with mashed rice ... read »
May 16, 2012 at 1:34 PM
Strange ColdFusion JRUN Stack Overflow Error
Hey, Recently I updated my jrun4 using the latest updater 7 and now i am having memory issues :(:(:( any help is appreciated ... read »
May 16, 2012 at 9:56 AM
ColdFusion 10 Beta, Apache Tomcat, And Symbolic Links On Mac OSX
Hi, Now that ColdFusion 10 is out I have stumbled over this as well and I cannot figure out the proper solution. We're running virtual hosts via Apache2; the ColdFusion-applications store their fil ... read »
May 15, 2012 at 6:03 PM
Movies As A Religious Experience
@Ben, I don't know whether you'd consider this a religious observation, but it seems to me, in a sense, movies multiply how many lives we get to have. Each movie is like a little extra life we get ... read »