Zac Spitzer

Recent Blog Comments By Zac Spitzer

• Playing With The Zip Virtual File System (VFS) In Lucee 5.3.2.77

  Posted on Aug 14, 2019 at 10:28 AM

  So you could mount a docx file this way I guess!... read more »

• Sanity Checking Closure Invocation Overhead And Performance In Lucee 5.3.2.77

  Posted on Jul 30, 2019 at 9:51 AM

  Yo! Scope those arguments! Over 1000 iterations, the scope lookup cost will make a difference!... read more »

• The CFQuery Tag Supports Silent Asynchronous Query Execution In Lucee 5.3.2.77

  Posted on Jul 14, 2019 at 12:10 PM

  IMHO errors should always be logged, no excuses! Lucee being open source, I had a quick look at the commit for that feature and there was some changes to the error handling, so it definitely was a consideration. The general rule from the Lucee devs is file bugs, or they don't exist. That s... read more »

• The CFQuery Tag Supports Silent Asynchronous Query Execution In Lucee 5.3.2.77

  Posted on Jul 14, 2019 at 8:11 AM

  Can you file a bug about the error handling?... read more »

• Calling Canonicalize() On An Empty-String Returns NULL In Lucee 5.2.9.31

  Posted on Jan 1, 2019 at 10:50 AM

  I'd always recommend posting to dev.lucee.org before filing a bug It's great to see you getting involved with Lucee :)... read more »

• Calling Canonicalize() On An Empty-String Returns NULL In Lucee 5.2.9.31

  Posted on Jan 1, 2019 at 7:30 AM

  It's a bug rather than documentation IMHO, compatibility with ACF is the expected behavior as a rule with Lucee... read more »

• Shared-Array Iteration Can Cause Thread Deadlocks In Lucee ColdFusion 5.2

  Posted on Dec 19, 2018 at 7:29 AM

  Hey Ben, which exact version of Lucee where you using? there are a lot of Lucee 5.2 releases and it's always useful to know in which release you found the problem... read more »

• Testing Which ASCII Characters Break JSON (JavaScript Object Notation) Parsing

  Posted on Jan 10, 2014 at 10:35 AM

  Which version of CF was this? I did this myself about a month ago against an old 8 server and found exactly the same problems....... read more »

• Learning ColdFusion 9: The Virtual File System (RAM Disk)

  Posted on Jul 27, 2009 at 1:46 AM

  that will always happen with the ram based stuff. You can set a higher timeout in the CF administrator, but you should consider ram like the session of application scope, ie not persistant... read more »

• Learning ColdFusion 9: IsNull() And Working With NULL Values

  Posted on Jul 19, 2009 at 4:10 AM

  Ben, in oracle land a null gets treated like empty string. It's different between databases. Maps quite nicely to CFML. Not having nulls actually reduces the amount of code you have to write. Over on the FDO project something similiar came up and there was a lot of extra null checking handling cod... read more »

• Learning ColdFusion 9: The Virtual File System (RAM Disk)

  Posted on Jul 19, 2009 at 3:54 AM

  bug posted, please vote for it, personally I think having a request level VFS scratch space is brilliant http://cfbugs.adobe.com/cfbugreport/flexbugui/cfbugtracker/main.html #bugId=78909 Jeez that flex app is painful compared to HTML, that bug tracker is NQR... read more »

• Learning ColdFusion 9: The Virtual File System (RAM Disk)

  Posted on Jul 18, 2009 at 6:34 AM

  reading the notes about ram:// being global, why aren't these scope specific server:// session:// request:// application:// makes a lot more sense to keep to existing concepts, plus it avoids collision with darn sandbox settings...... read more »

• Random Thought: The Database Bottleneck And Elegance

  Posted on Nov 29, 2008 at 9:05 PM

  One of the most useful things for tuning performance are Materialised Views (oracle speak) which SQL server added in the last release from memory. Basically it lets you make a view into a normal table which is dynamically updated by the database either on the fly, or on demand. You can also create... read more »

• "Style Bleed" Problem Fixed In POI Utility Tags

  Posted on Oct 6, 2008 at 11:30 AM

  I was banging my head against the wall with a bug I had using the POI lib and upgraded my local version. I seem to remember reading that the image stuff is newer than the ancient CF version. The bug by the way was using the cell aliases but accidently naming the alias with the @ prefix... which mea... read more »

• "Style Bleed" Problem Fixed In POI Utility Tags

  Posted on Oct 6, 2008 at 10:59 AM

  Hey Ben, is it possible to add support to the poi library to allow embedding images into an excel document? I am specifically thinking about taking a PNG CFCHART and embedding it into excel http://poi.apache.org/hssf/quick-guide.html #Images Glad you enjoyed my post about my blogs name :)... read more »

• Creating Excel Files Faster With ColdFusion And POI Custom Tag Updates

  Posted on Aug 1, 2008 at 10:33 PM

  can you add the related blog entries to the project page?... read more »

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

  Posted on Mar 27, 2008 at 8:08 PM

  for people using oracle, there is a good discussion on the pro's and con's about binding or not binding with a static value http://www.oracle.com/technology/oramag/oracle/08-jan/o18asktom.html as for the stored procedures, it's a lot easier to tune a CF application which doesn't use stored proce... read more »

• Maintaining Line Breaks In An HTML-Excel File

  Posted on Dec 21, 2007 at 12:54 AM

  That's great to know :) the problem with the pseudo html xls files is that excel chokes when the file gets too big the way around that is then to wack your data into a database and then suck it in via odbc into excel, but use '~' or '|' as your new line character and then do a search a replace on ... read more »

• Exercise List: Designing The Database Schema

  Posted on Oct 22, 2007 at 10:19 AM

  i assume everything is a table and therefore don't prefix tables, i preview views with V_ or MV_ for a materialised view. i use mostly oracle (which ignores case) and avoid camel casing and use underscores for formatting, which i carry over in to my CF naming things in a database is a real form :... read more »

• Exercise List: Designing The Database Schema

  Posted on Oct 22, 2007 at 9:26 AM

  So how do you refer to the ID named pk in terms of urls and form fields?... read more »