Adrian Lynch

Recent Blog Comments By Adrian Lynch

• Ask Ben: Limit File Upload Size In ColdFusion

  Posted on Nov 12, 2008 at 3:41 PM

  Really? Why would the file disappear after a cffile action="upload"?... read more »

• Ask Ben: Limit File Upload Size In ColdFusion

  Posted on Nov 12, 2008 at 12:25 PM

  You could dispense with the cftry/cfcatch around the file deletion by using FileExists().... read more »

• SQL EXISTS Exploration (Thanks Christoph Schmitz!)

  Posted on Oct 8, 2008 at 3:57 PM

  Good point! Always good to know a bit more SQL. Isn't it enough we have to learn CF to a high standard! :P... read more »

• SQL EXISTS Exploration (Thanks Christoph Schmitz!)

  Posted on Oct 8, 2008 at 3:49 PM

  But would that go against this: "with MSSQL (2000) it is generally better to use SELECT * in the subquery (instead of SELECT fieldname), because the query optimizer will choose the best index or combination of indexes" SELECT 1 might be the same as SELECT myFirstColumn. I've just changed a query ... read more »

• SQL EXISTS Exploration (Thanks Christoph Schmitz!)

  Posted on Oct 8, 2008 at 3:41 PM

  I'd double check the use of 1 as a column. In MS SQL Server, SELECT 1 is the same as SELECT whatEverYourFirstColumnIs. The same might be true in sub queries and agregate functions.... read more »