Try <cfloop index="form.countryname" list="#countries#">
> 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,AZERBAIJ > AN,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,G > REECE,GREENLAND,GR > ENADA,GUADELOUPE,GUAM,GUATEMALA,GUINEA,GUINEA-BISSAU,GUYAN > A,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,KAZAKS > TAN,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,M > ARSHALL > ISLANDS,MARTINIQUE,MAURITANIA,MAURITIUS,MAYOTTE,MEXICO,FED > ERATED STATES OF > MICRONESIA,REPUBLIC OF > MOLDOVA,MONACO,MONGOLIA,MONTSERRAT,MOROCCO,MOZAMBIQUE,MYAN > MAR,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/uns > ubscribe.cfm?user=633.558.4 s. isaac dealey 954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to tapestry api is opensource http://www.turnkey.to/tapi certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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
