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/states such as New Zealand, Fiji, Hong Kong, East Timor, and many of the tiny European principalities. It's amazing how many times I see forms that require totally inappropriate things for the countries they're being directed at. For example requiring phone numbers in US format (xxx) xxx-xxxx or requiring two character state abbreviations (NSW translates to NS in that case). Then there's the ones that insist on a 5 numeric zip code, but a quick look at a Canadian or UK address will tell you that you can't fit their post codes into that format. Once (years ago) I even had a Hewlett Packard site demand a US social security number, for some software i was trying to download in Australia on an international form!! I had to phone my brother in Indianapolis and ask him for his number so I could complete the form! Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month On Thu, Sep 10, 2009 at 7:21 AM, Roger Austin<[email protected]> wrote: > > ---- Jake Pilgrim <[email protected]> wrote: >> >> > What about the UN list? <http://unstats.un. >> > 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 think you would have to go with each country and find a database > on their government site. I ended up making one for US, Canada, and > Mexico since that is what I needed. I doubt you could trust anything > that tried to collect every division of every country since it could > depend on some cultural/political issues. > It is an interesting issue though. Good luck, Roger > -- > http://www.linkedin.com/pub/roger-austin/8/a4/60 > http://twitter.com/RogerTheGeek > http://www.misshunt.com/ Home of the Clean/Dirty Magnet > http://cfinnc.com/ ColdFusion Conference in North Carolina Oct 17-18 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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/messageid:326182 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
