I thought I would post this to help anybody else who might be struggling with loading large XML files and datasets into Microsoft SQL using ColdFusion.
Using this technique, you can use a Microsoft COM object called “SQLXMLBulkLoad.SQLXMLBulkLoad”. This is a very fast object that allows you to provide an XML mapping file, the XML file […]

I am currently considering web hosting here in the UK instead of the US, due to the nightmare I’ve been having with my current host with downtime. Does anybody host with a UK ColdFusion provider currently and who do you suggest?
 Thanks

Ok, I finally got this blog to have Search Engine friendly URL’s on a Windows 2003 server! I done a lot of searching and digging, but finally found this technique on Einar Egilsson’s Blog. The solution uses a custom 404 handler to complete the redirecting. Simply by adding this custom 404 page, your blog can […]

This is the look and logo for Adobe Air as discovered over at Mike Chambers blog - introducing the Adobe Air Logo. I personally think the logo is great. Clean, simple and easy to recognise.Mike says “I am not going to go into a detailed analysis of what the logo represents, but I do want to […]

The Apple iPhone has finally made it to the UK on O2 and I have to say it looks and feels really nice. I love the ability to view web pages as you would see them on your Mac or PC and not like on some other mobile web browsers. The usability studies done on […]

I have been using this tiny AJAX library for a while now and have used it in various projects. It is extremely simple to use and is easily extendable and customisable. JSMX at http://www.lalabird.com/ is great. I know there are many others out there. Does anybody have a favourite?

I am currently working on implementing social bookmarking for a client. Whilst I sort of like the idea of my favourites roaming around with me and the superb SEO benefits to your site, is there any other use to these tools? Also which ones are the most popular or most used? Do some pages overdo […]

I stumbled across this very interesting post regarding google analytics over at Dan Mackey’s blog. He has found an Adobe AIR application that hooks into Google Analytics yet acts like a desktop app. The app is still in BETA but looks really nice. Download it over at aboutnico.be

Currently working on restructuring some google sitemaps for my client. Instead of the usual query, loop, output process for a ColdFusion XML manipulation based task, I decided to get SQL server to do the work for me. Using FOR XML AUTO, ELEMENTS at the bottom of my query, I can get SQL to return the results of […]

A few months back I was confronted with the problem of writing a fairly large CSV file using ColdFusion. The file size was around 10mb so I got to work with cffile. After building the code, I sat back and pushed the button to test. BANG! the memory on the ColdFusion server was sky high […]