Phil Duba

Recent Blog Comments By Phil Duba

• Parsing CSV Data Using ColdFusion

  Posted on Jan 14, 2010 at 1:34 PM

  Great function Ben, saved me tons of work on a database upload!... read more »

• Ask Ben: Enforcing An SSL (HTTPS) Connection Based On Request

  Posted on Jul 28, 2009 at 10:31 AM

  Ben, you have to be careful using the CGI object. In our setup, SSL is done outside of the web server, on either accelerators or our load balancing server so the value of CGI.http is alwasy 'off'. To get around this, we constructed custom headers only set by the web server, as it receives http reque... read more »

• Ben Nadel's Easy Tips For Writing Better, More Optimized SQL

  Posted on Mar 27, 2008 at 2:39 PM

  @Nathan: I have found that if that column, tableb.active in this case, is not indexed then it is actually a little slower to put the tableb.active = 1 in the ON versus the WHERE. I noticed that in SQL Server 2005 and Oracle 9. Of course, that could have just been our schemas too, so I generally don'... read more »

• HostMySite.com Customer Care Rocks

  Posted on Aug 31, 2007 at 7:06 PM

  @Ben, yeah, my previous host's control panel was shameful, so really, anything more than a framed environment with a list of links on the left would have impressed me, ;)... read more »

• HostMySite.com Customer Care Rocks

  Posted on Aug 31, 2007 at 1:07 PM

  I made the switch yeaterday too and the tech support folks were really helpful getting the issues I had straightened out, and so were the sales support helping me resolve a few billing problems. After 24 hours with them, I am really impressed with everything from the support down through all the stu... read more »

• Lenny And Bo, ColdFusion Programmers (Vol. 16)

  Posted on Jun 5, 2007 at 7:59 AM

  I second that!... read more »

• Writing Enormous Files Based On Massive Record Sets In ColdFusion

  Posted on Dec 26, 2006 at 9:05 PM

  Adam, you could use the CFFile 'append' method, but that eats up even more memory, mostly from a processing perspective. The company I work for ran into this problem also, as we would build large CSV files from data gained from most of the tables our main application. I compared the Java method you ... read more »