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

  • Score! http://t.co/KVDyULXM 4 years 15 weeks ago
  • @ComcastBill Thanks. 4 years 15 weeks ago
  • @wstites Thanks. @comcast is making it awfully hard for me to give them more money. 4 years 15 weeks ago
  • @comcastbill(have called 4 or 5 numbers so far. Am told I don't qualify as existing customer, no way to track who it was who called me.) 4 years 15 weeks ago
  • @ComcastBill I received a call with a bundle offer yesterday, but I lost the rep's contact info. I get the runaround calling the main #. 4 years 15 weeks ago

Older

Contact

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