Chagrin
23 Jan, 2004
It doesn't happen as often as one might expect, but every now and again I get bitten on the ass by the fact that most of my programming knowledge has been acquired on an as-I-go basis.
Today I spent far longer than necessary wondering why my lovely MySQL concatenation query kept returning NULL.
It wasn't until I did a Google search for MySQL CONCAT returns NULL that I was directed to the MySQL Manual, where I read that CONCAT always returns NULL if any of the referenced fields are NULL
In other words, I should have Read The Fine Manual to begin with.
Popular
Recently Perused
- It's about time http://flic.kr/p/8GcTE9 — 3 years 42 weeks ago
- Don't use twitter much any more, ayuh. — 3 years 44 weeks ago
- Lazyweb: Does there exist a #drupal module for selectively disabling CCK fields without deleting them? Perhaps field permissions... — 3 years 44 weeks ago
- New post: Old Joe (Minstrel Banjo) http://tinyurl.com/3yyg8g9 — 3 years 47 weeks ago
- New post: Emacs Org-mode: Custom agenda that filters by date AND tag http://tinyurl.com/2vnrcl2 — 3 years 47 weeks ago