Case Sensitivity in MySQL

Yesterday I spent more than an hour trying to get a MySQL export from a Windows machine to play nice with a Unix server. This problem was compounded by Windows hiding a configuration file from me. Luckily for you, I eventually solved my problem and decided to write another Mistakes story.

The setup

Recently, I did some pro-bono consulting work for a client. As part of our agreement I made it clear that I would retain the rights to the code I wrote. The reason I did this is because I wanted to be able to give back to the community, and now I am going to do that. The work was made up of six tasks, ranging from trivial to complex. I intend to write six articles based on these tasks. This is the first.

The lists below may seem sparse. This is deliberate. I could give you a laundry lists of every programming language, software package, operating system, and technology buzzword that I have ever worked with. I won't subject you to that. I will just tell you my greatest strength:

I find solutions.

Below you will find my description of how I made a new component for Drupal's webform module that dynamically displays a selection of checkboxes. I will go over why I made it. Then I will explain the code step by step. I have also attached a copy of the file for download.

Do you need to output a code sample onto an HTML page? Just copy the code into the box below, and press "Convert"

Recently, I had trouble with the Mambo contact component. Sometimes, the emails would get through, and other times they would not. There did not appear to be any discernable pattern. In the end, I discovered that an innocent looking word in the subject of the email was causing the message to be blocked by some spam filters.