songohan
Posts: 89
|
Posted: 04/05/2004, 7:44 AM |
|
good day all!
in one record form I need to include dropdown box with list of countries to selct. What would be easiest way to do that and if someone could send me a list or give a hint where to find one. Country name has to be entered in database with other data on user.
many thanx
andrej
|
|
|
Sixto Luis Santos
|
Posted: 04/05/2004, 3:09 PM |
|
There is a countries table in the database included with CodeCharge Studio
(Internet_PostgreSQL.sql). The countries table definition begins at line 119
and the data at line 437.
Use this table to populate the combobox.
Regards,
Sixto
"songohan" <songohan@forum.codecharge> wrote in message
news:5407170b26b997@news.codecharge.com...
> good day all!
>
> in one record form I need to include dropdown box with list of countries
to
> selct. What would be easiest way to do that and if someone could send me
a
> list or give a hint where to find one. Country name has to be entered in
> database with other data on user.
>
> many thanx
>
> andrej
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
Steve
|
Posted: 04/05/2004, 6:58 PM |
|
The InternetDB that comes with Codecharge Studio comes with a table called "Countries". Just copy it to your own database, and you
re good to go.
|
|
|
songohan
Posts: 89
|
Posted: 04/06/2004, 3:22 AM |
|
huh :)
many thnx
|
|
|
Bill MacLean
|
Posted: 05/14/2004, 12:10 AM |
|
I don't know what the "countries" table in css looks like. I suggest that you use the list specified by ISO 3166-1. The ISO (International Standards Organziation) develops agreed on standards that apply worldwide. For something like Country and Currency codes, ISO lists are the way to go.
Every country in the world has a short name, a long name (optional), a 3 character string code that uses numeral characters only, a three character alpha code, and a two character alpha code.
Here's an example for Argentina:
Short Name: Argentina
Long Name: Argentine Republic
Numeric Code: 032 (note the leading zero)
Three character alpha: ARG
Two character alpha: AR
The ISO will sell you this list from their website, but I am sure it is reproduced on other sites for free. Here is a site that has the list as of 1999: http://www.evertype.com/standards/iso3166/iso3166-1-en.html
Find a website, grab the data and throw it into a table.
Thanks,
Bill
> selct. What would be easiest way to do that and if someone could >send mea list or give a hint where to find one
|
|
|
|