Using XmlSearch() In CFLoop Array (Thanks Scott Bennett!)

Posted December 27, 2007 at 8:32 AM by Ben Nadel

Tags: ColdFusion

Reader Comments

Hi Ben,

I have been working on trying looping over data out of an XML file and choosing a particular node through XmlSearch.

XML File Structure:
<propertyList date="2008-01-25-10:02:00" >
<residential modTime="2008-01-25-10:02:01" status="current">
<uniqueID>HI5160</uniqueID>
<images>
<img id="m" file="HI5160_1.jpg"/>
<img id="a" file="HI5160_2.jpg"/>
<img id="b" file="HI5160_3.jpg"/>
<img id="c" file="HI5160_4.jpg"/>
<img id="d" file="HI5160_5.jpg"/>
<img id="e" file="HI5160_6.jpg"/>
<img id="f" file="HI5160_7.jpg"/>
<img id="g" file="HI5160_8.jpg"/>
<img id="h" file="HI5160_9.jpg"/>
<img id="i" file="HI5160_10.jpg"/>
<img id="j" file="HI5160_11.jpg"/>
<img id="k" file="HI5160_12.jpg"/>
</images>
</residential>
</PropertyList

The only way i can get the desired results is this way:

<CFSET propID = getlist.listing_id>

<!--- Loop over the info-main nodes. --->
<cfloop
index="intMainIndex"
from="1"
to="#ArrayLen( Listings.PropertyList.residential )#"
step="1">

<!--- Get a short hand for the current info-main node. --->
<cfset xmlInfoMain = Listings.PropertyList[ "residential" ][ intMainIndex ] />
<cfif xmlInfoMain.uniqueID.XmlText EQ propID>
uniqueID = [<cfoutput>#xmlInfoMain.uniqueID.XmlText#</cfoutput>]<br />

<!--- Get the image-list children. --->
<cfset arrImageList = xmlInfoMain[ "images" ] />

<!--- Loop over the image list. --->
<cfloop
index="intImageListIndex"
from="1"
to="#ArrayLen( arrImageList )#"
step="1">

<!--- Get a short hand for the current image-list node. --->
<cfset xmlImageList = arrImageList[ intImageListIndex ] />

<!--- Loop over image nodes. --->
<cfloop
index="intImageIndex"
from="1"
to="#ArrayLen( xmlImageList.img )#"
step="1">

. . . . img[ file = [<cfoutput>#xmlImageList.img[ intImageIndex ].XmlAttributes.file#</cfoutput>] [<cfoutput>#xmlImageList.img[ intImageIndex ].XmlAttributes.id#</cfoutput>]<br />
</cfloop>

</cfloop>
</cfif>
</cfloop>

I'm sure there is a quicker way to do this using XmlSearch.

I have successfully grabbed the record out of the XML i need via this code:

<cfset arrResNodes = XmlSearch(Listings,"//residential[ uniqueID[ text() = '#propID#' ]]/") />

The only problem is i cannot loop over the results of XmlSearch?? Could you point me in the right direction? I can dump the output, just not loop over the img nodes.

Thanks,

Leigh

@Leigh,

I think you are really close here. To get directly at the array of IMG nodes, you can use this XPath:

//residential[ uniqueID[ text() = 'HI5160' ] ]//img/

where I put in the hard-coded ID for testing. Once you have that array, you just loop over it the same way you are already looping over the image nodes array.

Hi Ben,

After your excellent advice which worked like a treat with images, i need your advice on the following:

I have 1 main xml file another xml file with updates only.

I need to append or copy over the main xml with the update data.

I was using the XmlSearch theory: //residential[ uniqueID[ text() = 'HI5160' ] ]

and then trying to append the main file:

<cfset ArrayAppend(mydoc.PropertyList.residential.XmlChildren, XmlElemNew(myupdate,myupdate.PropertyList.residential))>

I would then write the new xml file.

Any further help with this would be appreciated.

Can i use XmlSearch within 1 file and append another file at the same time?

Thanks, Leigh

@Leigh,

You can't just copy a node from one tree to another. You have to import it first. Check out this UDF that I mad to do that:

http://www.bennadel.com/index.cfm?dax=blog:701.view

CF8 allows you to do the

<cfloop index="x" array="#myarray#">
#x# -
</cfloop>

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