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 cf.Objective() 2014 (Bloomington, MN) with:

Mark

Member since May 12, 2011

Recent Blog Comments By Mark

  • The Anatomy Of An INNER JOIN Query In SQL

    Posted on Aug 5, 2013 at 2:12 PM

    @Tom At least in MS SQL Server 2005 (this is what I have to use at work) it gives the exact same execution plan for all 3 methods... read more »

  • The Anatomy Of An INNER JOIN Query In SQL

    Posted on Aug 5, 2013 at 1:09 PM

    I would of wrote the query the following way FROM (SELECT * FROM user where id=1)U inner join (select * from account where endedat is null)a on a.userID=u.id inner join (select * from billing_information where isPrimary =1)i on i.userID = u.id Instead of the * I usually specifilly list only the c... read more »

  • Change In ColdFusion Date::getTime() Method In ColdFusion 10

    Posted on Oct 1, 2012 at 6:46 PM

    I only have coldfusion 8 and 9 on this computer so cant test at moment but I believe this has more to do with a change on how coldfusion store time then with a change with the gettime() function. What I mean is in coldfusion 9 and earlier the time zone of the data is not part of the data set. The... read more »

  • Running ColdFusion Queries Inside CFSript Tags

    Posted on May 12, 2011 at 6:07 PM

    Blah ignore my last post. Completely forgot that actually a user made function and not part of ColdFusion language. That what I get for trying to think after work.... read more »

  • Running ColdFusion Queries Inside CFSript Tags

    Posted on May 12, 2011 at 5:33 PM

    A few years late but cfquery has been supported in script tags since coldfusion 7 at the latest. Where I work we still stuck using coldfusion 7. The format is <cfscript> SQL_STRING = "SELECT " & "id, " & "name, " & "hotness " & "F... read more »