Community Member Profile

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 jus... 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 »

• ColdFusion Query Maintains Current Row Even When Passed By Reference

  Posted on Apr 8, 2008 at 8:01 AM

  I've often wanted to work on query rows in custom tags, but today I needed to use a function. I just finished writing out <cfargument name="row"... when I found this post :) One reason you might want to pass in the row is if you're doing odd/even logic or something that doesn't run in or... read more »