It correctly outputs unique countries per line but only inserts
"AFGHANISTAN" repeatedly into the database table. Why?
<cfset Countries="AFGHANISTAN,ALBANIA,ALGERIA,AMERICAN
SAMOA,ANDORRA,ANGOLA,ANGUILLA,ANTARCTICA,ANTIGUA AND
BARBUDA,ARGENTINA,ARMENIA,ARUBA,AUSTRALIA,AUSTRIA,AZERBAIJAN,BAHAMAS,BAHRAIN
,BANGLADESH,BARBADOS,BELARUS,BELGIUM,BELIZE,BENIN,BERMUDA,BHUTAN,BOLIVIA,BOS
NIA AND HERZEGOVINA,BOTSWANA,BOUVET ISLAND,BRAZIL,BRITISH INDIAN OCEAN
TERRITORY,BRUNEI DARUSSALAM,BULGARIA,BURKINA
FASO,BURUNDI,CAMBODIA,CAMEROON,CANADA,CAPE VERDE,CAYMAN ISLANDS,CENTRAL
AFRICAN REPUBLIC,CHAD,CHILE,CHINA,CHRISTMAS ISLAND,COCOS (KEELING)
ISLANDS,COLOMBIA,COMOROS,CONGO,THE DEMOCRATIC REPUBLIC OF THE CONGO,COOK
ISLANDS,COSTA RICA,CÔTE D'IVOIRE,CROATIA,CUBA,CYPRUS,CZECH
REPUBLIC,DENMARK,DJIBOUTI,DOMINICA,DOMINICAN REPUBLIC,EAST
TIMOR,ECUADOR,EGYPT,EL SALVADOR,EQUATORIAL
GUINEA,ERITREA,ESTONIA,ETHIOPIA,FALKLAND ISLANDS (MALVINAS),FAROE
ISLANDS,FIJI,FINLAND,FRANCE,FRENCH GUIANA,FRENCH POLYNESIA,FRENCH SOUTHERN
TERRITORIES,GABON,GAMBIA,GEORGIA,GERMANY,GHANA,GIBRALTAR,GREECE,GREENLAND,GR
ENADA,GUADELOUPE,GUAM,GUATEMALA,GUINEA,GUINEA-BISSAU,GUYANA,HAITI,HEARD
ISLAND AND MCDONALD ISLANDS,HOLY SEE (VATICAN CITY STATE),HONDURAS,HONG
KONG,HUNGARY,ICELAND,INDIA,INDONESIA,ISLAMIC REPUBLIC OF
IRAN,IRAQ,IRELAND,ISRAEL,ITALY,JAMAICA,JAPAN,JORDAN,KAZAKSTAN,KENYA,KIRIBATI
,DEMOCRATIC PEOPLE'S REPUBLIC OF KOREA,REPUBLIC OF
KOREA,KUWAIT,KYRGYZSTAN,LAO PEOPLE'S DEMOCRATIC
REPUBLIC,LATVIA,LEBANON,LESOTHO,LIBERIA,LIBYAN ARAB
JAMAHIRIYA,LIECHTENSTEIN,LITHUANIA,LUXEMBOURG,MACAU,THE FORMER YUGOSLAV
REPUBLIC OF
MACEDONIA,MADAGASCAR,MALAWI,MALAYSIA,MALDIVES,MALI,MALTA,MARSHALL
ISLANDS,MARTINIQUE,MAURITANIA,MAURITIUS,MAYOTTE,MEXICO,FEDERATED STATES OF
MICRONESIA,REPUBLIC OF
MOLDOVA,MONACO,MONGOLIA,MONTSERRAT,MOROCCO,MOZAMBIQUE,MYANMAR,NAMIBIA,NAURU,
NEPAL,NETHERLANDS,NETHERLANDS ANTILLES,NEW CALEDONIA,NEW
ZEALAND,NICARAGUA,NIGER,NIGERIA,NIUE,NORFOLK ISLAND,NORTHERN MARIANA
ISLANDS,NORWAY,OMAN,PAKISTAN,PALAU,OCCUPIED PALESTINIAN
TERRITORY,PANAMA,PAPUA NEW
GUINEA,PARAGUAY,PERU,PHILIPPINES,PITCAIRN,POLAND,PORTUGAL,PUERTO
RICO,QATAR,RÉUNION,ROMANIA,RUSSIAN FEDERATION,RWANDA,SAINT HELENA,SAINT
KITTS AND NEIS,SAINT LUCIA,SAINT PIERRE AND MIQUELON,SAINT VINCENT AND THE
GRENADINES,SAMOA,SAN MARINO,SAO TOME AND PRINCIPE,SAUDI
ARABIA,SENEGAL,SEYCHELLES,SIERRA LEONE,SINGAPORE,SLOVAKIA,SLOVENIA,SOLOMON
ISLANDS,SOMALIA,SOUTH AFRICA,SOUTH GEORGIA AND THE SOUTH SANDWICH
ISLANDS,SPAIN,SRI LANKA,SUDAN,SURINAME,SVALBARD AND JAN MAYEN,SWAZILAND,
SWEDEN,SWITZERLAND,SYRIAN ARAB REPUBLIC,TAIWAN PROVINCE OF
CHINA,TAJIKISTAN,UNITED REPUBLIC OF
TANZANIA,THAILAND,TOGO,TOKELAU,TONGA,TRINIDAD AND
TOBAGO,TUNISIA,TURKEY,TURKMENISTAN,TURKS AND CAICOS
ISLANDS,TUVALU,UGANDA,UKRAINE,UNITED ARAB EMIRATES,UNITED KINGDOM,UNITED
STATES,UNITED STATES MINOR OUTLYING
ISLANDS,URUGUAY,UZBEKISTAN,VANUATU,VENEZUELA,VIET NAM,BRITISH VIRGIN
ISLANDS,U.S. VIRGIN ISLANDS,WALLIS AND FUTUNA,WESTERN
SAHARA,YEMEN,YUGOSLAVIA,ZAMBIA,ZIMBABWE">
<cfoutput>
<cfloop index="CountriesList" list="#Countries#" delimiters=",">
<cfset Form.CountryName=#CountriesList#>
<p>#Form.CountryName#</p>
<cfinsert datasource="Countries" tablename="Form_Countries"
formfields="CountryName">
</cfloop>
</cfoutput>
==
Peter Tilbrook
Internet Applications Developer
Australian Building Codes Board
GPO Box 9839
CANBERRA ACT 2601
AUSTRALIA
WWW: http://www.abcb.gov.au/
E-Mail: [EMAIL PROTECTED]
Telephone: +61 (02) 6213 6731
Mobile: 0439 401 823
Facsimile: +61 (02) 6213 7287
**********************************************************************
The information contained in this e-mail, and any attachments to it, is
intended for the use of addressee and is confidential. If you are not
the intended recipient, you must not use, disclose, read, forward, copy or
retain any of the information. If you have received this e-mail in
error, please delete it and notify the sender by return e-mail or telephone.
The Commonwealth does not warrant that any attachments are free from
viruses or any other defects. You assume all liability for any loss, damage, or
other consequences which may arise from opening or using the attachments.
**********************************************************************
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
