January 31, 2007
Battling Comment Spam
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.
January 18, 2007
Calculating Distance in Miles from Latitude and Longitude
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).
January 13, 2007
Anyone used MacFuse?
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.
January 11, 2007
Finding the Last Modified Date on a File
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
FILE.TimeLastModified.
January 10, 2007
Backwards LIKE Statements
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.
January 10, 2007
Reverse IP Address Lookup with 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", "java.net.
January 10, 2007
Top 10 Underrated Functions in 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.
January 04, 2007
How to Confuse with Color
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.
January 04, 2007
Toggle a Bit with SQL
January 03, 2007
It's harder to get on del.icio.us/popular these days
The folks at del.icio.us must have made it harder to get on to the del.icio.us/popular page over the past few months.When I first was listed on there you simply needed 10 bookmarks within the past 24 hours.
January 02, 2007
MySQL Optimization Hints
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.





