Here's the TLD country codes from IANA:
http://www.iana.org/cctld/cctld-whois.htm
That's about as complete as you're going to get.
-Original Message-
From: Kris Pilles [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 19, 2002 11:02 AM
To: CF-Talk
Subject: RE: [OT][OT] Country List
Does anyone have a table or list of all the countries in the
world that
I could have a copy of?
Thanks.
-Original Message-
From: Everett, Al [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 19, 2002 10:58 AM
To: CF-Talk
Subject: RE: [OT][OT] Zip Code Lookup
Nothing like the source: http://164.109.64.170/front2.asp
-Original Message-
From: Greg McDaniel [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 19, 2002 10:19 AM
To: CF-Talk
Subject: RE: [OT][OT] Zip Code Lookup
Is there a Zip Code lookup that includes the Zip Code + 4?
It would be a huge database.
--Greg
-Original Message-
From: jon roig [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 18, 2002 1:53 PM
To: CF-Talk
Subject: RE: [OT] Zip Code Lookup
If you're using the JCSM database, here's a simple query to
pull out all the
zips within #radius# number of miles.
!--- zip search is here ---
CFPARAM NAME=Radius DEFAULT=50
CFQUERY NAME=geoCode DATASOURCE=Zip_Search
SELECT lat, lon, Zip, LastLineCity, State
FROM jcszip
WHERE Zip = '#zip#'
/cfquery
!--- find cities close to a given zip ---
CFQUERY NAME=findLocal DATASOURCE=Zip_Search
SELECT jcszip.Zip,
jcszip.LastLineCity,
jcszip.State,
jcszip.Lat,
jcszip.Lon
FROM jcszip
WHERE (((jcszip.lat)= (#geoCode.Lat# - (#Radius# * 0.0005)) And
(jcszip.lat)= (#geoCode.Lat# + (#Radius# * 0.0005))
) AND ((jcszip.lon)= (#geoCode.Lon# - (#Radius# * 0.0005)) And
(jcszip.lon)= (#geoCode.Lon# + (#Radius# * 0.0005))
))
ORDER BY jcszip.Zip
/cfquery
We purchased this fairly recently and we love it.
-- jon
-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 15, 2002 5:04 PM
To: CF-Talk
Subject: Re: [OT] Zip Code Lookup
charlie griefer wrote:
I'm building an application where i need to do the
'search within x
miles of zip code 12345'
Can anybody make a recommendation? The client would like
something
that offers updates fairly regularly. Maybe even some
sort of XML
feed direct from the (a) source?
Any leads would be greatly appreciated.
Oh, and would be nice if it integrated easily with CF (to
kinda bring
this question a little bit on topic) :)
Strategy and options depends quite a bit on the usage
pattern and the
financial room. I will just presume it is for nearest
outlet matching
for now.
If it is for the occasional lookup, I am sure there are webservices
where you can pay per hit. Easy and all the database maintenance is
done for you by the remote partner. But it might be a bit clumsy if
you get back a long list of ZIP codes that you then have to match
against your own database of outlets. And if you get a lot of hits,
paying per hit might not be the best model.
Another option would be to buy a ZIP database with
subscriptions for
updates and a bunch of tags for running queries on them.
But again, it
might be a bit clumsy if you want to match those results
with another
database of outlets.
The last option is to buy the ZIP database and built your
own search
system for it. It really isn't that hard to make the database do
distance calculations based on lat/lon pairs, and unless you have a
very special set of datapoints using a smart algorithm and some
indexing will
make it very fast, especially since you can do the outlet
matching in
the database as well.
I would probably go for option 3, unless there is a business
reason for
doing number 1. Let me know if you want some code for option 3.
Jochem
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.