RE: List of States and Provinces

2004-06-20 Thread Qasim Rasheed
Here is one that you can use. -Original Message- From: Mickael [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 16, 2004 8:02 PM To: CF-Talk Subject: List of States and Provinces Hi All, Can someone point me to a link where I can download a list of all the US States and Canadian

Re: List of States and Provinces

2004-06-17 Thread Adam Howitt
Message - From: Joe Eugene [EMAIL PROTECTED] Date: Wed, 16 Jun 2004 23:49:14 -0400 Subject: RE: List of States and Provinces To: CF-Talk [EMAIL PROTECTED] You can download the list from usps.com/ups.com etc. I would put the abbreviations/names in the database and store them in dataCache.cfc

List of States and Provinces

2004-06-16 Thread Mickael
Hi All, Can someone point me to a link where I can download a list of all the US States and Canadian Provinces Ideally a delimited file of some kind where the actual Abbreviation is used like NY, New York Thanks in advance. Mike [Todays Threads] [This Message] [Subscription] [Fast

Re: List of States and Provinces

2004-06-16 Thread Rick Root
Mickael wrote: Can someone point me to a link where I can download a list of all the US States and Canadian Provinces I have a real nice custom tag that does this that I wrote about 5 years ago.. but it's encrypted and I've misplaced the original source.Is there any way to unencrypt a .cfm

Re: List of States and Provinces

2004-06-16 Thread Rick Root
CFSET US_Abbreviations=AL;AK;AZ;AR;CA;CO;CT;DE;FL;GA;HI;ID;IL;IN;IA;KS;KY;LA;ME;MD;MA;MI;MN;MS;MO;MT;ME;NV;NH;NJ;NM;NY;NC;ND;OH;OK;OR;PA;RI;SC;SD;TN;TX;UT;VT;VA;WA;DC;WV;WI;WY CFSET

Re: List of States and Provinces

2004-06-16 Thread Adrocknaphobia
Mickael, Shoot me an email off list I can send you an excel file I put together a few months back. -Adam Wayne Lehman - Original Message - From: Mickael [EMAIL PROTECTED] Date: Wed, 16 Jun 2004 20:02:20 -0400 Subject: List of States and Provinces To: CF-Talk [EMAIL PROTECTED] Hi All

Re: List of States and Provinces

2004-06-16 Thread Matt Robertson
Will this do?Its a full select statement.The provinces are at the bottom. select name=States option value=AKAlaska option value=ALAlabama option value=ARArkansas option value=AZArizona option value=CA selectedCalifornia option value=COColorado option value=CTConnecticut option value=DCDistrict of

RE: List of States and Provinces

2004-06-16 Thread Joe Eugene
you dont have to loop through to display them. The abbreviation can be displayed in the selection. Joe Eugene -Original Message- From: Mickael [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 16, 2004 8:02 PM To: CF-Talk Subject: List of States and Provinces Hi All, Can someone point me