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

  • I don't think it gets much better than 'Revolver' on vinyl. 2 years 50 weeks ago
  • Have fun at #drupalcon everybody! I hate to break my 3 year streak, but I should be back next year... 3 years 19 weeks ago
  • Just made my first Drupal 7 module, 'Entity Relationships', official: http://bit.ly/h3xnPK #drupal #entities #module 3 years 20 weeks ago
  • Already set up my first #git sandbox project for #drupal: http://drupal.org/sandbox/usonian/1072422 3 years 21 weeks ago
  • Drupal.org is coming back online - just set up my SSH keys for #git. Huge props to the #drupal git migration team! 3 years 21 weeks ago

Older

Contact

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