The mind is not a vessel to be filled, but a fire to be kindled.

ColdFusion

The CFSPREADSHEET function introduced in ColdFusion 9 is a great time saver. As anyone can attest to spreadsheets reign supreme in business. Before CF 9, our team used Ben Nadel’s POI Utility Component for most of our spreadsheets. It worked great for all of our CF 8 applications, but the […]

Using cfspreadsheet in CF9

March 4, 2013 in Techno Babble by Karsten Pearce

A couple of weeks ago our group had to do some email investigation. In the span of a couple of days we received a series of complaints that our CF server wasn’t delivering email. Of course the tickets stated that all email wasn’t being delivered – which was an exaggeration […]

Same basic sendmail trouble shooting steps

July 16, 2012 in Techno Babble by Karsten Pearce

In one of my applications that I am working on I need to grab a person’s profile, check to see if they have any documents to approve and/or review. Originally I was using multiple query calls to perform this task (one for the profile, another to check for approvals and […]

Grouping MySQL statements

May 25, 2012 in Techno Babble by Karsten Pearce

If you have used tags like CFLDAP and CFHTTP you probably find the timeout attribute is frustratingly ineffectual. If the target server is down or otherwise slow to respond, it can hold up the CFML engine response. Charlie Arehart has a great post called CF911: Lies, Damned Lies, and CF Request […]

Testing for service availability before you call…

May 12, 2012 in Techno Babble by Karsten Pearce

I recently upgraded from ColdFusion 8 to ColdFusion 9 on my development system, along with a fresh copy of Mach-ii 1.8. Being a development server I had numerous project using some sort of framework. As most developers do I load my frameworks into a common folder and have those mapped […]

CF9 and Mach-ii properties bleed over

February 8, 2012 in Techno Babble by Karsten Pearce

So, I ran into a problem with one of my current applications for a client. Every quarter they like to lock their records from being edited once they have been submitted. In the previous version I had to run that event myself with a basic MySQL query – I didn’t […]

Flushing All Cached ColdFusion Queries…

January 2, 2012 in Techno Babble by Karsten Pearce

Since most of my time is spent on the keyboard and not the mouse – I love to use shortcuts. This post lists some shortcut keys that I use most. Hope they can be useful for anyone else. You can find the full list in your CFBuilder (ColdFusion – Profiles […]

CFBuilder Keyboard Shortcuts – Cheat sheet

July 1, 2011 in Techno Babble by Karsten Pearce

Yesterday I was helping someone with a problem, they kept receiving an “Cannot declare a local variable …. twice” error in one their DAO methods. It took us a couple of minutes to figure out how we were declaring the variable twice. Come to find out var and cfargument are […]

Scope Conflicts

July 1, 2011 in Techno Babble by Karsten Pearce