[thelist] Province Territories .. was Re: [***list] Andrew's drill-down problem (was: Select - forms)

Michele Foster michele at wordpro.on.ca
Tue Mar 11 21:20:36 CST 2003



----- Original Message -----
From: "rudy" <r937 at interlog.com>

> in canada we have provinces and cities, and people more likely
> know which province they're in, because each one is so large...
> well, except PEI... oh, and i guess Nunavut, which isn't really
> a province, it's a territory, actually it was carved out of
> the northwest territories in 1999, which wreaked no end of havoc
> because its postal code remained NT, causing duplicate keys all
> across the country in database tables which had foolishly
> made the postal code the primary key... but i digress...

Sorry, I hope this isn't too off-topic .. but I wanted to point out
something to what Rudy says above, as I've noticed it on many sites "around
the web" that are using drop-downs for provinces (states).

Nunavut does now have it's own two-letter abbreviation.

NU

Northwest Territories remains as NT.

And another change that I've noticed (just now in fact) .. is that Quebec
has gone back to QC (not PQ anymore???).

Another one that is commonly wrong is Newfoundland and Labrador .. NL  (not
NF).  [If memory serves, this is probably a rececent (last year) change when
the province officially became Newfoundland "and Labrador".

Damned frustrating if one has used the two-letter abbreviation in their
database tables instead of relying on a look-up table.  Well, even a look-up
table wouldn't have helped with Nunavut .. but it would have helped for the
others.

The moral .. use look-up tables .. even if you think the data will "never"
change.  :)

Source:  http://www.canadapost.ca/tools/pcl/bin/default-e.asp  (one can only
hope it is the most accurate :)

Mich
*memory to self to fix the look-up values for NL and QC again*




More information about the thelist mailing list