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() 2013 (Bloomington, MN) with: Elliott Sprehn and Chris Phillips and Nathan Strutz and Anant Pradhan and Dave DeVol and Byron Raines and Gerry Gurevich

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 »