2006/01/25
21:31:12

Simple data integrity

Apparently some places still haven't learned why the ability to have NULL to exist independently of a blank data field is important. Inserting an old date into a data field when it's blank? Wow. As a humorous aspect, note the name of the girl.

Add to del.icio.us Email this entry

By jeff on 2006/01/26 at 08:33:33

I wonder what they do if someone enters a future date. Say the year 2106. Perhaps one would have to be summoned from the dead for jury duty.

I may be a little slow but why is the name humorous?

By Jeremy on 2006/01/26 at 09:32:57

I guess it probably only makes sense if you know Firefly or Serenity.

By Lo on 2006/01/26 at 14:34:04

And let's face it, Kaylee rocks, even if she is a bit of a pansy when it comes to things like danger and other such things commonly found on space ships.

By babada on 2006/01/27 at 09:34:36

Heh, running a DB and accessing it through HTML can get weird because NULL and "" are the considered the same thing. :P

And I'm assuming that the more entertaining part of her name was the combination of first and last names. That was a plot twist I didn't see coming... :)

By Jeremy on 2006/01/27 at 09:37:13

What kind of language/db api are you using that doesn't differentiate?

And yes, that would be a rather funny plot twist.

By Lo on 2006/01/30 at 14:34:41

Mal is way too much like a big bro to Kaylee for that to ever work. It would make things interesting though, especially between Kaylee and Inara.

By Jeremy on 2006/01/30 at 17:43:39

Interesting would be an understatement...