Bryan

Recent Blog Comments By Bryan

• ColdFusion Component Wrapper For POI To Read And Write Excel Files

  Posted on May 10, 2010 at 6:23 PM

  @patrick, Based on my experience with the POI library, I think you'd have a hard time extracting the binary, but I won't say it's impossible. Off the cuff, IF you have Office 2007 installed on the server doing the work, there is another possible way to get to it without POI. Again, just thinking... read more »

• Application.cfc OnRequest() Method Affects OnError() Arguments

  Posted on Mar 25, 2010 at 11:37 AM

  @Ben, You're right, that would essentially fix the issue as I've laid it out. Unfortunately, as verbose as I've been, I've been trying to distill the underlying system to its simplest form. The reality is, there are more complexities that I've left out, due to them being either redundant with the ... read more »

• Application.cfc OnRequest() Method Affects OnError() Arguments

  Posted on Mar 24, 2010 at 11:02 AM

  @Ben, followup: Decided to modify my init() in my root class as follows. It looks at config object passed into constructor and checks for any keys named "variables" If it finds it, I push the keys/values from that sub-struct into the variables scope, then delete that key from the config struct. ... read more »

• Application.cfc OnRequest() Method Affects OnError() Arguments

  Posted on Mar 23, 2010 at 4:23 PM

  @Ben, Good advice. In my case, however, my init functions take a single config object {API:this} as their primary argument. These get loaded into the object's " this " scope. In this case, for backward compatibility with our previous code, the API has to be available in the variables scope. Ini... read more »

• Application.cfc OnRequest() Method Affects OnError() Arguments

  Posted on Mar 23, 2010 at 10:50 AM

  @Ben, Well, it gets clearer, and muddier, when I do that. Good recommendation, BTW. That put me on the trail of the actual cause. Which is explained below. I've tracked the oddity to a strange construct of my system. (process slightly simplified) 1) session.API is created by setting session.API = ... read more »

• Application.cfc OnRequest() Method Affects OnError() Arguments

  Posted on Mar 19, 2010 at 4:47 PM

  @Jason and @Ben, I've been doing some CF9 refactoring on our systems and noticed an odd occurrence with onError as well. Found a way to work around my problem, but what I saw was... Background: Our platform is OO and creates a CFC (our API) into the session scope onSessionStart. That API is then r... read more »

• ColdFusion Component Wrapper For POI To Read And Write Excel Files

  Posted on Feb 19, 2010 at 10:59 AM

  @Ben, Ben Wrote: Feb 12, 2007 "Ha ha ha, PPT. Give me a year :)" Well Ben, just looking over my old posts and came across this... Looks like you gave it a few extra years and punted. Went ahead and let Adobe do it for you eh? ;) Keep up the awesome work Ben.... read more »

• ColdFusion Component Wrapper For POI To Read And Write Excel Files

  Posted on Feb 19, 2010 at 10:49 AM

  @Jessica, If you're using IIS (as it seems you are) there is a hotfix at http://support.microsoft.com/kb/812935 that fixes the problem in IIS. We ran into the same problem, not directly with POI, but with all downloads from SSL where no-cache is on. In our situation, we were able to put in a dy... read more »

• ColdFusion Component Wrapper For POI To Read And Write Excel Files

  Posted on Feb 12, 2007 at 4:10 PM

  Thanks Ben, I'll check it out then. I don't think it's right for converting all our existing exports and imports to (there's too many and they work fine for now), but we're developing a new architecture for all future clients, and this looks like it could provide a nice advantage in development time... read more »

• ColdFusion Component Wrapper For POI To Read And Write Excel Files

  Posted on Feb 12, 2007 at 3:56 PM

  Do you have any comparative metrics on processing time using your component versus interracting with the MS Excel COM object directly from CF? I wrote a component a couple years ago for my work that managed the various difficulties inherent in dealing with the MS COM directly. This worked well for... read more »