try:
<cfloop index="CountriesList" list="#Countries#"
delimiters=",">
<CFQUERY NAME="add_country" DATASOURCE="countries">
INSERT INTO Countries
(Countries) <!--- your country fieldname --->
VALUES
('#Trim(CountriesList)#')
</CFQUERY>
</cfloop>
================ You wrote ================
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,BAHA
AS,BAHRAIN
>>,BANGLADESH,BARBADOS,BELARUS,BELGIUM,BELIZE,BENIN,BERMUDA,BHUTAN,
OLIVIA,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,G
EENLAND,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,KEN
A,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,FEDERATE
STATES OF
>>MICRONESIA,REPUBLIC OF
>>MOLDOVA,MONACO,MONGOLIA,MONTSERRAT,MOROCCO,MOZAMBIQUE,MYANMAR,NAM
BIA,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
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
