The Robertson Team




























  Programmers' Tools >  The Free Stuff >  ZIPMonger >  Installation & Use

Installation & Use
  1. Get a ZIP Code database.  There are many commercial and free databases out there.  Several other ZIP radius tags have data in them that you can use.  We purchased this database for US$39.95.  It gave us all we needed plus its up to date.
  2. Optimize your database.  Most -- especially the commercial ones -- aren't laid out particularly well.  They contain fields that are too long, are improperly indexed and have extra fields that are just baggage if all you want is a ZIP code radius, which requires only a ZIP code, a city name and fields for latitude and longitude.  We include a template that will make a new, clean copy of the above commercial database, but you can adapt it to your own needs should your database need similar help.
  3. Set up and run ZipTest.cfm.  This is the very simple zip code radius tester. All you need is to put the proper parameters (datasource name, field names etc.) into your call to ZIPMonger.  Its very simple.
  4. Fine-Tune for Best Performance.  In addition to optimizing your database, your final tuning step is to properly set the MaxRadius parameter to match up with the maximum search radius that you plan to use.  Simple instructions on how to do this are within the ZIPMonger tag itself.

The Robertson Team,
1.559.360.1717 is a leader in ColdFusion web hosting and managed dedicated servers.