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…
MySQL full text search w/ relevance percentage
We're using an FAQ table below, to demonstrate how to return a result set that includes the keyword relevance as a percentage of the maximum…
JavaScript Date object – 0 offset Month
I find the Javascript Date constructor to be a little non-intuitive, primarily because the Month is 0 offset, but the day is not. The script…
Make those SQL queries chunky
I'm by no means saying that my tests below are evidence enough to support the case for "chunky" SQL queries. By chunky, I mean queries…
Labelling form fields without using labels – Method II
Here's a handy method I came up with to "move" labels inside form fields, to save real estate. It also degrades gracefully if the user…