The example below demonstrates the use of the MySQL CASE statement to cleverly construct a bulk update statement. A huge performance boost over performing individual…
Use DLs instead of tables for key / value lists
If you're looking to display a simple key/value list, such as a list of user's contact information, a table might be overkill. I'd suggest the…
Mod Rewrite w/ HTTP Authentication
Putting a site behind HTTP Authentication is a pretty simple task, but when your site is being served by another application server – let's say…
MySQL AsText returns BLOB
I've seen many posts regarding this issue, but most point to a bug in MySQL 5.0, resolved in 5.1. This may be true, although I'm…
MySQL GeomFromText Polygon returns null
Trying to add a POLYGON using GeomFromText? I don't know about you, but although it's documented as being able to "construct a geometry value of…
ColdFusion function / CFC – dynamic arguments
Passing a dynamic number of arguments to a ColdFusion function is possible, but the method isn't obvious. ColdFusion provides the argumentCollection attribute, which assists the…
Constant Contact REST API – New Subscriber
This is not a typical post, but I just had to share as it took me a good afternoon of trial error to figure out…
Labels activate checkboxes / radio buttons with jQuery
The small jQuery snippet below will make those plain old labels that follow checkboxes and radio buttons active. That is, they will activate/deactivate the checkboxes…