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 in application scope like

instance.states['USA'] = "<option value='AL'>Alabama</option><option
value='AK'>Alaska</option>...";
instance.states['CAN'] = "...."

This way 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 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 Unsubscribe] [User Settings] [Donations and Support]

Reply via email to