Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.

Alan McCollough

Member since Jul 20, 2009

Recent Blog Comments By Alan McCollough

  • ColdFusion POIUtility.cfc Updates And Bug Fixes

    Posted on Jun 22, 2011 at 6:38 PM

    first off, love your POI Utility, it gets used daily. I got the most recent version, but was still having a problem with dates getting rendered as floating point. To get around that, I made the following mod, starting at line 1792, right after an if/else to set the cell style. // attempt to set d... read more »

  • POIUtility.cfc Examples For Reading And Writing Excel Files In ColdFusion

    Posted on Oct 8, 2010 at 3:21 PM

    I know this is an old post, but fwiw, I have what may be a simple answer to this error: Error: Object Instantiation Exception. An exception occurred when instantiating a Java object. The class must not be an interface or an abstract class. Error: ''. In my case, it was that I had an invalid filepa... read more »

  • ColdFusion Query of Queries Unexpected Data Type Conversion

    Posted on Feb 10, 2010 at 12:27 PM

    Ben, I'll pass along another QofQ datatype disaster I went through a couple days ago. An app that uses QofQ started throwing "cannot conver value '' to number" errors for no apparent reason. The QofQ had been CASTed to death, and I could not come to a solution, but did come up with a strange but suc... read more »

  • ColdFusion Query of Queries Unexpected Data Type Conversion

    Posted on Jan 4, 2010 at 5:23 PM

    I noticed (with CF8) similar QofQ date bizareness, trying to test for date X being before or on now(). If I have a query "foo" and it cfdumps and the "dateX" col looks and smells like a date field, I'd try "SELECT * from foo where cast([dateX] as date) <= cast(<cfqueryparam cfsqltype="CF_SQL... read more »

  • Ask Ben: Dynamic Web Root And Site URL Calculations In Application.cfc

    Posted on Jul 20, 2009 at 12:31 PM

    This works on CF7 if you change "<cfset local = {} />" to "<cfset local = structNew() />"... read more »