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
- Why did it take me this long to realize that MultiMarkdown will convert Markdown to Latex for you? Intriguing possibilities. — 4 years 11 weeks ago
- Protip: Don't use a handy drupal form screenshot to test a CCK imagefield... "WHERE ARE THOSE WEIRD FIELDS COMING FROM???" — 4 years 11 weeks ago
- Burt Mustin sighted in an Adam 12 rerun! — 4 years 12 weeks ago
- George Wendt and William Atherton in 'Re-animator: The Musical'. What more needs to be said, really? #fb — 4 years 12 weeks ago
- Sam Adams Noble Pils after working all day in the sun? Yes sir. — 4 years 12 weeks ago