Jon Hartmann

ColdFusion Spreadsheet Headers Ignore Empty Columns

• August 31, 2011 11:08 AM
• ColdFusion, Mystery Error Message
• Comments (1)

This is one of those notes-for-my-future-self type posts related to a bizarre behavior with ColdFusion's support. ColdFusion ignores any column at the end of your document where the only data was in the row you specified as a headerrow (assuming you ignore the header row). Got that?

• Read More
• Print
• Send
• Digg It!

Utility Functions: Two UDFs to Make Spreadsheets Easier

• April 18, 2011 10:46 AM
• Utility Function, ColdFusion
• Comments (1)

I started diving into using ColdFusion's capabilities to work with Excel spreadsheets for the first time today. Even though its been a part of ColdFusion since CF9 dropped in 2009, I've not been called on to use the functionality, so I'm a bit behind the curve. Once I got moving though, I found some annoyances and gotcha's that drove me to come up with a couple of new UDFs to ease my pain. Find SpreadsheetExpandedInfo() and SpreadsheetGetData() after the jump.

• Read More
• Print
• Send
• Download
• Digg It!

Problems with Day() and CreateTimeSpan()

• March 7, 2011 9:14 AM
• ColdFusion, Mystery Error Message
• Comments (5)

I'm attempting to use CreateTimeSpan() to hold information about how long my system will be down for maintenance given a starting date and time, and I've been running into a few interesting issues. I'd have thought that this would be a simple matter, as adding a timespan to an existing time stamp would be a useful mechanic, but it seems as though there are some hidden gotchas and, perhaps, some outright bugs.

• Read More
• Print
• Send
• Digg It!

Useful Link: Hacking your ColdFusion Administrator Password

• December 31, 2010 10:02 AM
• ColdFusion
• Comments (0)

I found myself in a tight spot earlier today; I couldn't remember the password I supplied to ColdFusion Administrator on one of my machines. Since Adobe doesn't offer a recovery mechanism, I was worried I'd need to do a full re installation to purge the password. I turns out the solution is a lot easier than I expected:

http://coldfusion8.blogspot.com/2008/08/what-if-you-forget-coldfusion-admin.html

• Print
• Send
• Digg It!

Legitimate use for Evaluate()? Do Not Want!

• December 16, 2010 3:00 PM
• ColdFusion
• Comments (6)

I hate Evaluate(). I hate it like I hate mornings without coffee. I hate it like getting Visual Studio's Debugger to work. I hate Evaluate(), and thats why I'm sad to say that I think I've found a case where I can't use any of my standard tricks to avoid using Evaluate(), and have to give the ugly beast its moment of glory.

• Read More
• Print
• Send
• Digg It!