AJ

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 »