Skip to main content


Member since Dec 11, 2008

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: 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 »

I believe in love. I believe in compassion. I believe in human rights. I believe that we can afford to give more of these gifts to the world around us because it costs us nothing to be decent and kind and understanding. And, I want you to know that when you land on this site, you are accepted for who you are, no matter how you identify, what truths you live, or whatever kind of goofy shit makes you feel alive! Rock on with your bad self!
Ben Nadel