If you wish to apply a certain CSS style to, say, all rows in the 4th column of a table, you might think assigning a…
SQL Conditional Update – Update only if NULL
When you find yourself needing to update a record column only if the column is currently NULL (where you don't want to overwrite actual data),…
ColdFusion SQL Bulk Insert based on structure keys
I realize this particular requirement might be rare, but it comes in handy when you have an XREF (cross-reference) table which ties two tables together.…
MySQL Bulk Update with ColdFusion
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…