Archive for 2007 » Page 3

Here’s how things should work: someone writes some open source code. You use it and like it. You see there is something that could be better. You help make it better. The cycle repeats. Everyone has better bits.
Enter TableSorter 2.0. After my previous post on TableSorter and my comments [...]

I’ve got a version of Ray’s BlogCFC for another blog with an entry that some spammers latched onto awhile back. Despite that trackbacks were never actually displayed, they were spamming it a couple times per minute. Every day.
First, I switched mod_security (on Apache) to return a 403 Forbidden using the following code:
SecFilterSelective REQUEST_URI [...]

I’m sure most Americans have seen a mobile home on the back of a semi trailer being towed to its new home. It’s not a common sight, but once every few years I see one on the freeway. In New Zealand, they do it with all types of houses. My relative near [...]

RSESSION is a database-backed session management system I built for ColdFusion 4.5 when there was no support for failover and serious issues with locking. It’s been six years since its last release. Last year, Jason Baker provided a CFC-based implementation which I have rolled into the package. I’m releasing this for completeness [...]

I’m sitting here watching Kevin Hoyt’s FlexCamp preso at about 9:40pm. This event is pretty nice… although security here at the Adobe building south of Market in San Francisco is absolutely nazi, this is definitely a cluetrain event. It’s a conversation with 300-something customers here all toying with beta software trying to build [...]

Based on my geocoded zip code database research, I wound up purchasing the ZipList Can-USA GeoCode database. Here’s what I did to get their 848,000-record CSV file into a PostgreSQL database table. First, create a table to hold the data:
CREATE TABLE tblLookupZipCode (
vchCity varchar(33) DEFAULT ” NOT NULL
,booDST boolean DEFAULT false NOT [...]

Anyone else going to FlexCamp on Friday? I’ll be there… look me up. I’ll have a yellow motorcycle helmet with me. And an IBM Thinkpad, in case there are two nerds with yellow motorcycle helmets.
This has been a busy week of camping for me… I spent Saturday at WordCamp 2007 [...]

Since they launched, I’ve used Mailroom to handle customer support email for my company. Mailroom is awesome because it learns your replies and automatically suggests them to future inquiries. After a couple of major upgrades and some mismanagement on our part, the service had broken down for us and we went back to [...]

I’m preparing to migrate my application to a framework like Model-Glue. Because I have 70 tables and a large API already, I’m afraid of the cutting and pasting required to migrate my code to a Bean/DAO/Gateway structure. Brian Rinaldi’s Illudium PU-36 Code Generator would solve my problem except it didn’t support Postgres 8.x [...]

For the past 7 years, archives for the Bay Area ColdFusion User Group mailing list have been private to protect list members from having their addresses harvested.
Today we switched to using ezmlm-www which hides email addresses and provides RSS feeds. By publishing this post, Google and everyone else should pick up on the archives. [...]