I use fairly vanilla SQL most of the time so I was shocked to read this post on the PostgreSQL list when I ran into some slowness with a NOT IN query. While my experience is with Postgres, apparently this works with most databases.
If you have a NOT IN with a subquery that returns […]

I know I have my patterns - I get my computer set up and for the next 2 years I leave it nearly as-is. Then I get a new machine (Lenovo X61) and it’s time to see what’s new out there.
I did that search four weeks ago when installing Thunderbird and came across some […]

Mozilla just released Sunbird and Lightning 0.8, the calendar project of the Mozilla Group. I’ve been using the combination of Thunderbird, Lightning/Sunbird and a GTD tool called ThinkingRock for over a year now. The problem is that my calendar files have grown and the calendar would take sometimes as long as 5-10 seconds […]

I couldn’t find this easily with TEH GOOGLE so I present to you here, a complete list of the built-in properties that you can access using Ant. If you don’t know what Ant is and you’re a developer, then you probably don’t use deployment scripts and should be whipped. Check out Jim Priest’s […]

I needed to find where I was at in a table so I could report back the row and cell position for another function. There aren’t any easy-to-find answers from the Google so I set about doing my standard Javascript DOM exploration:
for (var ii in this)
console.info(” ii = ” + ii);
I explore […]

A really interesting thread on CFGURU today discussing how to minimize the impact of clients that don’t accept cookies from rapidly creating “phantom” sessions that eat up memory. Because the client doesn’t accept a cookie, each request will appear to be a new client and ColdFusion will generate a new session along with any […]

Christian and I collaborated the other day on a new feature for the excellent jQuery plugin, TableSorter. I can only take credit for the idea as Christian made the magic happen. This addition makes it now possible to sort any content, whether it be a form field, inside markup, etc.
The Situation
For simple data […]

So I know he has a speech writer but love him or hate him, you can’t deny this guy is a different kind of candidate. The video is a bit long but hits the nail on the head why Barack Obama should be our next president: he gets the issues. Not the “everyone is […]

I love crazy long titles that make highly qualified claims. So as the title says, this is, in my humble opinion, the best available regular expression for ColdFusion developers who validate email addresses of everyday English-speaking users. Here is what I used to use, from cflib.org. This one is good because the […]

While I’m not a designer, I do need to pop open Photoshop on a regular basis and save off graphics or make small changes. I often need to create a rounded corner rectangle when processing customer logos for theming and I never remember how to do it quickly. This tutorial shows the best […]