Re: (ot) International countries and states/provinces/administrative div. database

http://en.wikipedia.org/wiki/ISO_3166-1 ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/me

Re: (ot) International countries and states/provinces/administrative div. database

There would be a maintenance issue on such a database too, since there are so many changes all the time. You'd want to either be prepared to keep updating it yourself, or look for some kind of subscription service. And dont forget to provide for countries that have no subdivisions/provinces/st

Re: (ot) International countries and states/provinces/administrative div. database

Jake Pilgrim wrote: > > > What about the UN list? > org/unsd/methods/m49/m49alpha.htm> > > Thanks for the reply Roger. This does help with the country side of the data, > do you know of a list like this for the "states" within a country (with > abbreviations)? I

Re: (ot) International countries and states/provinces/administrative div. database

> What about the UN list? org/unsd/methods/m49/m49alpha.htm> Thanks for the reply Roger. This does help with the country side of the data, do you know of a list like this for the "states" within a country (with abbreviations)?

Re: (ot) International countries and states/provinces/administrative div. database

Jake Pilgrim wrote: > > For the life of me I cannot find a complete international Countries/States > database... The best I have found is the GeoDataSource World Cities database, > but I'm having a hard time feeling comfortable with assuming a SELECT > DISTINCT state,country would retur

(ot) International countries and states/provinces/administrative div. database

For the life of me I cannot find a complete international Countries/States database... The best I have found is the GeoDataSource World Cities database, but I'm having a hard time feeling comfortable with assuming a SELECT DISTINCT state,country would return a match for EVERY state,country in t