CF_DealerLocator

I've broken the DealerLocator into 3 separate components, USA, CANADA and ULTRA.  USA contains only the USA zipcodes, CANADA contains only Canadian postal Codes, ULTRA contains both USA and Canadian codes.  Individually, the USA and CANADA databases are available for $79.95 each.  ULTRA is available for $129.95

Don't download it without trying it... real time..!
if it works download it, if not you've not wasted any time

CF_DealerLocator is a Cold Fusion Custom Tag and associated database which returns the zip codes within a radius of a supplied zip code. For example, setting ZipCode to 30066, and Radius to 10(KM), would return all zip codes within 10 KM of 30066. This information is returned in 2 standard comma delimited lists, ZIPSRETURNED and DISTANCERETURNED.

Currently for the shareware version and my "security" only KM (Kilometers) will be issued as a distance from source. The registered version issues Miles. Personally I think given the information available (some 42000 zipcodes & cities/towns) there is going to be a better than 99.5% chance that any zip-code will actually be found. The download will be approximately 1.7MB - lots of data. The locator DOES NOT use the first 3 digits of the zip-code to find a match although it could be modified to do this in case of a non-found ZipCode, it uses the longitude and latitude reference thereby allowing for tri-state areas which other cheap locators don't. Of course, you could always shell out the asking price for "ZipFinder"

This code and single database is available for the exorbitant price of $79.95. Updates cannot be guarateed but if enough people are interested in the locator, I'll buy TIGER from the census office which contains additional and upto date information which would then be distributed under license to registered users.

These returned variables can be used however you wish but probably the most common practice is to use the ZIPSRETURNED as the criteria for a new query to select stores or other business locations by ZipCode from an existing database. It is your responsiblity to supply the database of your own dealers, this code just allows you to find zipcodes within a specified radius:

<CFPARAM NAME="ZIPCODE" DEFAULT="28601">
<CFPARAM NAME="RADIUS" DEFAULT="20">
<CFIF ParameterExists(FORM.ZIPCODE)><CFSET ZIPCODE=#FORM.ZIPCODE#><CFIF>
<CFIF ParameterExists(FORM.RADIUS)><CFSET RADIUS=#FORM.RADIUS#><CFIF>
<CF_DealerLocator zipcode="#ZIPCODE#" Radius="#RADIUS#" DSN="ConfiguredDatasource" ReturnText="1">
<cfquery name="locations" DATASOURCE="MyDSN">
SELECT * FROM businesses
WHERE zipcode IN (#PreserveSingleQuotes(#ZIPSRETURNED#)#)
ORDER BY StoreName ASC
</cfquery>
<CFOUTPUT QUERY="locations">
hey-de-yah...
#locations.address# is #ListGetAt(DISTANCERETURNED,ListFind(ZIPSRETURNED,#FORM.ZIPCODE#))#
</cfoutput>

Payments can now be received via paypal, click the link below