Tom Eldredge

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