Doing something at work which involves me grabbing an XML feed from a third party provider on a daily basis then sticking it in a database so it can be reused as the feed only updates at midnight GMT.

Quite an easy task, cfhttp the file, loop over it, insert to the database. Well, this was made even easier by me discovering the entirely not new XPath (or here). Another quick google found a tutorial and after a quick play using xmlParse() and xmlSearch() in Coldfusion 7 my feed was filtered and inserted for reuse. It’s been around for a while, but, if you’re using CF7 and working with XML and haven’t seen XPath I suggest you take a look.

Quite nice as well as I actually learned something today!

Wanted to know what all those XML files in Coldfusion MX are, what purpose they have and were they live? Wonder no more, go have a read of this new Technote.