Use XmlParent To Get The Parent Node In An XML Document In ColdFusion

Posted February 13, 2009 at 8:53 AM

Tags: ColdFusion

Every now and then, you learn something that seems so obvious that it's completely embarrassing that you didn't know it in the first place. You know, like the first time you realized that it's "intents and purposes", not "intensive purposes," or when you first learned that girls really do make poo. I had a similarly embarrassing moment earlier this week when I learned about XmlParent for the first time.

This one is really my fault for not reading the documentation, but I'm gonna blame it on CFDump anyway. See, like many people I am sure, when I am not positive what's inside of an object or I forget the name of something, I simply dump it out using CFDump. For example, if I wanted to see what was in a ColdFusion XML document, I could run this code:

 Launch code in new window » Download code as text file »

  • <!--- Define the xml document. --->
  • <cfxml variable="xmlGirls">
  •  
  • <girls>
  • <girl>
  • <name>Christina Cox</name>
  • <hair>Dirty Blonde</hair>
  • </girl>
  • <girl>
  • <name>Maria Bello</name>
  • <hair>Dirty Blonde</hair>
  • </girl>
  • <girl>
  • <name>Winona Ryder</name>
  • <hair>Brunette</hair>
  • </girl>
  • </girls>
  •  
  • </cfxml>
  •  
  • <!--- Output ColdFusion XML document. --->
  • <cfdump
  • var="#xmlGirls#"
  • label="xmlGirls"
  • />

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

 
 
 
 
 
 
XmlParent Not Shown In Long Version Of CFDUMP On Xml Documents. 
 
 
 

This is great - this really shows us what's in the XML document. Now, this is the "long version" XML output as shown by ColdFusion's CFDump tag, but as it turns out, this is not the complete XML architecture. To avoid what I assume is a circular reference issue, ColdFusion never outputs the XmlParent reference in the CFDump tag. Every child node has an XmlParent reference that allows you to get a reference to the child node's parent, thereby allowing you to walk both up and down the XML tree.

I can't believe I didn't know this!! When I was trying to answer an "Ask Ben" question earlier this week, I literally thought to myself, "There's got to be a better way," and decided, out of the blue, to Google, "XmlParent". Lo and behold, the first search result was the ColdFusion Live Docs' XML entry. How sad is that? I've been working with XML in ColdFusion for how many years? And I just discover XmlParent? That is sooo lame!

So anyway, embarrassment aside, let's just take a look at a quick example. Here, we are going to gather XML nodes via XmlSearch() and then use the resultant nodes' parent element to output data:

 Launch code in new window » Download code as text file »

  • <!--- Gather all hair nodes that are dirty. --->
  • <cfset arrDirtyGirls = XmlSearch(
  • xmlGirls,
  • "//hair[ contains( text(), 'Dirty' ) ]"
  • ) />
  •  
  • <!---
  • Now that we have the hair nodes, loop over them to
  • output the parent node (girl) and the hair color.
  • --->
  • <cfloop
  • index="xmlHairNode"
  • array="#arrDirtyGirls#">
  •  
  • <!---
  • Get a reference to the girl. The Girl node is
  • the parent of the Hair node and can be accessed
  • via XmlParent.
  • --->
  • <cfset xmlGirl = xmlHairNode.XmlParent />
  •  
  • <!--- Output name and hair color. --->
  • #xmlGirl.Name.XmlText# - #xmlGirl.Hair.XmlText#<br />
  •  
  • </cfloop>

When we run this code, we get the following output:

Christina Cox - Dirty Blonde
Maria Bello - Dirty Blonde

The example is actually pretty obvious; It's only a shame, it wasn't obvious a few years ago.

Note: I actually have mentioned XmlParent once before on this blog, about a year and a half ago. But, it has long since faded from my memory. I think that's actually MORE embarrassing than having never learned it :)

Download Code Snippet ZIP File

Post Comment  |  Ask Ben  |  Other Searches  |  Print Page


You Might Also Be Interested In:



Learning ColdFusion 9 - ColdFusion 9 tutorials, samples, examples, demos

Reader Comments

Feb 13, 2009 at 9:05 AM // reply »
18 Comments

What? Girls poo? Now I'm crushed. You'll be telling me that dogs fart next, but I refuse to believe it Mr. N. :)


Feb 13, 2009 at 9:19 AM // reply »
7,539 Comments

@Matt,

I was as crushed as you are. I tried to fight it for a long time, but it's science.


Feb 13, 2009 at 9:41 AM // reply »
2 Comments

That girls pooing thing can't be true, because my mom has never been naked in all her life.


Feb 13, 2009 at 9:44 AM // reply »
7,539 Comments

@Mike,

You raise a good point. Maybe the whole pooing thing is more of a "pseudo-science". I find that arguments like this cast serious doubts on the whole topic.


Feb 13, 2009 at 9:53 AM // reply »
4 Comments

Dude, are you spying on me? I was just looking at the results of my xmlSearch thinking how I could get the other data in the element. Totally did not think of the xmlParent since its not in the dump. Thanks.


Feb 13, 2009 at 9:58 AM // reply »
7,539 Comments

@RyanTJ,

Word up, they really should put it in the output. Obviously they can't output the values, but they could do something like:

[ XmlParent ][ Output not shown ]

That way, at least we'd remember, oh d'uh, it's in there.


Post Comment  |  Ask Ben

Recent Blog Comments
Mar 18, 2010 at 11:22 AM
Exploring ColdFusion Component Runtime Class Properties And Serialization
@Zarko, Ha ha, you know ColdFusion is my first love ;) ... read »
Mar 18, 2010 at 11:15 AM
Exploring ColdFusion Component Runtime Class Properties And Serialization
Hi Ben, nice to have you back! I already gave up on you, thinking you'll write about jQuery and iPhone for the rest our our lives! :) ... read »
Mar 18, 2010 at 10:36 AM
Ask Ben: Javascript Replace And Multiple Lines / Line Breaks
@Ben Nadel, Hey Ben, thanks for you're response. It works!! However.. if you could please kindly look at http://edeals.zzl.org/divchange2.php where I am trying it out you will see that with the " ... read »
Mar 18, 2010 at 9:56 AM
SQL COUNT( NULLIF( .. ) ) Is Totally Awesome
This works too. I learned this trick a long time ago and it's really powerful for flags. SELECT g.hair , COUNT(*) AS girl_count , sum(did_date) AS did_date_count , sum(abs(did_date - 1)) AS did_ ... read »
Mar 18, 2010 at 9:16 AM
Using A SQL JOIN In A SQL DELETE Statement (Thanks Pinal Dave!)
Forget the last part of that. Wasn't thinking straight and hadn't done it exactly that way myself. It'll work if you're doing an 'In' but if you're doing a 'Not In' as above it'll do each check acr ... read »
Mar 18, 2010 at 9:16 AM
Ask Ben: Blocking WSDL Access In A ColdFusion Application
Ben, Robert great stuff that I can use. Thanks. ... read »
Mar 18, 2010 at 8:45 AM
Using A SQL JOIN In A SQL DELETE Statement (Thanks Pinal Dave!)
Hi guys, Sort of in response to Kevin.. Just thought I'd point out something to any relative newbies like me trying to use the where clause subquery method with more than one join. I'm using MS Ac ... read »
Mar 18, 2010 at 6:59 AM
Using A Name Suffix In ColdFusion's CFMail Tag
Thanks Ben. This is really a very helpful article. Keep posting... Congrats. ... read »