Re: list of countries and territories
That is awesome.. thanks Russ! On Mon, Dec 3, 2012 at 1:03 PM, Russ Michaels wrote: > > http://countrylist.net/ > > > On Mon, Dec 3, 2012 at 6:43 PM, Greg Morphis wrote: > > > > > Does anyone have or know of a good list of delimited countries and > > territories I can use and import into my DB? > > > > Thanks > > > > > > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353354 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: list of countries and territories
http://countrylist.net/ On Mon, Dec 3, 2012 at 6:43 PM, Greg Morphis wrote: > > Does anyone have or know of a good list of delimited countries and > territories I can use and import into my DB? > > Thanks > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353352 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: List of Countries
No prob..I use that as well as my handy-dandy state list (which thankfully doesn't change) all the time! ;-) On 3/12/07, Mike Kear <[EMAIL PROTECTED]> wrote: > Thanks Ken,I'd have given James the link but its so long ago I had > forgotten where it was. > > But it's not all that bad, its not like there's new countries coming > along all the time. However there are more changes than you'd think. > Counties changing their official names as politics/coups/regimes > change mostly rather than countries splitting off or merging. > > 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 3/13/07, Ken Wexel <[EMAIL PROTECTED]> wrote: > > http://www.unece.org/etrades/download/downindex.htm > > > > Down toward the bottom is a country/iso code download link... > > > > On 3/12/07, James Edmunds <[EMAIL PROTECTED]> wrote: > > > Mike, > > > > > > I would love to know if you have link to the UN source of the CSV etc., so > > > that I could download and make my own mods, re-visit periodically to get a > > > freshened list, etc. > > > > > > Thanks in advance, > > > > > > James > > > > > > > > ~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272483 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: List of Countries
Thanks Ken,I'd have given James the link but its so long ago I had forgotten where it was. But it's not all that bad, its not like there's new countries coming along all the time. However there are more changes than you'd think. Counties changing their official names as politics/coups/regimes change mostly rather than countries splitting off or merging. 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 3/13/07, Ken Wexel <[EMAIL PROTECTED]> wrote: > http://www.unece.org/etrades/download/downindex.htm > > Down toward the bottom is a country/iso code download link... > > On 3/12/07, James Edmunds <[EMAIL PROTECTED]> wrote: > > Mike, > > > > I would love to know if you have link to the UN source of the CSV etc., so > > that I could download and make my own mods, re-visit periodically to get a > > freshened list, etc. > > > > Thanks in advance, > > > > James > > > > ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272481 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: List of Countries
http://www.unece.org/etrades/download/downindex.htm Down toward the bottom is a country/iso code download link... On 3/12/07, James Edmunds <[EMAIL PROTECTED]> wrote: > Mike, > > I would love to know if you have link to the UN source of the CSV etc., so > that I could download and make my own mods, re-visit periodically to get a > freshened list, etc. > > Thanks in advance, > > James > > > > On 3/12/07, Mike Kear <[EMAIL PROTECTED]> wrote: > > > > There's an "official" country list - its a UN publication. It's in > > CSV and other formats. The database i have has the fulll country > > name, the common abbreviations, and I've added the country dialling > > codes to mine so i can validate phone numbers to an extent. > > > > I can send you a copy if you want. > > > > 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 3/13/07, Peter Tanswell <[EMAIL PROTECTED]> wrote: > > > Hi there > > > > > > Just wondering if anyone knew of a source where I can obtain a list of > > countries. Hopefully in a format that I can import into a table in a > > database. > > > > > > Thanks in advance. > > > > > > P > > > > > > > > > > > > ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272479 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: List of Countries
Mike, I would love to know if you have link to the UN source of the CSV etc., so that I could download and make my own mods, re-visit periodically to get a freshened list, etc. Thanks in advance, James On 3/12/07, Mike Kear <[EMAIL PROTECTED]> wrote: > > There's an "official" country list - its a UN publication. It's in > CSV and other formats. The database i have has the fulll country > name, the common abbreviations, and I've added the country dialling > codes to mine so i can validate phone numbers to an extent. > > I can send you a copy if you want. > > 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 3/13/07, Peter Tanswell <[EMAIL PROTECTED]> wrote: > > Hi there > > > > Just wondering if anyone knew of a source where I can obtain a list of > countries. Hopefully in a format that I can import into a table in a > database. > > > > Thanks in advance. > > > > P > > > > > > ~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272478 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: List of Countries
There's an "official" country list - its a UN publication. It's in CSV and other formats. The database i have has the fulll country name, the common abbreviations, and I've added the country dialling codes to mine so i can validate phone numbers to an extent. I can send you a copy if you want. 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 3/13/07, Peter Tanswell <[EMAIL PROTECTED]> wrote: > Hi there > > Just wondering if anyone knew of a source where I can obtain a list of > countries. Hopefully in a format that I can import into a table in a > database. > > Thanks in advance. > > P > > ~| ColdFusion MX7 and Flex 2 Build sales & marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272474 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: List of Countries
I exported one I've been using in my store app. Maybe you can use it. Has alotta countries. wtomlinson.com/countries.sql Will ~| Create Web Applications With ColdFusion MX7 & Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272472 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: List of Countries
Perfect - Thank You. Thanks, Mark -Original Message- From: Tom Nunamaker [mailto:[EMAIL PROTECTED]] Sent: Sunday, July 07, 2002 10:10 PM To: CF-Talk Subject: RE: List of Countries How about this? http://www.the-acr.com/codes/cntrycd.htm Just do a search on google. You'll find lots of them like this. Tom -Original Message- From: Mark Leder [mailto:[EMAIL PROTECTED]] Sent: Sunday, July 07, 2002 9:04 PM To: CF-Talk Subject: List of Countries Anybody know where I may find a list of countries of the world with their corresponding 2 - digt telephone country codes? Thanks, Mark __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: List of Countries
How about this? http://www.the-acr.com/codes/cntrycd.htm Just do a search on google. You'll find lots of them like this. Tom -Original Message- From: Mark Leder [mailto:[EMAIL PROTECTED]] Sent: Sunday, July 07, 2002 9:04 PM To: CF-Talk Subject: List of Countries Anybody know where I may find a list of countries of the world with their corresponding 2 - digt telephone country codes? Thanks, Mark __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists