The solution is simple, but coming to it was quite the opposite. After browsing many posts which don't deal with the fact that external URL…
jQuery search term highlighting
Highlighting keywords from a search can be done on the server-side, by using your development languages string replace functions, but this can add complexity to…
ColdFusion Session Locking – Keep it quick!
Lately I've been noticing, while examining chunks of ColdFusion code out there, that many folks don't give much thought to what goes on inside their…
Python-Excel Cell Background Color
If you've never used Python-Excel before, I can introduce it in a couple words – "Excellent and easy to use library for generating Excel spreadsheets…
HTTP Post doesn’t work – OAuth 2.0 – Google – ColdFusion
I spent many wasted hours this morning debugging a Google OAuth 2.0 response error, and felt foolish when I discovered what I was missing –…
Apply style to a specific table column – using minimal markup
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…