Battling Comment Spam

coldfusion web Fighting comment spam seams like a never ending battle. I've done a lot over the last few years to try and squash it on my blog.

I started out by implementing a list of words that would trigger the comment to be blocked.

This entry was:

Calculating Distance in Miles from Latitude and Longitude

databases The amount of data out there via API's is increadible these days. For instance you can take an address, and get the latitude and longitude using Google's GeoCoding API.

I am using this API along with some others to build a pretty some interesting stuff (more on that when its public).

This entry was:

Anyone used MacFuse?

apple My brother Steve just pointed me to MacFuse which looks like it will be super handy!

You have been able to setup a remote SSH virtual local file system on linux for a while now. I have wanted to be able to do this on my Mac for a few years now.

This entry was:

Finding the Last Modified Date on a File

coldfusion This question came up on my local CFUG mailing list yesterday:

how can I get the time last updated of the two

documents? I know you can do this with uploaded files using


This entry was:

Backwards LIKE Statements

databases Sometimes you need to think backwards.

Here was the problem. I needed to match up some IP address ranges to the company that owns them.

This entry was:

Reverse IP Address Lookup with ColdFusion + Java

coldfusion java I needed to do a reverse lookup on some IP addresses in a database today. I found that you can do this pretty easily with java, and just as easily with ColdFusion. Here it is:

<cfset inet_address = CreateObject("java", "

This entry was:

Top 10 Underrated Functions in ColdFusion

coldfusion I gave a presentation at my local CFUG yesterday called 10 Underrated Functions in ColdFusion, I plan on doing one for tags as well at some point. Here was my list of functions, in no particular order:

ValueList - Returns the contents of an entire query column in a string list.

This entry was:

How to Confuse with Color

web This screen shot is taken from a Virtuozzo Power Panel, which despite my complaints here, has some nice features for managing a VPS.

As you can see they use a light shade of red for the red zone, and then red for the black zone.

This entry was:

Toggle a Bit with SQL

databases web I am working on a management dashboard for a client, which uses some AJAX here and there.

This entry was:

It's harder to get on these days

web The folks at must have made it harder to get on to the page over the past few months.

When I first was listed on there you simply needed 10 bookmarks within the past 24 hours.

This entry was:

MySQL Optimization Hints

databases Every programmer loves to optimize, even when we know we shouldn't. To satisfy your cravings MySQL has several keywords that can be placed in your SQL statement to give the database server an explicit optimization instruction.

This entry was:


did you hack my cf?