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 Scotch On The Rocks (SOTR) 2011 (Edinburgh) with:

AJ

Member since Dec 11, 2008

Recent Blog Comments By AJ

  • Why NULL Values Should Not Be Used in a Database Unless Required

    Posted on Aug 22, 2007 at 1:07 PM

    One more thing Jack. How many companies within my community that are called NA? no idea. If that is the case, they will need to spell out the whole name. Or they can call it NA Inc. Actually this happened to me - I wanted to create a Yahoo account with the word NETWORK, guess what, I got an error... read more »

  • Why NULL Values Should Not Be Used in a Database Unless Required

    Posted on Aug 22, 2007 at 12:55 PM

    Not quite Jack. When you create an account thru my site, the company info is Optional, therefore, when someone do a search for a particular item, all companies with NA are excluded from the search, no companies with NA will get displayed in the search results. The way I setup my system is that a m... read more »

  • Why NULL Values Should Not Be Used in a Database Unless Required

    Posted on Aug 22, 2007 at 12:52 AM

    Hello Ben, Chris & Everyone - I appreciate your valuable input. My website is up & running now. After reading your comments, I decided not to use Null altogether, which really helped me with my coding. In my situation, when a user creates an account for Classifieds, they have an option to add thei... read more »

  • Why NULL Values Should Not Be Used in a Database Unless Required

    Posted on Aug 17, 2007 at 2:50 AM

    I am running this query in CF <CFQUERY Name="GetCompanyName" datasource="DS123"> SELECT CompanyName, date_approved FROM CompanyProfile WHERE CompanyID = #Val(CompanyID)# and date_approved is not null and CompanyName is not null </CFQUERY> But this query is still returning Co... read more »