duncan

Recent Blog Comments By duncan

• Ask Ben: Uploading Multiple Files Using ColdFusion

  Posted on Mar 27, 2010 at 10:20 AM

  You don't actually have to specify the value for the action attribute, if you're just posting to the same page. This will work perfectly: <form action=""> Charlie Arehart wrote a good article about this: http://www.carehart.org/blog/client/index.cfm/2007/1/2/form_self_post... read more »

• Ask Ben: Uploading Multiple Files Using ColdFusion

  Posted on May 22, 2009 at 3:53 AM

  Karim: Issue 1. Replace 'file#intFileIndex#' with '#cffile.ServerFile#' - this is the name that CFFile saves the file as on the server. Issue 3. After the file uploads, you could use CFFile.fileSize to check if the size is GT 1Mb.... read more »

• Grouping JOIN Clauses In SQL

  Posted on Feb 3, 2009 at 9:44 AM

  Ben, you rule. This blog post really helped me understand how to formulate a query that I'd been staring at for ages. Mine was slightly more complicated, I had 5 tables to join with a similar rule to your example. SELECT A.ID AS CategoryID, A.Name AS CategoryName, B.ID AS SubCategoryID, B.Name... read more »

• Rick Osborne On Database Indexing And SQL Best Practices

  Posted on Dec 8, 2008 at 11:08 AM

  Great post, thanks BenRick! One thing I remember being taught is to put your most restrictive conditionals first. e.g. in your example I'd maybe put j.contact_role_id = #ContactRoles.CEO# as the first clause... read more »

• MySQL Does Not Support IF / ELSE Statements In General SQL Work Flow

  Posted on Sep 2, 2008 at 2:22 PM

  Can you just use the CASE statement?... read more »

• ColdFusion CFFTP Timeout Value Cannot Be Dynamic

  Posted on Aug 29, 2008 at 12:10 PM

  What happens if you assign 60 * 5 to a variable, and then plug the variable into the attribute?... read more »

• Creating Colors Gradients With ImageUtils.cfc ColdFusion Component

  Posted on Feb 19, 2008 at 1:39 PM

  Hue, Saturation and Value. I did some work on colour gradients not too long ago (automatically working out different menu colours for dynamically nested menus), and I did it using HSV instead of RGB. So I knew I was going from say light red to dark red, which is very easy to do in HSV. At least... read more »

• Creating Colors Gradients With ImageUtils.cfc ColdFusion Component

  Posted on Feb 19, 2008 at 10:17 AM

  Ben, notice the subtle jumps in gradient you get at certain steps. I wonder if you would get an even smoother gradient if you converted RGB to HSV and did all the work there? From what I've done in the past, I don't think it was possible to do a straight Hex-HSV conversion, but had to go through R... read more »