cf_ZipCodeRadius is a ColdFusion Custom tag which will return a query result of all the ZipCodes within a specified Radius.

The tag supports the following databases: Microsoft Access, Microsoft SQL Server.

The tag supports the following version of ColdFusion: ColdFusion 5.0, ColdFusion MX 6.0, ColdFusion MX 7.0.

Included is an MS Access database with ZipCode data, as well as a vtm file for Dreamweaver. The ZipCode data, with Latitude and Longitude information, is from 2004. It can be updated with information from a number of commercial sources.

cf_ZipCodeRadius has the following required attributes:

• Datasource: Allows you to specify the Datasource which contains to your ZipCode information
• ZipCode: The User Supplied ZipCode to use as a center point.
• Radius: The user supplied radius. ZipCodes will be returned within this radius.
• ReturnVar: The Variable to return the resultset. This is returned as a query object.

It also has the following optional attributes:

• TableName: Used to specify an alternate name for the field which contains ZipCode data. Default: tblZipCodes
• CityName: Used to specify an alternate name for the field which contains City name data. Default: chrCity
• StateName: Used to specify an alternate name for the field which contains State name data. Default: chrState
• ZipCodeName: Used to specify an alternate name for the field which contains ZipCode data. Default: chrZipCode
• LatitudeName: Used to specify an alternate name for the field which contains Latitude data. Default: dblLongitude
• LongitudeName: Used to specify an alternate name for the field which contains Longitude data. Default: dblLongitude
• DistanceName: Used to specify an alternate name for the field which contains Distance data. The table does not need a Distance Field, this allows the tag to fit any variable naming convention. Default: dblDistance