Live data from Hacker News

We have an employee whose last name is Null. He kills our employee lookup (2012)

stackoverflow.com

111–120 of 245 posts

Re: We have an employee whose last name is Null. He kills our employee lookup (2012)

#111

Earlier quoted context omitted.

If I could change one thing about human history, I'd remake the 0 and O's (# and letter) and the I, l, and 1 (letter i, letter L, and #) so you could never confuse them in hard to read CAPATCHs.

Depending on the font sometimes even 5 and S and 8 and B too.

Having 0 and o next to each other on a keyboard is great too.

Re: We have an employee whose last name is Null. He kills our employee lookup (2012)

#112
post #65
post #4

As long as we're playing the "Falsehoods Programmers Believe About Names" game again, here's the relevant patio11 article: http://www.kalzumeus.com/2010/06/17/falsehoods-programmers-b... If you try to validate names, or if you don't safely escape names along with your other user-input strings, you're gonna have a bad time.

One thing that's annoying to me is that governments and employers increasingly believe many of these things, partly because they want to cross-reference names and match canonical forms. My given names in English are Mark Jason, and that's on my birth certificate. In Greek, they're Μάρκος Ιάσονας, which are the equivalents, and that's on my municipal birth records there (registered as a foreign birth at the time of ba…

I feel your pain, although we Romanians use the (standard?) latin alphabet. I had to spell 'Andrei Simionescu' over the phone so many times that I'm sure I could win a couple of spelling bees easily.

Speaking of which, why don't all companies just move to automated support systems already? These guys are doing it right http://www.zocdoc.com/

Re: We have an employee whose last name is Null. He kills our employee lookup (2012)

#114
post #108
post #42

Earlier quoted context omitted.

My name fail to register surprisingly often, even here in Brazil. It is Hélder Maurício Gomes Ferreira Filho Common reasons for failure is being too long and having non ASCII characters, but sometimes it fails for other reasons, for example do not allow me to register without a middle name ( I don't haven't one actually... ), me confused and not knowing how to register Filho ( it is not a family name, neither a surna…

As a Portuguese speaker, i can say i would never write Hélder correctly if i simply hear it.

For a long time I did not even knew how to pronounce Hélder.

The thing is Dutch...

I am Hélder because of my father.

He is Hélder, because of the priest "Dom Hélder Câmara" (my Grandma was very Catholic)

Dom Hélder Câmara was named after the city of Den Helder in the Netherlands: http://en.wikipedia.org/wiki/Den_Helder

The result is kinda wonky (lots of people write it wrong, usually "Elder" that of course resulted into video game savy friends nicknaming me "Mr. Scrolls")

Re: We have an employee whose last name is Null. He kills our employee lookup (2012)

#115
post #45

Earlier quoted context omitted.

Python makes a distinction between types, but it has a concept of falsyness (as do many languages, though it is often more restricted e.g. in Ruby only false and nil are falsy IIRC). Falsyness is used in boolean-ish contexts (if, while and explicit boolean conversion), by default all of None (null), False, 0, 0.0, "" (the empty string, unicode or binary) and empty collections ([], (), {}, set()) are falsy and althoug…

GForth uses 0 for 'false' but -1 for 'true'... that confuses me a lot.

I expect that it's because in twos complement representation -1 is represented as all bits set.

Re: We have an employee whose last name is Null. He kills our employee lookup (2012)

#116
This problem isn't about funny employee names. It's about thick, untransparent software stacks that make simple problems difficult.

SOAP is maybe the most popular example and this is really why it's lost popularity against REST. However, similar "It works with values W, X, Y, but not Z" situations are found in any stack or standard that has too much magic going on. Rails certainly comes to mind.

This is the biggest argument in favour of using many small, isolated components rather than one big all-encompasing framework, in my opinion. If every piece of third party functionality you import into your project can be easily understood, problems like these shrink in size, because there's a limit to how deep the magic can go.

I'm very fond of the Node.js ecosystem for particularly this aspect (even though I dislike the language). There's a big bucketload of tiny components there, rather than 90% of the community relying on a single humongous framework, like is common for e.g. Ruby or C#.

Re: We have an employee whose last name is Null. He kills our employee lookup (2012)

#117

If my last name were Null, I'd totally call my son Dave!

I do actually know a man called Dave Null. I thought that must be very rare, but in fact, LinkedIn finds 116 hits if you search for him: http://www.linkedin.com/pub/dir/Dave/Null

http://names.whitepages.com/last/Null

Re: We have an employee whose last name is Null. He kills our employee lookup (2012)

#118
post #99
post #32

Earlier quoted context omitted.

Welcome to the world of (a) standards (b) poorly implemented standards (c) poorly implemented programmers :-)

Humanity needs an update, bad. I'm expecting one within 100 and 1,000 years from now, but the chances of introducing regressions is very high.

I'd rather wish for a good update...we've had too many bad updates so far ;)

Re: We have an employee whose last name is Null. He kills our employee lookup (2012)

#119
post #94
post #53

A Japanese company once made the decision that they needed "virtual" employees in a particular system, for example to support e.g. adding a job to the org chart before that position had been filled (and another dozen use cases), so they had the clever idea "Hey, if we need to do this, we'll just input their 'name in Japanese' as one of a dozen status flags, like XX_JOB_REQUEST or XX_INCOMING_TRANSFER." One developer…

I'm actually curious now, was your (or whoever became the victim of this code) "Japanese name" not in the system in katakana or something?

That was imprecision because I was trying to avoid the quick discussion of Japanese orthography. Like most systems in Japan dealing with names, there are separate fields for 漢字名 and カナ名. (Some systems also have ローマ字名.)

Japanese systems have wide, wide variability in what they do for 漢字名 for people who, ahem, don't have one. Some repeat the カナ名. Some do so but use half-width kana (半角 vs. 全角). Some managers who believe that there is such a thing as an "official name" think that one's official name should go in 漢字名, regardless of whether it is 漢字 or not.

A related problem: what happens when you have two systems which have different behaviors on this? For example, let's say you're a Japanese bank, and your branch employees were instructed in 2012 to update any 漢字名 of foreigners to be the name written on their foreigner registration card, in double-width characters. Let's further suppose that your web tier does Javascript validations when you try to sign up for online banking, and because any engineer can see that DOUBLEWIDTH latin characters are not 漢字, this means that it is literally impossible for the web tier to match the DB for affected customers.

Hilarity ensues.

Re: We have an employee whose last name is Null. He kills our employee lookup (2012)

#120

Earlier quoted context omitted.

Growing up, my parents called me by my middle name, as I share a first name with my dad. (I'd rather be an Edward than a Ralph anyway.) When giving my name to someone, I tell them I'm Edward , as telling them I'm R. Edward just sounds pretentious. But if I'm beginning a relationship with a doctor's office or lawyer, or filling in a tax form, it's Ralph E. Lastname, because that's what's on my birth certificate and SS…

Try just answering the phone with "hello?" for unknown numbers.

At home, I only pick up for known numbers, and let the answering machine screen the rest. At work, they kind of expect you to identify yourself when you pick up the phone. But yes, what you suggest is a workable alternative, where allowed.
Post reply on HN