Ask Ben: Finding XML Nodes That Have Children With The Given Case-Insensitive Phrase

Posted February 11, 2009 at 10:01 AM by Ben Nadel

Tags: ColdFusion, Ask Ben

Reader Comments

There's another couple of options here Ben:

<cfset aNoCase1 = xmlSearch(xmlFeed, "//item[contains(translate(title/text(), 'ABCDEFGHIJKLMNOPQRSTUVWXYZ', 'abcdefghijklmnopqrstuvwxyz'), 'coldfusion')]")>

It's a bit long-winded, but it works.

This next one conditionally works... it's OK for looking up the count of results, but as it transforms the XML, one has to be cautious with what one does with the results:

<cfset aNoCase2 = xmlSearch(lcase(xmlFeed), lcase("//item[contains(title/text(), 'COLDFusion')]"))>

Another note here is that the the nodes in the resultant array are not references to the original nodes, they're references to a separate XML doc which is created by the lcase(xmlFeed) operation. So one cannot update the nodes in the array and expect to see the updates in the original doc (like one usually would). So this one comes with some caveats, but if those are not a concern: it's an adequate approach.

--
Adam

@Adam,

Very nice tip on translate(). I have never used that before. Yes, tedius, but it works. As far as the LCase() of the entire XML document, I actually considered going down that path. But, then, my concern was getting back to the original reference in the first document.

They just need to go ahead and support lower-case() :)

Great post. I've also found that if the xml has a schema listed but is not valid the xml search fails even if the elements exist. If I deleted the schema ref (in the string xml prior to xmlParse) the search worked fine. Sure, you would think I should be using valid xml (against the schema) but the thing is I did not control the xml being returned from this web service and it wasn't. I did not see why xmlSearch should care. If the search works then return data dang you.

@RyanTJ,

I believe validation is an optional part of the XML parsing. But, to be honest, I have never used any schema validation explicitly. I cannot offer any better advice on that matter.

@RyanTJ,

.... all to say, yeah, if it can parse the XML, why does it care :(

Great post, Ben! I think XPath and XSL are often underused, and I always dig your posts on how to get more mileage out of them.

Your examples ("I Think ColdFusion Knocked Up My Daughter"??) are as twisted and borderline-inappropriate as always. Rock on, Mr. Nadel!

RyanTJ, could you pls clarify what you're saying here about xmlSearch() failing? Maybe paste some sample code?

Ben: could you please drop me an email offline (it's just about this lower-case / upper-case stuff, and CF's support for it).

Cheers.

--
Adam

It's not about them implementing anything. XPath 1 just doesn't have those functions, the XPath engine they use (Xalan) is XPath 1 compliant.

They'd need to use an XPath 2 compatible library instead, and that means switching to Saxon because that's the only implementation in Java unfortunately.

People seem to think that Macrodobe actually implement this stuff. They don't. The Regex engine is Apache ORO, the XML stuff is Apache Xerces and Xalan.

>It's not about them implementing anything.

Well, Elliott, it would be about them implementing Saxon instead Xalan, wouldn't it? So it's every thing about them implementing something, isn't it?

>People seem to think that Macrodobe actually implement this stuff.

Yes. They seem to think Adobe implements third-party libraries to get the work done. They also seem to think that perhaps other capabilities might present themselves if CF's chosen XML solution was a different one, possibly one in keeping with the times.

All of which is spot on.

You're the only one confused around here, mate.

--
Adam

@Adam, @Elliott,

I don't want to start attacking ColdFusion or Adobe here. When I say stuff about wishing they would implement it, I'm just generically saying, "That would be a cool feature to have." I don't mean much more than that.

Hi Ben
I don't think there's any way anything you said could've been construed as an attack against anything or one. Everything you said is spot on, valid, and I'm sure is something Adobe are giving at least some consideration to.

--
Adam

"How I Became An XSLT Junkie" :)
I'm finding XSLT/XPATH etc etc so much easier to use than parsing and looping and handling errors in the xml than straight ColdFusion.
I told my dba to have Oracle return XML results to me. But now we are looking at XSQL. Meanwhile the die hard Java, C#, VB programmers are going nutso wacko. (Are were they always that way?)

Seriously, I have scrapped my RSS integrator for websites and replaced it with a much simpler but more powerful XSLT version.

Have you read the book "ColdFusion Brain Freeze"?

@Don,

XSLT is definitely a powerful thing. While there is certainly a learning curve to XSLT, when you get it in your head, it can be a great way to transform XML.

I don't know that book, but I will look it up.

Ben,

You have been an amazing resource for me as I grow my skills and this specific article is pretty close to what I'm looking for, but my question is what if you need a case insensitive search of a node?

Specifically you are expecting people to send xml to you a certain way but you can't trust they won't do contactINFO or contactinfo instead of contactInfo.
The attribute trick you showed here won't work in this case because it's the NODE itself that we can't find properly.

Any thoughts?

Erick

@Erick,

You'd have to create a UDF or something that traverses the XML tree doing case-insensitive searching. Right now, there's really no way with XPath that I can see to do this.

Hi Ben,

Thanks for that tip. After much testing I have found that using MX7 there are a couple of "bugs" in xmlSearch. Perhaps these have been fixed in later versions of CF.

I wanted to search for the <td> that had text containing the string "properties that match your search criteria". I wanted to find the actual number of properties (ie 6 in the example case below).

Given the following example:
<tr>
<td align="left">
There are 6 properties that match your search criteria.
</td>
</tr>
<tr>
<td align="left">
There are 6 properties that match your search criteria.
</td>
</tr>

XmlSearch(xmlObj,"//td[ contains( text(), 'properties that match' ) ]")

only returns the td that DOESNT have the tag embedded. I tried all sorts of combinatins but couldnt get it to work on the first <td>.

I then tried "ends-with" and CF doesnt know about the "ends-with" function, but does know about the "starts-with" function.

But, "//td[ starts-with( text(), 'There') ]" doesnt return either node.

In the end I just did this to get the tds that are potential targets:

"//td/b/parent::*[1]"

ie get the td nodes that contains a tag

then looped over the resulting array doing:

if (findNoCase("properties that match your search criteria",local.tds[i]['xmlText'])){
variables.totalProperties = local.tds[i]['xmlChildren'][1]['xmlText'];
}

Thanks again for your helpful blog.

Murray

Woops. Sorry that my tags embedded in the source above cause the bolding nightmare!

@Murray,

Sorry, I had to muck with your comment a bit. For some reason, my editor was totally not able to parse whatever you wrote (I was trying to fix the bolding). As such, I think the bold tag got stripped out.

I hope that future versions of ColdFusion can update the xmlSearch() functionality a bit; I've run into unsupported xpath errors a good number of times. When that happens, the only approach that I have found is what you did - a combination of XPath and good old fashion ColdFusion looping.

Thanks Ben. Much appreciated.

Actually, for the benefit of anyone reading this who might want to make sense of the question post, the first <td> had a bold tag surrounding the numeral 6. So, the problem was that the xmlSearch wouldnt return that <td>, but would return the second one because the second one only had plain text, no embedded tags.

Cheers,
Murray

@Murray,

Good point on the clarification.

Thanks Ben for the above code. I do have a questions. I am very new to ColdFusion and xml. I'm working on an employee phone search, when the input is the employees entire lastname it works great but if someone inputs - an "a" the search brings back every name that has an "a" in it. How can I narrow down the results to only bring back names starting with "a". Any suggestions?

Terry

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>
	Remember my information
	Subscribe to comments
	Send me a copy of this comment