Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.
I am the chief technical officer at InVision App, Inc - a prototyping and collaboration platform for designers, built by designers. I also rock out in JavaScript and ColdFusion 24x7.
Meanwhile on Twitter
Loading latest tweet...
Ben Nadel at CFUNITED 2008 (Washington, D.C.) with:

Tom Eldredge

Member since Feb 8, 2012

Recent Blog Comments By Tom Eldredge

  • The Anatomy Of An INNER JOIN Query In SQL

    Posted on Aug 5, 2014 at 4:24 PM

    Harvey: I agree with most of what you say, but I still contend that using JOIN is better, especially when you are talking about OUTER JOIN. Putting the table-joining stuff into the ON clause for both means you don't have to worry about if you need to deal with the NULL condition; an INNER JOIN will... read more »

  • The User Experience (UX) Of Color Contrast In A Call-To-Action

    Posted on Apr 2, 2014 at 10:12 AM

    On a related note, the first time I used Outlook, I *completely* missed the "Send" button. For those that haven't seen it, it is *HUGE* and right next to the "To" field. This page has a screenshot (from MS, titled, "I cannot find the Send button"): http://office.micro... read more »

  • Getting Header Values From A ColdFusion Request

    Posted on Dec 26, 2013 at 11:47 AM

    Ack! Here's another side effect of this. Some of these variables are available as non-scoped variables (or at least I could not find them in any of the scopes named in the CF documentation). In one script, we have (now "had"!) code that uses "origin" as an unscoped variable. It ... read more »

  • The Anatomy Of An INNER JOIN Query In SQL

    Posted on Aug 5, 2013 at 1:44 PM

    @Mark: Have you checked those kinds of queries in an optimizer? It seems like, because of the parentheses, the optimizer would *have* to run the queries inside of the parens first, so the first one would get all user records with id=1 (fine), but the second would get all account records where ended... read more »

  • The Anatomy Of An INNER JOIN Query In SQL

    Posted on Aug 5, 2013 at 1:39 PM

    Ok, *technically* SQL is based on set theory. If you have never studied SQL on a formal basis, and are interested, the C.J. Date book is *the* book on SQL. Quick overview: in SQL, a table is really just a set of records. The SQL language is a way of specifying subsets, intersections, and unions (ma... read more »

  • The Anatomy Of An INNER JOIN Query In SQL

    Posted on Aug 2, 2013 at 10:30 AM

    From your other article: "Personally, I just like to put in the ON clause because that's the point where I think about the relationship between tables" -- Ben From that, I think you should NOT put the "u.id = 1" part in the ON clause. It has *nothing* do with the joining of tab... read more »

  • ColdFusion Arguments Object Can Act As Ghetto Pass-By-Reference Array

    Posted on Jul 16, 2013 at 9:08 AM

    First -- yes, I know this is an old topic. However, I ran into a problem the other day relating to arguments and arrayClear. For example: <cfset girlsArray = [ "Janice", "Janine", "Jaleen", "Jody" ] /> <cfset restart(girlsArray) /> <!... read more »

  • Strange Interaction Between DeserializeJson(), ArrayContains(), And Database Values In ColdFusion

    Posted on May 22, 2013 at 11:07 AM

    Could your problem be that "users.id" is actually an ARRAY, not a single value? Perhaps try it again with "users.id[1]" (I only have CF8 here at work).... read more »

  • My Safari Browser SQLite Database Hello World Example

    Posted on Feb 8, 2012 at 6:58 PM

    @Amy: I can't see your code, but I implemented something very similar to this, and the error reporting is non-existent without callbacks. I ended up adding callback functions for both success and failure (with alerts ... ugh). I had a problem where the table I had created was missing a column, so... read more »