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

  • Speaking of the 1990's http://www.hwg.org/ 4 years 15 weeks ago
  • "Oh, I see! You're like a webmaster from the 1990s, except you can't even code HTML." http://bit.ly/dsjBEX #fb 4 years 15 weeks ago
  • Please, please: DO NOT put a hyperlink on a filename unless clicking on said link actually downloads that file. #ihatesourceforge #uxfail 4 years 15 weeks ago
  • RT @ebertchicago:Josh reminds me: If we went back to what the Founding Fathers wanted, as Sarah Palin desires, she wouldn't be able to vote. 4 years 15 weeks ago
  • RT @tommysalami: Great "how I got into horror" blog post by @brittnahjade http://is.gd/c4dj8 Awwww :) 4 years 15 weeks ago

Older

Contact

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