4 Replies Latest reply on Jul 22, 2011 2:09 AM by Rich_z7

    AS2: Combo Box only displaying first item of a list....

    Rich_z7

      Hi,

       

      This actually works correctly in the debugger,  but not when it is run online,  so I'm confused.......

       

      I have a screen which is essentially an address screen.  Amongst other fields. there are two fields on the screen which are used to enter the region of the user.  One is a combo box,  the other is a plain text field.

       

      After the user selects their country from a drop down list,  if that country has a list of regions associated with it,  a Combobox is populated and displayed,  with the text field being hidden.  If there are no regions associated with the country then the combobox is hidden and the text field is displayed:

       

      function setCountyField(countryEntry:Object, countyText:MovieClip, countyCombo:ComboBox)
               {
                  //
                  // If the country entry has a list of regions then populate the region drop down box and
                  // show it,  otherwise show the text field version.
                  //
                  var regions:Array = new Array();
                  if (lastCountry != countryEntry.code)
                     {
                       lastCountry = countryEntry.code;
                       if (countryEntry.regions.length > 0)
                          {
                            regions                   = countryEntry.regions;
                            countyCombo.removeAll();
                            countyCombo.dataProvider  = regions;
                            countyText.visible        = false;
                            countyCombo.visible       = true;
                          }
                       else
                          {
                            countyText.textIn.text    = "";
                            countyCombo.visible       = false;
                            countyText.visible        = true;
                          }
                     }
               }

       

      In the debugger,  this works perfectly.  However,  online using Firefox,  explorer and a few other browsers only the first item of the regions array is displayed.

       

      Thanks!

       

      Regards

       

      Rich

        • 1. Re: AS2: Combo Box only displaying first item of a list....
          Ned Murphy Adobe Community Professional & MVP

          Where is the data coming from?

          • 2. Re: AS2: Combo Box only displaying first item of a list....
            Rich_z7 Level 1

            Hi Ned,

             

            It's coming from an MS SQL database via an ASPX page that spits out XML.

             

            This is then parsed into an array:

             

            function parseCountryList(countryList:XML, loaded:Boolean, countries:List, statusText:TextField)
                     {
                       var totalCountries:Number = 0;
                       var countryCount:Number   = 0;
                       var regionCount:Number    = 0;
                       var regions:Array         = new Array();
                       var countryDp:Array       = new Array();
                       var countryData:Object    = new Object();
                       //
                       if (loaded)
                          {
                             totalCountries = countryList.firstChild.attributes.count;
                             for (countryCount = 0; countryCount < totalCountries; countryCount++)
                                 {
                                    countryData         = new Object();
                                    countryData.name    = countryList.firstChild.childNodes[countryCount].attributes.name;
                                    countryData.code    = countryList.firstChild.childNodes[countryCount].attributes.code;
                                    countryData.regions = new Array();
                                    regions = new Array();
                                    for (regionCount = 0; regionCount < countryList.firstChild.childNodes[countryCount].childNodes.length; regionCount++)
                                        {
                                          regions.push(countryList.firstChild.childNodes[countryCount].childNodes[regionCount].attr ibutes.name);
                                        }
                                    countryData.regions = regions;
                                    countryDp.push(countryData);
                                 }
                             countries.dataProvider = countryDp;
                          }
                       else
                          {
                             setStatus(statusText, c_error_Prefix + "Cannot load country list");
                          }
                     }

             

            Regards,

             

            Rich

            • 3. Re: AS2: Combo Box only displaying first item of a list....
              kglad Adobe Community Professional & MVP

              he means where are you loading it from?  is there a cross-domain security issue?

               

              ie, show your xml.load() statement.

              • 4. Re: AS2: Combo Box only displaying first item of a list....
                Rich_z7 Level 1

                Hi kglad, Ned,

                 

                At the moment,  all of this is on localhost.

                 

                The XML load stuff is:

                 

                           addFieldCatalog(c_requestorCountry, requestorCountry);
                           requestorCountry.addEventListener("focusIn", countryListListener);
                           requestorCountry.addEventListener("change", countryListListener);
                           requestorCountry.labelFunction = function(item:Object):String { return(item.name); };
                           countryListXML = new XML();
                           countryListXML.ignoreWhite = true;
                           countryListXML.load("./modules/request/xml/countryList.aspx");
                           countryListXML.onLoad = function(loaded) { parseCountryList(countryListXML, loaded, requestorCountry, statusText) };

                 

                I don't know whether this has any bearing on the problem,  but it works just fine when running in debug mode.  (I take the output from countryList.aspx and puit it in  an XML file.

                 

                The XML file is:

                 

                <?xml version="1.0" encoding="utf-8"?>
                <dbresult count="248">
                <country name="AFGHANISTAN" code="AF"></country>
                <country name="ÅLAND ISLANDS" code="AX"></country>
                <country name="ALBANIA" code="AL"></country>
                <country name="ALGERIA" code="DZ"></country>
                <country name="AMERICAN SAMOA" code="AS"></country>
                <country name="ANDORRA" code="AD"></country>
                <country name="ANGOLA" code="AO"></country>
                <country name="ANGUILLA" code="AI"></country>
                <country name="ANTARCTICA" code="AQ"></country>
                <country name="ANTIGUA AND BARBUDA" code="AG"></country>
                <country name="ARGENTINA" code="AR"></country>
                <country name="ARMENIA" code="AM"></country>
                <country name="ARUBA" code="AW"></country>
                <country name="AUSTRALIA" code="AU">
                <region name="Australian Cap. Territory"/>
                <region name="New South Wales"/>
                <region name="Northern Territory"/>
                <region name="Queensland"/>
                <region name="South Australia"/>
                <region name="Tasmania"/>
                <region name="Victoria"/>
                <region name="Western Australia"/>
                </country>
                <country name="AUSTRIA" code="AT"></country>
                <country name="AZERBAIJAN" code="AZ"></country>
                <country name="BAHAMAS" code="BS"></country>
                <country name="BAHRAIN" code="BH"></country>
                <country name="BANGLADESH" code="BD"></country>
                <country name="BARBADOS" code="BB"></country>
                <country name="BELARUS" code="BY"></country>
                <country name="BELGIUM" code="BE"></country>
                <country name="BELIZE" code="BZ"></country>
                <country name="BENIN" code="BJ"></country>
                <country name="BERMUDA" code="BM"></country>
                <country name="BHUTAN" code="BT"></country>
                <country name="BOLIVIA, PLURINATIONAL STATE OF" code="BO"></country>
                <country name="BONAIRE, SINT EUSTATIUS AND SABA" code="BQ"></country>
                <country name="BOSNIA AND HERZEGOVINA" code="BA"></country>
                <country name="BOTSWANA" code="BW"></country>
                <country name="BOUVET ISLAND" code="BV"></country>
                <country name="BRAZIL" code="BR"></country>
                <country name="BRITISH INDIAN OCEAN TERRITORY" code="IO"></country>
                <country name="BRUNEI DARUSSALAM" code="BN"></country>
                <country name="BULGARIA" code="BG"></country>
                <country name="BURKINA FASO" code="BF"></country>
                <country name="BURUNDI" code="BI"></country>
                <country name="CAMBODIA" code="KH"></country>
                <country name="CAMEROON" code="CM"></country>
                <country name="CANADA" code="CA">
                <region name="Alberta"/>
                <region name="British Columbia"/>
                <region name="Manitoba"/>
                <region name="New Brunswick"/>
                <region name="Newfoundland-Labrador"/>
                <region name="Northwest Territories"/>
                <region name="Nova Scotia"/>
                <region name="Nunavut"/>
                <region name="Ontario"/>
                <region name="Prince Edward Island"/>
                <region name="Québec (Quebec)"/>
                <region name="Saskatchewan"/>
                <region name="Yukon"/>
                </country>
                <country name="CAPE VERDE" code="CV"></country>
                <country name="CAYMAN ISLANDS" code="KY"></country>
                <country name="CENTRAL AFRICAN REPUBLIC" code="CF"></country>
                <country name="CHAD" code="TD"></country>
                <country name="CHILE" code="CL"></country>
                <country name="CHINA" code="CN">
                <region name="Anhui"/>
                <region name="Beijing"/>
                <region name="Chongqing"/>
                <region name="Fujian"/>
                <region name="Gansu"/>
                <region name="Guangdong"/>
                <region name="Guangxi"/>
                <region name="Guizhou"/>
                <region name="Hainan"/>
                <region name="Hebei"/>
                <region name="Heilongjiang"/>
                <region name="Henan"/>
                <region name="Hong Kong"/>
                <region name="Hubei"/>
                <region name="Hunan"/>
                <region name="Jiangsu"/>
                <region name="Jiangxi"/>
                <region name="Jilin"/>
                <region name="Liaoning"/>
                <region name="Macau"/>
                <region name="NeiMongol"/>
                <region name="Ningxia"/>
                <region name="Qinghai"/>
                <region name="Shaanxi"/>
                <region name="Shandong"/>
                <region name="Shanghai"/>
                <region name="Shanxi"/>
                <region name="Sichuan"/>
                <region name="Tianjin"/>
                <region name="Tibet"/>
                <region name="Xinjiang"/>
                <region name="Yunnan"/>
                <region name="Zhejiang"/>
                </country>
                <country name="CHRISTMAS ISLAND" code="CX"></country>
                <country name="COCOS (KEELING) ISLANDS" code="CC"></country>
                <country name="COLOMBIA" code="CO"></country>
                <country name="COMOROS" code="KM"></country>
                <country name="CONGO" code="CG"></country>
                <country name="CONGO, THE DEMOCRATIC REPUBLIC OF THE" code="CD"></country>
                <country name="COOK ISLANDS" code="CK"></country>
                <country name="COSTA RICA" code="CR"></country>
                <country name="CÔTE D''IVOIRE" code="CI"></country>
                <country name="CROATIA" code="HR"></country>
                <country name="CUBA" code="CU"></country>
                <country name="CURAÇAO" code="CW"></country>
                <country name="CYPRUS" code="CY"></country>
                <country name="CZECH REPUBLIC" code="CZ"></country>
                <country name="DENMARK" code="DK"></country>
                <country name="DJIBOUTI" code="DJ"></country>
                <country name="DOMINICA" code="DM"></country>
                <country name="DOMINICAN REPUBLIC" code="DO"></country>
                <country name="ECUADOR" code="EC"></country>
                <country name="EGYPT" code="EG"></country>
                <country name="EL SALVADOR" code="SV"></country>
                <country name="EQUATORIAL GUINEA" code="GQ"></country>
                <country name="ERITREA" code="ER"></country>
                <country name="ESTONIA" code="EE"></country>
                <country name="ETHIOPIA" code="ET"></country>
                <country name="FALKLAND ISLANDS (MALVINAS)" code="FK"></country>
                <country name="FAROE ISLANDS" code="FO"></country>
                <country name="FIJI" code="FJ"></country>
                <country name="FINLAND" code="FI"></country>
                <country name="FRANCE" code="FR"></country>
                <country name="FRENCH GUIANA" code="GF"></country>
                <country name="FRENCH POLYNESIA" code="PF"></country>
                <country name="FRENCH SOUTHERN TERRITORIES" code="TF"></country>
                <country name="GABON" code="GA"></country>
                <country name="GAMBIA" code="GM"></country>
                <country name="GEORGIA" code="GE"></country>
                <country name="GERMANY" code="DE"></country>
                <country name="GHANA" code="GH"></country>
                <country name="GIBRALTAR" code="GI"></country>
                <country name="GREECE" code="GR"></country>
                <country name="GREENLAND" code="GL"></country>
                <country name="GRENADA" code="GD"></country>
                <country name="GUADELOUPE" code="GP"></country>
                <country name="GUAM" code="GU"></country>
                <country name="GUATEMALA" code="GT"></country>
                <country name="GUERNSEY" code="GG"></country>
                <country name="GUINEA" code="GN"></country>
                <country name="GUINEA-BISSAU" code="GW"></country>
                <country name="GUYANA" code="GY"></country>
                <country name="HAITI" code="HT"></country>
                <country name="HEARD ISLAND AND MCDONALD ISLANDS" code="HM"></country>
                <country name="HOLY SEE (VATICAN CITY STATE)" code="VA"></country>
                <country name="HONDURAS" code="HN"></country>
                <country name="HONG KONG" code="HK"></country>
                <country name="HUNGARY" code="HU"></country>
                <country name="ICELAND" code="IS"></country>
                <country name="INDIA" code="IN"></country>
                <country name="INDONESIA" code="ID"></country>
                <country name="IRAN, ISLAMIC REPUBLIC OF" code="IR"></country>
                <country name="IRAQ" code="IQ"></country>
                <country name="IRELAND" code="IE"></country>
                <country name="ISLE OF MAN" code="IM"></country>
                <country name="ISRAEL" code="IL"></country>
                <country name="ITALY" code="IT"></country>
                <country name="JAMAICA" code="JM"></country>
                <country name="JAPAN" code="JP"></country>
                <country name="JERSEY" code="JE"></country>
                <country name="JORDAN" code="JO"></country>
                <country name="KAZAKHSTAN" code="KZ"></country>
                <country name="KENYA" code="KE"></country>
                <country name="KIRIBATI" code="KI"></country>
                <country name="KOREA, DEMOCRATIC PEOPLE''S REPUBLIC OF" code="KP"></country>
                <country name="KOREA, REPUBLIC OF" code="KR"></country>
                <country name="KUWAIT" code="KW"></country>
                <country name="KYRGYZSTAN" code="KG"></country>
                <country name="LAO PEOPLE''S DEMOCRATIC REPUBLIC" code="LA"></country>
                <country name="LATVIA" code="LV"></country>
                <country name="LEBANON" code="LB"></country>
                <country name="LESOTHO" code="LS"></country>
                <country name="LIBERIA" code="LR"></country>
                <country name="LIBYAN ARAB JAMAHIRIYA" code="LY"></country>
                <country name="LIECHTENSTEIN" code="LI"></country>
                <country name="LITHUANIA" code="LT"></country>
                <country name="LUXEMBOURG" code="LU"></country>
                <country name="MACAO" code="MO"></country>
                <country name="MACEDONIA, THE FORMER YUGOSLAV REPUBLIC OF" code="MK"></country>
                <country name="MADAGASCAR" code="MG"></country>
                <country name="MALAWI" code="MW"></country>
                <country name="MALAYSIA" code="MY"></country>
                <country name="MALDIVES" code="MV"></country>
                <country name="MALI" code="ML"></country>
                <country name="MALTA" code="MT"></country>
                <country name="MARSHALL ISLANDS" code="MH"></country>
                <country name="MARTINIQUE" code="MQ"></country>
                <country name="MAURITANIA" code="MR"></country>
                <country name="MAURITIUS" code="MU"></country>
                <country name="MAYOTTE" code="YT"></country>
                <country name="MEXICO" code="MX"></country>
                <country name="MICRONESIA, FEDERATED STATES OF" code="FM"></country>
                <country name="MOLDOVA, REPUBLIC OF" code="MD"></country>
                <country name="MONACO" code="MC"></country>
                <country name="MONGOLIA" code="MN"></country>
                <country name="MONTENEGRO" code="ME"></country>
                <country name="MONTSERRAT" code="MS"></country>
                <country name="MOROCCO" code="MA"></country>
                <country name="MOZAMBIQUE" code="MZ"></country>
                <country name="MYANMAR" code="MM"></country>
                <country name="NAMIBIA" code="NA"></country>
                <country name="NAURU" code="NR"></country>
                <country name="NEPAL" code="NP"></country>
                <country name="NETHERLANDS" code="NL"></country>
                <country name="NEW CALEDONIA" code="NC"></country>
                <country name="NEW ZEALAND" code="NZ"></country>
                <country name="NICARAGUA" code="NI"></country>
                <country name="NIGER" code="NE"></country>
                <country name="NIGERIA" code="NG"></country>
                <country name="NIUE" code="NU"></country>
                <country name="NORFOLK ISLAND" code="NF"></country>
                <country name="NORTHERN MARIANA ISLANDS" code="MP"></country>
                <country name="NORWAY" code="NO"></country>
                <country name="OMAN" code="OM"></country>
                <country name="PAKISTAN" code="PK"></country>
                <country name="PALAU" code="PW"></country>
                <country name="PALESTINIAN TERRITORY, OCCUPIED" code="PS"></country>
                <country name="PANAMA" code="PA"></country>
                <country name="PAPUA NEW GUINEA" code="PG"></country>
                <country name="PARAGUAY" code="PY"></country>
                <country name="PERU" code="PE"></country>
                <country name="PHILIPPINES" code="PH"></country>
                <country name="PITCAIRN" code="PN"></country>
                <country name="POLAND" code="PL"></country>
                <country name="PORTUGAL" code="PT"></country>
                <country name="PUERTO RICO" code="PR"></country>
                <country name="QATAR" code="QA"></country>
                <country name="RÉUNION" code="RE"></country>
                <country name="ROMANIA" code="RO"></country>
                <country name="RUSSIAN FEDERATION" code="RU"></country>
                <country name="RWANDA" code="RW"></country>
                <country name="SAINT BARTHÉLEMY" code="BL"></country>
                <country name="SAINT HELENA, ASCENSION AND TRISTAN DA CUNHA" code="SH"></country>
                <country name="SAINT KITTS AND NEVIS" code="KN"></country>
                <country name="SAINT LUCIA" code="LC"></country>
                <country name="SAINT MARTIN (FRENCH PART)" code="MF"></country>
                <country name="SAINT PIERRE AND MIQUELON" code="PM"></country>
                <country name="SAINT VINCENT AND THE GRENADINES" code="VC"></country>
                <country name="SAMOA" code="WS"></country>
                <country name="SAN MARINO" code="SM"></country>
                <country name="SAO TOME AND PRINCIPE" code="ST"></country>
                <country name="SAUDI ARABIA" code="SA"></country>
                <country name="SENEGAL" code="SN"></country>
                <country name="SERBIA" code="RS"></country>
                <country name="SEYCHELLES" code="SC"></country>
                <country name="SIERRA LEONE" code="SL"></country>
                <country name="SINGAPORE" code="SG"></country>
                <country name="SINT MAARTEN (DUTCH PART)" code="SX"></country>
                <country name="SLOVAKIA" code="SK"></country>
                <country name="SLOVENIA" code="SI"></country>
                <country name="SOLOMON ISLANDS" code="SB"></country>
                <country name="SOMALIA" code="SO"></country>
                <country name="SOUTH AFRICA" code="ZA"></country>
                <country name="SOUTH GEORGIA AND THE SOUTH SANDWICH ISLANDS" code="GS"></country>
                <country name="SPAIN" code="ES"></country>
                <country name="SRI LANKA" code="LK"></country>
                <country name="SUDAN" code="SD"></country>
                <country name="SURINAME" code="SR"></country>
                <country name="SVALBARD AND JAN MAYEN" code="SJ"></country>
                <country name="SWAZILAND" code="SZ"></country>
                <country name="SWEDEN" code="SE"></country>
                <country name="SWITZERLAND" code="CH"></country>
                <country name="SYRIAN ARAB REPUBLIC" code="SY"></country>
                <country name="TAIWAN, PROVINCE OF CHINA" code="TW"></country>
                <country name="TAJIKISTAN" code="TJ"></country>
                <country name="TANZANIA, UNITED REPUBLIC OF" code="TZ"></country>
                <country name="THAILAND" code="TH"></country>
                <country name="TIMOR-LESTE" code="TL"></country>
                <country name="TOGO" code="TG"></country>
                <country name="TOKELAU" code="TK"></country>
                <country name="TONGA" code="TO"></country>
                <country name="TRINIDAD AND TOBAGO" code="TT"></country>
                <country name="TUNISIA" code="TN"></country>
                <country name="TURKEY" code="TR"></country>
                <country name="TURKMENISTAN" code="TM"></country>
                <country name="TURKS AND CAICOS ISLANDS" code="TC"></country>
                <country name="TUVALU" code="TV"></country>
                <country name="UGANDA" code="UG"></country>
                <country name="UKRAINE" code="UA"></country>
                <country name="UNITED ARAB EMIRATES" code="AE"></country>
                <country name="UNITED KINGDOM" code="GB">
                <region name="Aberdeenshire"/>
                <region name="Angus"/>
                <region name="Antrim"/>
                <region name="Argyll"/>
                <region name="Armagh"/>
                <region name="Avon"/>
                <region name="Ayrshire"/>
                <region name="Banffshire"/>
                <region name="Bedfordshire"/>
                <region name="Berkshire"/>
                <region name="Berwickshire"/>
                <region name="Buckinghamshire"/>
                <region name="Bute"/>
                <region name="Caithness"/>
                <region name="Cambridgeshire"/>
                <region name="Cheshire"/>
                <region name="Clackmannanshire"/>
                <region name="Cleveland"/>
                <region name="Clwyd"/>
                <region name="Cornwall"/>
                <region name="Cumbria"/>
                <region name="Derbyshire"/>
                <region name="Devon"/>
                <region name="Dorset"/>
                <region name="Down"/>
                <region name="Dumfriesshire"/>
                <region name="Dunbartonshire"/>
                <region name="Durham"/>
                <region name="Dyfed"/>
                <region name="East Lothian"/>
                <region name="East Sussex"/>
                <region name="Essex"/>
                <region name="Fermanagh"/>
                <region name="Fife"/>
                <region name="Gloucestershire"/>
                <region name="Gwent"/>
                <region name="Gwynedd"/>
                <region name="Hampshire"/>
                <region name="Herefordshire"/>
                <region name="Hertfordshire"/>
                <region name="Inverness-shire"/>
                <region name="Isle of Wight"/>
                <region name="Kent"/>
                <region name="Kincardineshire"/>
                <region name="Kinross-shire"/>
                <region name="Kirkcudbrightshire"/>
                <region name="Lanarkshire"/>
                <region name="Lancashire"/>
                <region name="Leicestershire"/>
                <region name="Lincolnshire"/>
                <region name="London"/>
                <region name="Londonderry"/>
                <region name="Merseyside"/>
                <region name="Mid Glamorgan"/>
                <region name="Middlesex"/>
                <region name="Midlothian"/>
                <region name="Moray"/>
                <region name="Nairnshire"/>
                <region name="Norfolk"/>
                <region name="North Humberside"/>
                <region name="North Yorkshire"/>
                <region name="Northamptonshire"/>
                <region name="Northumberland"/>
                <region name="Nottinghamshire"/>
                <region name="Orkney"/>
                <region name="Oxfordshire"/>
                <region name="Peeblesshire"/>
                <region name="Perthshire"/>
                <region name="Powys"/>
                <region name="Renfrewshire"/>
                <region name="Ross-shire"/>
                <region name="Roxburghshire"/>
                <region name="Rutland"/>
                <region name="Selkirkshire"/>
                <region name="Shetland"/>
                <region name="Shropshire"/>
                <region name="Somerset"/>
                <region name="South Glamorgan"/>
                <region name="South Humberside"/>
                <region name="South Yorkshire"/>
                <region name="Staffordshire"/>
                <region name="Stirlingshire"/>
                <region name="Suffolk"/>
                <region name="Surrey"/>
                <region name="Sutherland"/>
                <region name="Tyne and Wear"/>
                <region name="Tyrone"/>
                <region name="Warwickshire"/>
                <region name="West Glamorgan"/>
                <region name="West Lothian"/>
                <region name="West Midlands"/>
                <region name="West Sussex"/>
                <region name="West Yorkshire"/>
                <region name="Wigtownshire"/>
                <region name="Wiltshire"/>
                <region name="Worcestershire"/>
                </country>
                <country name="UNITED STATES" code="US">
                <region name="Alabama"/>
                <region name="Alaska"/>
                <region name="Arizona"/>
                <region name="Arkansas"/>
                <region name="California"/>
                <region name="Colorado"/>
                <region name="Connecticut"/>
                <region name="Delaware"/>
                <region name="Florida"/>
                <region name="Georgia"/>
                <region name="Hawaii"/>
                <region name="Idaho"/>
                <region name="Illinois"/>
                <region name="Indiana"/>
                <region name="Iowa"/>
                <region name="Kansas"/>
                <region name="Kentucky"/>
                <region name="Louisiana"/>
                <region name="Maine"/>
                <region name="Maryland"/>
                <region name="Massachusetts"/>
                <region name="Michigan"/>
                <region name="Minnesota"/>
                <region name="Mississippi"/>
                <region name="Missouri"/>
                <region name="Montana"/>
                <region name="Nebraska"/>
                <region name="Nevada"/>
                <region name="New Hampshire"/>
                <region name="New Jersey"/>
                <region name="New Mexico"/>
                <region name="New York"/>
                <region name="North Carolina"/>
                <region name="North Dakota"/>
                <region name="Ohio"/>
                <region name="Oklahoma"/>
                <region name="Oregon"/>
                <region name="Pennsylvania"/>
                <region name="Rhode Island"/>
                <region name="South Carolina"/>
                <region name="South Dakota"/>
                <region name="Tennessee"/>
                <region name="Texas"/>
                <region name="Utah"/>
                <region name="Vermont"/>
                <region name="Virginia"/>
                <region name="Washington"/>
                <region name="West Virginia"/>
                <region name="Wisconsin"/>
                <region name="Wyoming"/>
                </country>
                <country name="UNITED STATES MINOR OUTLYING ISLANDS" code="UM"></country>
                <country name="URUGUAY" code="UY"></country>
                <country name="UZBEKISTAN" code="UZ"></country>
                <country name="VANUATU" code="VU"></country>
                <country name="VENEZUELA, BOLIVARIAN REPUBLIC OF" code="VE"></country>
                <country name="VIET NAM" code="VN"></country>
                <country name="VIRGIN ISLANDS, BRITISH" code="VG"></country>
                <country name="VIRGIN ISLANDS, U.S." code="VI"></country>
                <country name="WALLIS AND FUTUNA" code="WF"></country>
                <country name="WESTERN SAHARA" code="EH"></country>
                <country name="YEMEN" code="YE"></country>
                <country name="ZAMBIA" code="ZM"></country>
                <country name="ZIMBABWE" code="ZW"></country>
                </dbresult>

                 

                 

                 

                Regards,

                 

                Rich