Chagrin

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.

Syndicate content

Twitter

  • Kudos to bulkregister.com phone support, who helped me transfer a domain to another registrar without any cajolery. 3 years 48 weeks ago
  • Here's how to use your own OpenType or TTF fonts with LaTeX. (Not for the lazy) http://bit.ly/bwJ8uq 3 years 48 weeks ago
  • Columbia http://flic.kr/p/8u9rSF 3 years 49 weeks ago
  • I just became the mayor of Winchendon Post Office on @foursquare! http://4sq.com/bKtAWl 3 years 51 weeks ago
  • I just became the mayor of The Glenn Cafe on @foursquare! http://4sq.com/aJ1btT 3 years 51 weeks ago

Older

Contact

Andy Chase
(978) 297-6402
andychase [at] gmail.com
GPG/PGP Public Key