My cool script in my asp is having problems

Need some help with a script I have been using.  The below script works fine as long as I keep the citylist line commented out but I want to use the city and can not get it to work.  I think i need a fresh set of eyes.

<%
regionList = GetList("region")
countryList = GetList("country")
'cityList = GetList("city")
buildingList = GetList("building")

function GetList(ByVal LocationType)
     if (locationtype = "region") then
          sFieldName = "facility_geography"
     elseif  (locationtype = "country") then
          sFieldName = "facility_country"
     elseif  (locationtype = "city") then
          sFieldName = "facility_city"
     elseif  (locationtype = "building") then
          sFieldName = "facility_num"
     end if
       
' open the connection
' assign recordset object
set conn = Server.CreateObject("ADODB.Connection")
set Rst = Server.CreateObject("ADODB.Recordset")
conn.Open Application("POCConnectString")
conn.CommandTimeout = 0

set conn1 = Server.CreateObject("ADODB.Connection")
set Rsx = Server.CreateObject("ADODB.Recordset")
conn1.Open Application("DBConnectString")
conn1.CommandTimeout = 0


mySQL = "select DISTINCT " & sFieldName & " as OptionValue from facility WHERE " & sFieldName & "<>'' ORDER BY " & sFieldName
''Response.Write LocationType & "-" & mySQL & "<br>"
Rsx.open mySQL, conn1    

     List = ""
     while Not Rsx.EOF
           tOptionValue = replace(Rsx("OptionValue"), ",", " ")
           tOptionValue = replace(tOptionValue, chr(40), "- ")
           tOptionValue = replace(tOptionValue, chr(41), "")
           if List = "" then
          List = "'" & tOptionValue & "'"
           else
          List = List & ",'" & tOptionValue & "'"
        end if
          Rsx.MoveNext
     wend

     Conn1.Close

     GetList = List
     'response.write "<br>" & GetList & "<br>"
end function
%>

It is called by

<select name="locationtype" onchange="LocationType_OnChange(this)" size="1" tabindex="1" style="font-family: Arial; font-size: 11px; color: #000080">
<option value="global">global</option>
<option value="region">region</option>
<option value="country">country</option>
<option value="city">city</option>
<option value="building">building</option>
</select>
pinkstonmAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

ThinkPaperIT ConsultantCommented:
can you display your whole code? where is the javascript function?
any reason you didn't include "global" value in your code?
Are you trying to run ASP with onchange??
0
pinkstonmAuthor Commented:
<HTML>
<HEAD>
<meta HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=windows-1252">
<meta http-equiv="Content-Language" content="en-us">
<link rel="stylesheet" type="text/css" href="/s2dpoc/styles/main.css">
<link rel="stylesheet" type="text/css" href="/s2dpoc/styles/main_arial.css">

<style>
p                  { font-family: Arial, sans-serif; font-size: 12px }
td, th            { vertical-align: top }
td                         { font-size: 10pt }
td.facility            { vertical-align: top; padding: 3px; border: solid 1px #808080 }
p.fac                  { font-size: 10px; text-align: left; margin: 0px; line-height: 10px background: #e6e6e6}
p.city                  { font-size: 10px; text-align: left; margin: 0px; line-height: 10px }
p.region            { font-size: 10px; text-align: right; margin: 0px; line-height: 10px }
td.blue            { background-color: #B0CDDD; font-family: Arial, sans-serif; font-weight: bold; font-size: 14px; text-align: center }
td.dkgrey      { background-color: #cccccc; font-family: Arial, sans-serif; font-weight: bold; font-size: 12px }
td.ltgrey      { background-color: #e6e6e6; font-family: Arial, sans-serif; font-size: 12px }
th.two5            { background-color: #e6e6e6; font-weight: normal; font-family: Arial, sans-serif; font-size: 12px; text-align: left; width: 25% }
th.three3      { background-color: #e6e6e6; font-weight: normal; font-family: Arial, sans-serif; font-size: 12px; text-align: left; width: 33% }
th.five0      { background-color: #e6e6e6; font-weight: normal; font-family: Arial, sans-serif; font-size: 12px; text-align: left; width: 50% }
th.six7            { background-color: #e6e6e6; font-weight: normal; font-family: Arial, sans-serif; font-size: 12px; text-align: left; width: 67% }
th.eight0      { background-color: #e6e6e6; font-weight: normal; font-family: Arial, sans-serif; font-size: 12px; text-align: left; width: 80% }
</style>


<%
regionList = GetList("region")
countryList = GetList("country")
'cityList = GetList("city")
buildingList = GetList("building")

function GetList(ByVal LocationType)
     if (locationtype = "region") then
          sFieldName = "facility_geography"
     elseif  (locationtype = "country") then
          sFieldName = "facility_country"
     elseif  (locationtype = "city") then
          sFieldName = "facility_city"
     elseif  (locationtype = "building") then
          sFieldName = "facility_num"
     end if
       
' open the connection
' assign recordset object
set conn = Server.CreateObject("ADODB.Connection")
set Rst = Server.CreateObject("ADODB.Recordset")
conn.Open Application("POCConnectString")
conn.CommandTimeout = 0

set conn1 = Server.CreateObject("ADODB.Connection")
set Rsx = Server.CreateObject("ADODB.Recordset")
conn1.Open Application("DBConnectString")
conn1.CommandTimeout = 0


mySQL = "select DISTINCT " & sFieldName & " as OptionValue from facility WHERE " & sFieldName & "<>'' ORDER BY " & sFieldName
''Response.Write LocationType & "-" & mySQL & "<br>"
Rsx.open mySQL, conn1    

     List = ""
     while Not Rsx.EOF
           tOptionValue = replace(Rsx("OptionValue"), ",", " ")
           tOptionValue = replace(tOptionValue, chr(40), "- ")
           tOptionValue = replace(tOptionValue, chr(41), "")
           if List = "" then
          List = "'" & tOptionValue & "'"
           else
          List = List & ",'" & tOptionValue & "'"
        end if
          Rsx.MoveNext
     wend

     Conn1.Close

     GetList = List
     'response.write "<br>" & GetList & "<br>"
end function
%>

<script Language="JavaScript">
var globalList = new Array();
var regionList = new Array(<%=regionList%>);
var countryList = new Array(<%=countryList%>);
var cityList = new Array(<%=cityList%>);
var buildingList = new Array(<%=buildingList%>);

function LocationType_OnChange(locationTypeSelect)
{
     var locationType = locationTypeSelect.options[locationTypeSelect.selectedIndex].value;
     //alert("Location type is " + locationType);
     
     makeLocationSelect(locationTypeSelect.form.elements["location"], eval(locationType + "List"));
}

function makeLocationSelect(oSelect, selectList)
{
     ClearSelect(oSelect);

     for (i = 0 ; i < selectList.length ; i++)
     {
          AddOptionToSelect(oSelect, selectList[i], selectList[i])
     }
}

function ClearSelect(oSelect)
{
     oSelect.options.length = 0;
}

function AddOptionToSelect(oSelect, sText, sValue)
{
     var oNewOption = new Option(sText, sValue);
     oSelect.options[oSelect.options.length] = oNewOption;
}
</script>

<script>
function calculate_cost(it, year){
  switch(year){
      case 'y1':
      it.form.res_fwdcost1C.value = (it.form.res_stdcost.value * 1.0) + (it.form.res_stdcost.value * it.form.res_fwdcost1.value / 100.0);
        it.form.res_fwdcost2C.value = (it.form.res_fwdcost1C.value * 1.0) + (it.form.res_fwdcost1C.value * it.form.res_fwdcost2.value / 100.0);
        it.form.res_fwdcost3C.value = (it.form.res_fwdcost2C.value * 1.0) + (it.form.res_fwdcost2C.value * it.form.res_fwdcost3.value / 100.0);
        it.form.res_fwdcost4C.value = (it.form.res_fwdcost3C.value * 1.0) + (it.form.res_fwdcost3C.value * it.form.res_fwdcost4.value / 100.0);
        it.form.res_fwdcost5C.value = (it.form.res_fwdcost4C.value * 1.0) + (it.form.res_fwdcost4C.value * it.form.res_fwdcost5.value / 100.0);
        it.form.res_fwdcost6C.value = (it.form.res_fwdcost5C.value * 1.0) + (it.form.res_fwdcost5C.value * it.form.res_fwdcost6.value / 100.0);
        it.form.res_fwdcost7C.value = (it.form.res_fwdcost6C.value * 1.0) + (it.form.res_fwdcost6C.value * it.form.res_fwdcost7.value / 100.0);
        it.form.res_fwdcost8C.value = (it.form.res_fwdcost7C.value * 1.0) + (it.form.res_fwdcost7C.value * it.form.res_fwdcost8.value / 100.0);
        it.form.res_fwdcost9C.value = (it.form.res_fwdcost8C.value * 1.0) + (it.form.res_fwdcost8C.value * it.form.res_fwdcost9.value / 100.0);      
        it.form.res_fwdcost10C.value = (it.form.res_fwdcost9C.value * 1.0) + (it.form.res_fwdcost9C.value * it.form.res_fwdcost10.value / 100.0);
      break;
      case 'y2':
        it.form.res_fwdcost2C.value = (it.form.res_fwdcost1C.value * 1.0) + (it.form.res_fwdcost1C.value * it.form.res_fwdcost2.value / 100.0);
        it.form.res_fwdcost3C.value = (it.form.res_fwdcost2C.value * 1.0) + (it.form.res_fwdcost2C.value * it.form.res_fwdcost3.value / 100.0);
        it.form.res_fwdcost4C.value = (it.form.res_fwdcost3C.value * 1.0) + (it.form.res_fwdcost3C.value * it.form.res_fwdcost4.value / 100.0);
        it.form.res_fwdcost5C.value = (it.form.res_fwdcost4C.value * 1.0) + (it.form.res_fwdcost4C.value * it.form.res_fwdcost5.value / 100.0);
        it.form.res_fwdcost6C.value = (it.form.res_fwdcost5C.value * 1.0) + (it.form.res_fwdcost5C.value * it.form.res_fwdcost6.value / 100.0);
        it.form.res_fwdcost7C.value = (it.form.res_fwdcost6C.value * 1.0) + (it.form.res_fwdcost6C.value * it.form.res_fwdcost7.value / 100.0);
        it.form.res_fwdcost8C.value = (it.form.res_fwdcost7C.value * 1.0) + (it.form.res_fwdcost7C.value * it.form.res_fwdcost8.value / 100.0);
        it.form.res_fwdcost9C.value = (it.form.res_fwdcost8C.value * 1.0) + (it.form.res_fwdcost8C.value * it.form.res_fwdcost9.value / 100.0);      
        it.form.res_fwdcost10C.value = (it.form.res_fwdcost9C.value * 1.0) + (it.form.res_fwdcost9C.value * it.form.res_fwdcost10.value / 100.0);
        break;
      case 'y3':
        it.form.res_fwdcost3C.value = (it.form.res_fwdcost2C.value * 1.0) + (it.form.res_fwdcost2C.value * it.form.res_fwdcost3.value / 100.0);
        it.form.res_fwdcost4C.value = (it.form.res_fwdcost3C.value * 1.0) + (it.form.res_fwdcost3C.value * it.form.res_fwdcost4.value / 100.0);
        it.form.res_fwdcost5C.value = (it.form.res_fwdcost4C.value * 1.0) + (it.form.res_fwdcost4C.value * it.form.res_fwdcost5.value / 100.0);
        it.form.res_fwdcost6C.value = (it.form.res_fwdcost5C.value * 1.0) + (it.form.res_fwdcost5C.value * it.form.res_fwdcost6.value / 100.0);
        it.form.res_fwdcost7C.value = (it.form.res_fwdcost6C.value * 1.0) + (it.form.res_fwdcost6C.value * it.form.res_fwdcost7.value / 100.0);
        it.form.res_fwdcost8C.value = (it.form.res_fwdcost7C.value * 1.0) + (it.form.res_fwdcost7C.value * it.form.res_fwdcost8.value / 100.0);
        it.form.res_fwdcost9C.value = (it.form.res_fwdcost8C.value * 1.0) + (it.form.res_fwdcost8C.value * it.form.res_fwdcost9.value / 100.0);      
        it.form.res_fwdcost10C.value = (it.form.res_fwdcost9C.value * 1.0) + (it.form.res_fwdcost9C.value * it.form.res_fwdcost10.value / 100.0);
        break;
      case 'y4':
        it.form.res_fwdcost4C.value = (it.form.res_fwdcost3C.value * 1.0) + (it.form.res_fwdcost3C.value * it.form.res_fwdcost4.value / 100.0);
        it.form.res_fwdcost5C.value = (it.form.res_fwdcost4C.value * 1.0) + (it.form.res_fwdcost4C.value * it.form.res_fwdcost5.value / 100.0);
        it.form.res_fwdcost6C.value = (it.form.res_fwdcost5C.value * 1.0) + (it.form.res_fwdcost5C.value * it.form.res_fwdcost6.value / 100.0);
        it.form.res_fwdcost7C.value = (it.form.res_fwdcost6C.value * 1.0) + (it.form.res_fwdcost6C.value * it.form.res_fwdcost7.value / 100.0);
        it.form.res_fwdcost8C.value = (it.form.res_fwdcost7C.value * 1.0) + (it.form.res_fwdcost7C.value * it.form.res_fwdcost8.value / 100.0);
        it.form.res_fwdcost9C.value = (it.form.res_fwdcost8C.value * 1.0) + (it.form.res_fwdcost8C.value * it.form.res_fwdcost9.value / 100.0);      
        it.form.res_fwdcost10C.value = (it.form.res_fwdcost9C.value * 1.0) + (it.form.res_fwdcost9C.value * it.form.res_fwdcost10.value / 100.0);
        break;
      case 'y5':
        it.form.res_fwdcost5C.value = (it.form.res_fwdcost4C.value * 1.0) + (it.form.res_fwdcost4C.value * it.form.res_fwdcost5.value / 100.0);
        it.form.res_fwdcost6C.value = (it.form.res_fwdcost5C.value * 1.0) + (it.form.res_fwdcost5C.value * it.form.res_fwdcost6.value / 100.0);
        it.form.res_fwdcost7C.value = (it.form.res_fwdcost6C.value * 1.0) + (it.form.res_fwdcost6C.value * it.form.res_fwdcost7.value / 100.0);
        it.form.res_fwdcost8C.value = (it.form.res_fwdcost7C.value * 1.0) + (it.form.res_fwdcost7C.value * it.form.res_fwdcost8.value / 100.0);
        it.form.res_fwdcost9C.value = (it.form.res_fwdcost8C.value * 1.0) + (it.form.res_fwdcost8C.value * it.form.res_fwdcost9.value / 100.0);      
        it.form.res_fwdcost10C.value = (it.form.res_fwdcost9C.value * 1.0) + (it.form.res_fwdcost9C.value * it.form.res_fwdcost10.value / 100.0);
        break;
      case 'y6':
        it.form.res_fwdcost6C.value = (it.form.res_fwdcost5C.value * 1.0) + (it.form.res_fwdcost5C.value * it.form.res_fwdcost6.value / 100.0);
        it.form.res_fwdcost7C.value = (it.form.res_fwdcost6C.value * 1.0) + (it.form.res_fwdcost6C.value * it.form.res_fwdcost7.value / 100.0);
        it.form.res_fwdcost8C.value = (it.form.res_fwdcost7C.value * 1.0) + (it.form.res_fwdcost7C.value * it.form.res_fwdcost8.value / 100.0);
        it.form.res_fwdcost9C.value = (it.form.res_fwdcost8C.value * 1.0) + (it.form.res_fwdcost8C.value * it.form.res_fwdcost9.value / 100.0);      
        it.form.res_fwdcost10C.value = (it.form.res_fwdcost9C.value * 1.0) + (it.form.res_fwdcost9C.value * it.form.res_fwdcost10.value / 100.0);
        break;
      case 'y7':
        it.form.res_fwdcost7C.value = (it.form.res_fwdcost6C.value * 1.0) + (it.form.res_fwdcost6C.value * it.form.res_fwdcost7.value / 100.0);
        it.form.res_fwdcost8C.value = (it.form.res_fwdcost7C.value * 1.0) + (it.form.res_fwdcost7C.value * it.form.res_fwdcost8.value / 100.0);
        it.form.res_fwdcost9C.value = (it.form.res_fwdcost8C.value * 1.0) + (it.form.res_fwdcost8C.value * it.form.res_fwdcost9.value / 100.0);      
        it.form.res_fwdcost10C.value = (it.form.res_fwdcost9C.value * 1.0) + (it.form.res_fwdcost9C.value * it.form.res_fwdcost10.value / 100.0);
        break;
      case 'y8':
        it.form.res_fwdcost8C.value = (it.form.res_fwdcost7C.value * 1.0) + (it.form.res_fwdcost7C.value * it.form.res_fwdcost8.value / 100.0);
        it.form.res_fwdcost9C.value = (it.form.res_fwdcost8C.value * 1.0) + (it.form.res_fwdcost8C.value * it.form.res_fwdcost9.value / 100.0);      
        it.form.res_fwdcost10C.value = (it.form.res_fwdcost9C.value * 1.0) + (it.form.res_fwdcost9C.value * it.form.res_fwdcost10.value / 100.0);
        break;
      case 'y9':
        it.form.res_fwdcost9C.value = (it.form.res_fwdcost8C.value * 1.0) + (it.form.res_fwdcost8C.value * it.form.res_fwdcost9.value / 100.0);
        it.form.res_fwdcost10C.value = (it.form.res_fwdcost9C.value * 1.0) + (it.form.res_fwdcost9C.value * it.form.res_fwdcost10.value / 100.0);
        break;
      case 'y10':
        it.form.res_fwdcost10C.value = (it.form.res_fwdcost9C.value * 1.0) + (it.form.res_fwdcost9C.value * it.form.res_fwdcost10.value / 100.0);
        break;
      case 'cost':
        it.form.res_fwdcost1C.value = (it.form.res_stdcost.value * 1.0) + (it.form.res_stdcost.value * it.form.res_fwdcost1.value / 100.0);
        it.form.res_fwdcost2C.value = (it.form.res_fwdcost1C.value * 1.0) + (it.form.res_fwdcost1C.value * it.form.res_fwdcost2.value / 100.0);
        it.form.res_fwdcost3C.value = (it.form.res_fwdcost2C.value * 1.0) + (it.form.res_fwdcost2C.value * it.form.res_fwdcost3.value / 100.0);
        it.form.res_fwdcost4C.value = (it.form.res_fwdcost3C.value * 1.0) + (it.form.res_fwdcost3C.value * it.form.res_fwdcost4.value / 100.0);
        it.form.res_fwdcost5C.value = (it.form.res_fwdcost4C.value * 1.0) + (it.form.res_fwdcost4C.value * it.form.res_fwdcost5.value / 100.0);
        it.form.res_fwdcost6C.value = (it.form.res_fwdcost5C.value * 1.0) + (it.form.res_fwdcost5C.value * it.form.res_fwdcost6.value / 100.0);
        it.form.res_fwdcost7C.value = (it.form.res_fwdcost6C.value * 1.0) + (it.form.res_fwdcost6C.value * it.form.res_fwdcost7.value / 100.0);
        it.form.res_fwdcost8C.value = (it.form.res_fwdcost7C.value * 1.0) + (it.form.res_fwdcost7C.value * it.form.res_fwdcost8.value / 100.0);
        it.form.res_fwdcost9C.value = (it.form.res_fwdcost8C.value * 1.0) + (it.form.res_fwdcost8C.value * it.form.res_fwdcost9.value / 100.0);      
        it.form.res_fwdcost10C.value = (it.form.res_fwdcost9C.value * 1.0) + (it.form.res_fwdcost9C.value * it.form.res_fwdcost10.value / 100.0);
        break;       
  }
}

</script>

</HEAD>
<BODY>

<div id="overDiv" style="position:absolute; visibility:hidden; z-index:1000;"></div>
<script language="JavaScript" src="/s2dpoc/java/overlib/overlib.js"></script>
<script language="JavaScript" src="/s2dpoc/java/overlib/overlib_hideform.js"></script>

<%
zid = request.servervariables("HTTP_CT_REMOTE_USER")

tresID = request.querystring("tresID")
tresnum = request.querystring("tresnum")
tresname = request.querystring("tresname")

tyear = DatePart("yyyy", Date)
tyearp1 = tyear + 1
tyearp2 = tyear + 2
tyearp3 = tyear + 3
tyearp4 = tyear + 4
tyearp5 = tyear + 5
tyearp6 = tyear + 6
tyearp7 = tyear + 7
tyearp8 = tyear + 8
tyearp9 = tyear + 9
tyearp10 = tyear + 10
%>


<FORM METHOD="POST" action="delivery_resources_details_add_write.asp?tresid=<%=(tresID)%>&tresnum=<%=(tresnum)%>&tresname=<%=(tresname)%>" onsubmit="return FrontPage_Form1_Validator(this)" name="FrontPage_Form1" language="JavaScript">

<table border="1" cellpadding="3" cellspacing="1" style="border-collapse: collapse" bordercolor="#808080" width="100%" >
  <tr>
    <td class="grey" width="100%" height="15" bgcolor="#EFEFEF">
    <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%">
      <tr>
        <td width="43%" style="vertical-align: middle">
        <span style="font-size: 11px; font-weight: 700">Delivery: Resource
            Locations Detail
        - Add</span><span style="font-size: 11px"> <font color="#9D102D">  (<%=(tresnum)%> / <%=(tresname)%>)</font></span></td>
       
        <td width="17%" style="vertical-align: top">
        <p align="right">
      <a href="javascript:history.go(-1)">
            <img border="0" src="../images/icons/icon_back.gif" width="44" height="11"></a></td>
      </tr>
    </table>
    </td>
    </tr>
    <tr>
    <td style="vertical-align: top" width="100%" height="301">
        <table border="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" cellspacing="0" cellpadding="2">
          <tr>
        <td width="165" style="vertical-align: middle" height="20">
        <font face="Arial" style="font-size: 11px">Location Type</font></td>
        <td style="vertical-align: bottom" height="20">
   
<select name="locationtype" onchange="LocationType_OnChange(this)" size="1" tabindex="1" style="font-family: Arial; font-size: 11px; color: #000080">
<option value="global">global</option>
<option value="region">region</option>
<option value="country">country</option>
<option value="city">city</option>
<option value="building">building</option>
</select></td>
          </tr>
                  <tr>
        <td width="165" style="vertical-align: top" height="20">
        <font face="Arial" style="font-size: 11px">Location Value</font></td>
        <td style="vertical-align: bottom" height="20" width="40%">
   
<select name="location" size="1" tabindex="2" style="font-family: Arial; font-size: 11px; color: #000080">
</select></td>
          </tr>
          <tr>
        <td width="165" style="vertical-align: middle" height="20">
        <font face="Arial" style="font-size: 11px">Resource Effective From Date</font></td>
        <td style="vertical-align: bottom" height="20" width="40%">
   
                        <input name="eff_from_date" size="11" tabindex=3 style="font-family: Arial; font-size: 11px; color: #000080" onmouseover="return overlib('select the effective start date of the resource', RIGHT, BELOW, BGCOLOR, '9d102d', FGCOLOR, 'EFEFEF', CAPCOLOR, 'ffffff', CAPTION,  'Field Help - Required');" onmouseout="return nd();"> <a href="javascript:void(0)" onclick="if(self.gfPop)gfPop.fPopCalendar(document.FrontPage_Form1.eff_from_date);return false;" HIDEFOCUS>
                        <img class="PopcalTrigger" align="top" src="/s2dPOC/images/cal.gif" border="0" alt="" width="16" height="16"></a>
      </td>
          </tr>
                  <tr>
        <td width="165" style="vertical-align: middle" height="20">
        <font face="Arial" style="font-size: 11px">Resource Effective To Date</font></td>
        <td style="vertical-align: bottom" height="20" width="40%">
   
                        <input name="eff_to_date" size="11" tabindex=4 style="font-family: Arial; font-size: 11px; color: #000080" onmouseover="return overlib('select the expected end date of the resource', RIGHT, BELOW, BGCOLOR, '9d102d', FGCOLOR, 'EFEFEF', CAPCOLOR, 'ffffff', CAPTION,  'Field Help - Required');" onmouseout="return nd();"> <a href="javascript:void(0)" onclick="if(self.gfPop)gfPop.fPopCalendar(document.FrontPage_Form1.eff_to_date);return false;" HIDEFOCUS>
<img class="PopcalTrigger" align="top" src="/s2dPOC/images/cal.gif" border="0" alt="" width="16" height="16"></a>
                  </td>
          </tr>
                  <tr>
        <td width="165" style="vertical-align: middle" height="20">
        <font face="Arial" style="font-size: 11px">Standard Cost
            for <font color="#9D102D"><%=(tyear)%></font></td>
        <td style="vertical-align: bottom" height="20" width="100%">
   
<!--webbot bot="Validation" s-display-name="standard cost" b-value-required="TRUE" --><INPUT NAME="res_stdcost" SIZE=9 onchange="calculate_cost(this, 'cost')" onmouseover="return overlib('resource number of the resource element within the supply catalog', RIGHT, BELOW, BGCOLOR, '9d102d', FGCOLOR, 'EFEFEF', CAPCOLOR, 'ffffff', CAPTION,  'Field Help');" onmouseout="return nd();" style="font-family: Arial; font-size: 11px; color: #333333" tabindex="5"></td>
          </tr>
                  <tr>
        <td width="165" style="vertical-align: top" height="20">
      <table border="0" width="100%" cellpadding="0" id="table1" cellspacing="0">
            <tr>
                  <td bgcolor="#FFFFFF" width="165">
                  <font face="Arial" style="font-size: 11px">Forward Costing + Years
                  </font>
                  </td>
            </tr>
            <tr>
                  <td style="vertical-align: top" width="165" height="33%">
                  <font face="Arial" style="font-size: 11px">   <font color="#FFFFFF">
                  -&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </font><font color="#808080">Percentage</font></font><img border="0" src="../../images/dot_clear.gif" height="16"></td>
            </tr>
            <tr>
                  <td style="vertical-align: top" width="165" height="33%">
                  <font face="Arial" style="font-size: 11px">   <font color="#FFFFFF">
                  -&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </font><font color="#808080">Calculated Values</font></font><img border="0" src="../../images/dot_clear.gif" height="16"></td>
            </tr>            
      </table>
            </font><img border="0" src="../../images/dot_clear.gif" width="165" height="1"></td>
        <td style="vertical-align: bottom; text-align:center" height="20" width="0">
   
<div align="left">

      <table border="0" width="30%" cellpadding="0" id="table1" cellspacing="0">
            <tr>
                  <td style="text-align: center; vertical-align: top" bgcolor="#EBEBEB"><font face="Arial" style="font-size: 11px"><%=(tyearp1)%></font></td>
                  <td style="text-align: center; vertical-align: top" bgcolor="#EBEBEB"><font face="Arial" style="font-size: 11px"><%=(tyearp2)%></font></td>
                  <td style="text-align: center; vertical-align: top" bgcolor="#EBEBEB"><font face="Arial" style="font-size: 11px"><%=(tyearp3)%></font></td>
                  <td style="text-align: center; vertical-align: top" bgcolor="#EBEBEB"><font face="Arial" style="font-size: 11px"><%=(tyearp4)%></font></td>
                  <td style="text-align: center; vertical-align: top" bgcolor="#EBEBEB"><font face="Arial" style="font-size: 11px"><%=(tyearp5)%></font></td>
                  <td style="text-align: center; vertical-align: top" bgcolor="#EBEBEB"><font face="Arial" style="font-size: 11px"><%=(tyearp6)%></font></td>
                  <td style="text-align: center; vertical-align: top" bgcolor="#EBEBEB"><font face="Arial" style="font-size: 11px"><%=(tyearp7)%></font></td>
                  <td style="text-align: center; vertical-align: top" bgcolor="#EBEBEB"><font face="Arial" style="font-size: 11px"><%=(tyearp8)%></font></td>
                  <td style="text-align: center; vertical-align: top" bgcolor="#EBEBEB"><font face="Arial" style="font-size: 11px"><%=(tyearp9)%></font></td>
                  <td style="text-align: center; vertical-align: top" bgcolor="#EBEBEB"><font face="Arial" style="font-size: 11px"><%=(tyearp10)%></font></td>
            </tr>
            <tr>
                  <td style="vertical-align: top">
                  &nbsp;<!--webbot bot="Validation" s-display-name="percentage" s-data-type="Number" s-number-separators="x." s-validation-constraint="Greater than or equal to" s-validation-value="0" s-validation-constraint="Less than or equal to" s-validation-value="100" --><INPUT NAME="res_fwdcost1" SIZE=3 onchange="calculate_cost(this, 'y1')" onmouseover="return overlib('forward costing percentage, user should specify any value from -100 to 100', RIGHT, BELOW, BGCOLOR, '9d102d', FGCOLOR, 'EFEFEF', CAPCOLOR, 'ffffff', CAPTION,  'Field Help');" onmouseout="return nd();" style="font-family: Arial; font-size: 11px; color: #333333" tabindex="6" value="0"></td>
                  <td style="vertical-align: top">
                  <INPUT NAME="res_fwdcost2" SIZE=3 onchange="calculate_cost(this, 'y2')" onmouseover="return overlib('forward costing percentage, user should specify any value from -100 to 100', RIGHT, BELOW, BGCOLOR, '9d102d', FGCOLOR, 'EFEFEF', CAPCOLOR, 'ffffff', CAPTION,  'Field Help');" onmouseout="return nd();" style="font-family: Arial; font-size: 11px; color: #333333" tabindex="7" value="0"></td>
                  <td style="vertical-align: top">
                  <INPUT NAME="res_fwdcost3" SIZE=3 onchange="calculate_cost(this, 'y3')" onmouseover="return overlib('forward costing percentage, user should specify any value from -100 to 100', RIGHT, BELOW, BGCOLOR, '9d102d', FGCOLOR, 'EFEFEF', CAPCOLOR, 'ffffff', CAPTION,  'Field Help');" onmouseout="return nd();" style="font-family: Arial; font-size: 11px; color: #333333" tabindex="8" value="0"></td>
                  <td style="vertical-align: top">
                  <INPUT NAME="res_fwdcost4" SIZE=3 onchange="calculate_cost(this, 'y4')" onmouseover="return overlib('forward costing percentage, user should specify any value from -100 to 100', RIGHT, BELOW, BGCOLOR, '9d102d', FGCOLOR, 'EFEFEF', CAPCOLOR, 'ffffff', CAPTION,  'Field Help');" onmouseout="return nd();" style="font-family: Arial; font-size: 11px; color: #333333" tabindex="9" value="0"></td>
                  <td style="vertical-align: top">
                  <INPUT NAME="res_fwdcost5" SIZE=3 onchange="calculate_cost(this, 'y5')" onmouseover="return overlib('forward costing percentage, user should specify any value from -100 to 100', RIGHT, BELOW, BGCOLOR, '9d102d', FGCOLOR, 'EFEFEF', CAPCOLOR, 'ffffff', CAPTION,  'Field Help');" onmouseout="return nd();" style="font-family: Arial; font-size: 11px; color: #333333" tabindex="10" value="0"></td>
                  <td style="vertical-align: top">
                  <INPUT NAME="res_fwdcost6" SIZE=3 onchange="calculate_cost(this, 'y6')" onmouseover="return overlib('forward costing percentage, user should specify any value from -100 to 100', RIGHT, BELOW, BGCOLOR, '9d102d', FGCOLOR, 'EFEFEF', CAPCOLOR, 'ffffff', CAPTION,  'Field Help');" onmouseout="return nd();" style="font-family: Arial; font-size: 11px; color: #333333" tabindex="11" value="0"></td>
                  <td style="vertical-align: top">
                  <INPUT NAME="res_fwdcost7" SIZE=3 onchange="calculate_cost(this, 'y7')" onmouseover="return overlib('forward costing percentage, user should specify any value from -100 to 100', RIGHT, BELOW, BGCOLOR, '9d102d', FGCOLOR, 'EFEFEF', CAPCOLOR, 'ffffff', CAPTION,  'Field Help');" onmouseout="return nd();" style="font-family: Arial; font-size: 11px; color: #333333" tabindex="12" value="0"></td>
                  <td style="vertical-align: top">
                  <INPUT NAME="res_fwdcost8" SIZE=3 onchange="calculate_cost(this, 'y8')" onmouseover="return overlib('forward costing percentage, user should specify any value from -100 to 100', RIGHT, BELOW, BGCOLOR, '9d102d', FGCOLOR, 'EFEFEF', CAPCOLOR, 'ffffff', CAPTION,  'Field Help');" onmouseout="return nd();" style="font-family: Arial; font-size: 11px; color: #333333" tabindex="13" value="0"></td>
                  <td style="vertical-align: top">
                  <INPUT NAME="res_fwdcost9" SIZE=3 onchange="calculate_cost(this, 'y9')" onmouseover="return overlib('forward costing percentage, user should specify any value from -100 to 100', RIGHT, BELOW, BGCOLOR, '9d102d', FGCOLOR, 'EFEFEF', CAPCOLOR, 'ffffff', CAPTION,  'Field Help');" onmouseout="return nd();" style="font-family: Arial; font-size: 11px; color: #333333" tabindex="14" value="0"></td>
                  <td style="vertical-align: top">
                  <INPUT NAME="res_fwdcost10" SIZE=3 onchange="calculate_cost(this, 'y10')" onmouseover="return overlib('forward costing percentage, user should specify any value from -100 to 100', RIGHT, BELOW, BGCOLOR, '9d102d', FGCOLOR, 'EFEFEF', CAPCOLOR, 'ffffff', CAPTION,  'Field Help');" onmouseout="return nd();" style="font-family: Arial; font-size: 11px; color: #333333" tabindex="15" value="0"></td>

            </tr>
            <tr>
                  <td style="vertical-align: top">
                  <INPUT READONLY NAME="res_fwdcost1C" SIZE=3 style="font-family: Arial; font-size: 11px; color: #333333" tabindex="1"></td>
                  <td style="vertical-align: top">
                  <INPUT READONLY NAME="res_fwdcost2C" SIZE=3 style="font-family: Arial; font-size: 11px; color: #333333" tabindex="1"></td>
                  <td style="vertical-align: top">
                  <INPUT READONLY NAME="res_fwdcost3C" SIZE=3 style="font-family: Arial; font-size: 11px; color: #333333" tabindex="1"></td>
                  <td style="vertical-align: top">
                  <INPUT READONLY NAME="res_fwdcost4C" SIZE=3 style="font-family: Arial; font-size: 11px; color: #333333" tabindex="1"></td>
                  <td style="vertical-align: top">
                  <INPUT READONLY NAME="res_fwdcost5C" SIZE=3 style="font-family: Arial; font-size: 11px; color: #333333" tabindex="1"></td>
                  <td style="vertical-align: top">
                  <INPUT READONLY NAME="res_fwdcost6C" SIZE=3 style="font-family: Arial; font-size: 11px; color: #333333" tabindex="1"></td>
                  <td style="vertical-align: top">
                  <INPUT READONLY NAME="res_fwdcost7C" SIZE=3 style="font-family: Arial; font-size: 11px; color: #333333" tabindex="1"></td>
                  <td style="vertical-align: top">
                  <INPUT READONLY NAME="res_fwdcost8C" SIZE=3 style="font-family: Arial; font-size: 11px; color: #333333" tabindex="1"></td>
                  <td style="vertical-align: top">
                  <INPUT READONLY NAME="res_fwdcost9C" SIZE=3 style="font-family: Arial; font-size: 11px; color: #333333" tabindex="1"></td>
                  <td style="vertical-align: top">
                  <INPUT READONLY NAME="res_fwdcost10C" SIZE=3 style="font-family: Arial; font-size: 11px; color: #333333" tabindex="1"></td>

            </tr>            
      </table>
</div>
            </td>
          </tr>
                  <tr>
        <td width="165" style="vertical-align: middle" height="20">
        <font face="Arial" style="font-size: 11px">Inventory</font></td>
        <td style="vertical-align: bottom" height="20">
   
<!--webbot bot="Validation" s-display-name="inventory" s-data-type="Number" s-number-separators="x." b-value-required="TRUE" --><INPUT NAME="res_inventory" SIZE=8 onmouseover="return overlib('resource number of the resource element within the supply catalog', RIGHT, BELOW, BGCOLOR, '9d102d', FGCOLOR, 'EFEFEF', CAPCOLOR, 'ffffff', CAPTION,  'Field Help');" onmouseout="return nd();" style="font-family: Arial; font-size: 11px; color: #333333" tabindex="16"></td>
          </tr>
          <tr>
        <td width="165" style="vertical-align: top" height="20">
        <font face="Arial" style="font-size: 11px">Status</font></td>
        <td style="vertical-align: bottom" height="20" width="40%">
   
<select size="1" name="status" onmouseover="return overlib('active or inactive, status within the database ', RIGHT, BELOW, BGCOLOR, '9d102d', FGCOLOR, 'EFEFEF', CAPCOLOR, 'ffffff', CAPTION,  'Field Help');" onmouseout="return nd();" style="font-family: Arial; font-size: 11px; color: #333333" tabindex="17">
<option selected>active</option>
<option>inactive</option>
</select></td>
          </tr>
          </table>
         
    <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%">
      <tr>
        <td width="78%" style="vertical-align: bottom" bgcolor="#E6E6E6">
        <p align="left">
&nbsp;</td>
        <td width="22%" style="vertical-align: bottom" bgcolor="#E6E6E6">
        <p align="right">
<INPUT TYPE=submit VALUE="Submit " style="font-family: Arial; color: #111111; font-size: 10px">&nbsp;&nbsp;&nbsp;&nbsp;
<INPUT TYPE=reset VALUE="Reset " style="font-family: Arial; color: #111111; font-size: 10px"></td>
      </tr>
    </table>          
         
        </td>
    </tr>
  </table>
</form>

<!--  PopCalendar(tag name and id must match) Tags should sit at the page bottom -->
<iframe width=174 height=189 name="gToday:normal:agenda.js" id="gToday:normal:agenda.js" src="ipopeng.htm" scrolling="no" frameborder="0" style="visibility:visible; z-index:999; position:absolute; left:-500px; top:0px;">
</iframe></BODY>
</HTML>
0
ThinkPaperIT ConsultantCommented:
>> your code: >>

regionList = GetList("region")
countryList = GetList("country")
'cityList = GetList("city")
buildingList = GetList("building")

function GetList(ByVal LocationType)
     if (locationtype = "region") then
          sFieldName = "facility_geography"
     elseif  (locationtype = "country") then
          sFieldName = "facility_country"
     elseif  (locationtype = "city") then
          sFieldName = "facility_city"
     elseif  (locationtype = "building") then
          sFieldName = "facility_num"
     end if
<< end your code <<

I'm confused as to why you have this in the first part of your code in the first place. All you're doing is setting a value to a variable. Only, it's a more complicated way of doing: (unless you're doing this for testing)
regionList="facility_geography"
countryList = "facility_country"
cityList = "facility_city"
buildingList = "facility_num"

And then in the IF part, you're basically ALWAYS setting sFieldName to "facility_num" because it is overwritten each time, and the last value happens to be building list -- which should always set it to facility_num
and you have no default "else" clause in your ifs..

As for the city, check and make sure that the field name is correct. Also Response.write your SQL query to ensure that the query is correctly written.
0
Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

ThinkPaperIT ConsultantCommented:
=O  lots of code to work with. exactly what error do you get?
0
forrest321Commented:
The where clause in your select looks odd...what exactly is your criteria?  Do you even need the where clause?  Admittedly, I'm not very familiar with mysql, but it should be pretty much the same syntax I'm used to.
0
pinkstonmAuthor Commented:
As stated above the code works perfect until I remove the comment mark ' from the following line

'cityList = GetList("city")

It is not an error none of the fields populate when I select Country, Region, City or Building.

When the line is commented out they al work with the obvious exception of city.  And I need City to work.
0
pinkstonmAuthor Commented:
The Where is eliminating and records that have a BLANK or NULL value in that field.
0
forrest321Commented:
Ahh...the line wrapped and threw me off.  Can you uncomment the city line so the code executes, and post the generated html for the city list?  Is it returning anything at all?
0
pinkstonmAuthor Commented:
thats the problem it is not returning anything for any if I uncomment.
0
forrest321Commented:
This probably isn't the cause of your problem, but you should be destroying the objects you create in your fuction....
 

function GetList(ByVal LocationType)
...

     Conn1.Close
     Rsx.close
     Rst.close
     conn.close
     set Rsx = nothing
     set Rst  = nothing
     set conn1 = nothing
     set conn = nothing

     GetList = List
     'response.write "<br>" & GetList & "<br>"
end function

What happens if you change
  cityList = GetList("city")
to
  cityList  = GetList("country")

I understand this is not the end result you want, I'm just trying to take out a few variables.
0
pinkstonmAuthor Commented:
When I do:

What happens if you change
  cityList = GetList("city")
to
  cityList  = GetList("country")

It works but obviously the value for city drop down is countries
0
pinkstonmAuthor Commented:
More Diags

region-select DISTINCT facility_geography as OptionValue from facility WHERE facility_geography<>'' ORDER BY facility_geography

'AP','CAN','EMEA','LA','US'
country-select DISTINCT facility_country as OptionValue from facility WHERE facility_country<>'' ORDER BY facility_country

'Argentina','Australia','Austria','Belgium','Brazil','Canada','Chile','China','Colombia','Costa Rica','Czech Republic','Denmark','Ecuador','Egypt','Finland','France','Germany','Greece','Guatemala','Honduras','Hong Kong','Hungary','India','Indonesia','Ireland','Israel','Italy','Japan','Korea','Luxemburg','Malaysia','Mauritius','Mexico','Netherlands','New Zealand','Nicaragua','Norway','Panama','Peru','Philippines','Poland','Portugal','Russia','Salvador','Singapore','South Africa','Spain','Sweden','Switzerland','Taiwan','Thailand','Turkey','UAE','UK','US','Venezuela'
city-select DISTINCT facility_city as OptionValue from facility WHERE facility_city<>'' ORDER BY facility_city

'29 Palms','Aberdeen','Abingdon','Adelaide','Adliswil','Agen ','Ahmedabad','Airasca ','Aix en Provence','Alagoinhas','Alajuela','Alameda','Albany','Albuquerque','Alcobendas','Alexandria','Alfreton','Algiers','Allentown','Alpharetta','Alrode Alberton','Altea','Altoona','Alvaro Obregon','Amersfoort','Ames','Amherst','Amiens ','Amstelveen','Amsterdam','Anderlecht','Andover','Andrews Airforce Base','Angers ','Annan','Annapolis','Annapolis Junction','Antwerp','Antwerpen','Apizaco','Apodaca','Araçatuba','Araraquara','Arden Hills','Argenteuil Cédex','Arica','Arlington','Arnhem','Aschheim','Ashburn','Asheville','Asnières','Athens','Atlanta','Auburn','Auburn Hills','Auckland','Aulnay Sous Bois Céd','Austin','Azambuja','Bad Ems','Baie Mahault ','Ballerup','Baltimore','Bangalore','Bangkok','Bangsaphan','Barao De Cocais','Barcelona','Barnoldswick','Barquisimeto','Barranquilla','Barreal de Heredia','Barstow','Barueri','Bascharage','Basel','Basingstoke','Bath','Baton Rouge','Battle Creek','Bauru','Bay City','Beaucaire ','Beaufort','Bedford','Bedford Park','Bedfordview','Bedminster','Bègles','Beiijing','Beijing','Belem','Belfast','Bellaire','Bellevue','Bellshill','Belo Horizonte','Benito Juarez','Bensalem','Berazategui','Berkeley Springs','Berlin','Berne','Besancon ','Bethesda','Bethlehem','Bicester','Biddeford','Bielsku-Bialej','Birmingham','Bitritto','Blackpool','Blasdell','Bloomfield ','Bloomfield Hills','Bloomington','Boadilla','Boadilla del Monte ','Boca Raton','Bochum','Boecillo','Boetzingen','Bogota','Boise','Bonita Springs','Bonn','Boston','Bötzingen','Boulder','Bourne End','Bournemouth','Bowen Hills','Bowling Green','Bozeman','Braintree','Brampton','Brasília','Brea','Breda','Bremen','Bremerton','Brentford','Brentwood','Brest ','Breukelen','Bridgeville','Brighton','Brisbane','Bristol','Brockton','Bromley','Brookfield','Brookhaven','Broomfield','Bruma','Brumadinho','Brunswick','Brussel','Bryanston','Bucaramanga','Budaörs','Budapest','Buenos Aires','Buenos Aries','Buffalo','Buffalo Grove','Burbank','Burlington','Burns Harbor ','Burnsville','Burton upon Trent','Burton-on-Trent','Burwood','Cairo','Caithness','Cajamar','Calabozo','Calais ','Calgary','Cali','Camberley','Cambridge','Caminho Das Arvores','Camp Hill','Camp Lejuene','Camp Pendleton','Campana','Campinas','Campo Grande / MS','Canaa dos Carajas','Canary Wharf','Canberra','Cancun','Candeias','Canly ','Canoas','Canton','Cape Town','Capelle a.d. Ijssel','Capital Federal','Caracas','Cardiff','Carmel','Carrollton','Cartagena','Cary','Caserta','Caterham','Cedar Rapids','Celaya','Central Mall','Centro','Cerritos','Chacara Snto. Antonio','Chambersburg','Chantilly','Charleston','Charlotte','Charlottenlund','Charlottetown','Chattanooga','Cheadle','Chennai','Cherry Hill','Cherry Point','Chesapeake','Chesterfield','Chesterton','Chicago','Chico','Chihuahua','China Lake','Chongqing','Christchurch','Cincinnati','City of Industry','Ciudad de Mexico','Ciudad Juarez','Clarion','Clayton','Clevedon','Cleveland','Clichy','Clinton','Coatepec','Coatesville','Cognizant - Mulitple Locations','Colnbrook','Cologne','Colombes ','Colorado Springs','Columbia','Columbus','Commerce','Concord','Contagem / MG','Conway','Copehagen West','Copenhagen','Coraopolis','Cordoba','Coronado','Corpus Christi','Corydon','Coslada','Cosmópolis','Costa Mesa','Cottondale','Coueron','Cournon dAuvergne','Coventry','Coyoacan','Crane','Cranford','Cranston','Crawley','Creve Coeur','Cuauhtemoc','Cucuta','Curitiba','Cyberjaya','Cypress','Dahlewitz','Dahlgren','Dallas','Dandenong','Darlington','Darmstadt','Dayton ','Dearborn','Debrecen','Defiance','Delta','Den Bosch','Den Haag','Denver','Derby','Des Moines','Detroit','DF','DFW Airport','Diemen','Dipeenbeek','Divinopolis','Donchery','Donnington','Doraville','Dortmund','Downers Grove','Drayton Valley','Dresden','Dryden','Dubai','Dublin','Duitama','Duiven','Duluth','Dumbarton','Dunedin','Durham','Düsseldorf','Eagan','Ealing','Earth City','East Chicago','East Yorkshire','Eatontown','Ecorse','Edegem','Edgecumbe','EDIF.CORP.FINAN.CENT','Edinburgh','Edison','Edmonton','Eger','Eisenach','Eisenhüttenstadt','El Centro','El Dorado Hills','El Paso','El Segundo','Elgin','Elizabeth','Elk Grove Village','Ellesmere Port','Elmhurst','Elmsford','Empalme','Enfield','Englewood','Ensenada','Epinay Sur Seine ','Erlangen','Espoo','Essen','Estissac ','Etterbeek','Etters','Ettlingen','Europoort','Everett','Exeter','Exton','Fairborn','Fairfax','Fairmont','Fallon','Falls Church','Fareham','Faribault','Farmington','Farmington Hills','Farnborough','Federal Way','Feytiat ','Figueruelas','Findlay','Fishers','Fleet','Flint','Florencio Varela','Florianópolis','Flowery Branch','Folsom','Fort Belvior','Fort Lauderdale','Fort Mill','Fort Smith','Fort Snelling','Fort Wayne','Fort Worth','Frankfort','Frankfurt','Frankfurt am Main','Frankfurt/Main','Frankfurt/Oder','Frazer','Fredericton','Freyming Merlebach','Ft Saskatchewan','Ft. Knox','Fuencarral','Fussy','Gadsden','Gaithersburg','García','Garín','Gastonia','Gateshead','Gatneau','Gedera','Geleen','Geneva','Gennevilliers','Genoa','Genova','Georgsmarienhütte','Getafe','Glasgow','Glattbrugg','Glebe','Glen Allen','Glen Rock','Glendale','Glenside','Glenview','Gliwice','Gloucester Gloucestershire U','Godoy Cruz','Golden','Goleta','Gomez Palacio','Goose Creek','Gosport','Gostyn','Gothenburg','GOV. VALADARES - MG','Grafton','Grand Blanc','Grand Prairie','Grand Quevilly ','Grand Rapids','Grande Prairie','Grangemouth','Granite City','Graniteville','Gravataí / RS','Graz','Great Missenden','Green Bay','Greensboro','Greensburg','Greenville','Groningen','Groton','Guadalajara','Guadalupe','Guarda','Guarenas','Guaruja','Guatemala','Guaynabo','Guelph','Guerville','Guildford','Gulfport','Gurgaon','Gyõr','Haedo','Halifax','Hällefors','Hamburg','Hamilton','Hamm','Hannover','Hanover','Harrisburg','Harrow','Hartford','Hastings','Hato Rey','Hawesville','Heathrow','Heidelberg','Helsinki','Hemel Hempstead','Hermosillo','Herndon','Herouville Saint Clair ','Herzliya','Herzogenaurach','Herzogenrath','Hidalgo del Parral','High Point','High Wycombe','Hilliard','Hingham','Hodgkins','Hoek','Hofors','Honeoye Falls','Hong Kong','Honolulu','Hook','Horsham','Hounslow','Houston','Hucknall','Hudson','Hull','Huntersville','Huntingdon','Huntingwood','Ibague','Idle','Indaiatuba','Indian Head','Indianapolis','Ingersoll','Ingleside','Ingolstadt','Ingres ','Innsworth','Interlagos','Ipatinga','Irapuato','Irvine','Irving','Istanbul','Itabira','Itaguai','Jackson','Jacksonville','Jakarta','Jamestown','Janesville','Jersey City','Jerusalem','Johannesburg','Johnson City','Johnstown','Johor','Jundiaí','Kaiserslautern','Kajang','Kamloops','Kaneohe Bay','Kansas City','Karben','Katrineholm','Kecskemét','Kettering','Keyport','Kiel','Kings Lynn','Kingsbay','Kitchener','Kittery','Kjeller','Koblenz','Kokomo','Köln','Krakow','Kuala Lumpur','Kulpsville','La Crosse','LA DEFENSE','La Garenne-Colombes','La Grange','Lachine','Lackawanna','Lake Buena Vista','Lake Oswego','Lakehurst','Lakewood','Lancaster','Lansing','Laredo','Largo','Las Vegas','Launceston','Lausanne','Le Blanc Mesnil','Le Havre','Le Lamentin ','Le Tampon','Leça da Palmeira','Leeds','Leeuwarden','Leicester','Lemoore','Leon','Leuna','Leuven','Leverkusen-Opladen','Lewisville','Lexington','Lima','Linden','Lingolsheim','Linhó','Linlithgow','Linwood','Lisboa','Little Rock','Littleton','Livermore','Liverpool','Livingston','Livonia','Livorno','Livry Gargan ','Lockport','Lod','Lodi','Lombard','London','London - Canary Wharf','Longmont','Longview','Lordstown','Lorient ','Los Angeles','Los Indios','Los Mochis','Losone','Louisville','Lüchow','Ludwigsburg','Luton','Luxembourg','Lynchburg','Lyon','Lytham','Maastricht','Madison','Madison Heights','Madrid','Maidenhead','Maitland','Makati City','Malmö','Managua','Manaus ','Manchester','Mangalore','Mannheim','Mantes La Ville','Maraba ','Maracaibo','Mariana','Marilia','Marion','Markham','Marlborough','Marsannay La Cote','Martinez','Maryland Heights','Marysville','Massena','Massy','Matamoros','Maturin','Mauguio ','Maynard','Mayport','Mazatlan','McHenry','McKinney','McLeansville','Mechanicsburg','Mechelen','Medellin','Melbourne','Memphis','Mendota Heights','Mendoza','Merida','Meriden','Meridian','Mesa','Mexicali','Mexico','Mexico City','Meylan','Miami','Middelburg','Midland','Miguel Hidalgo','Mijdrecht','Milan ','Milano','Milford','Millbrook','Millington','Milpitas','Milton','Milton Keynes','Minneapolis','Miramar','Mishawaka','Miskolc','Mississauga','Mitcheldean','Modena','Moline','Monona','Monroe','Monroeville','Monrovia','Montataire','Monteria','Monterrey','Montgomery','Montigny Le Bretonneux ','Montreal','Montvale','Moraine','Morristown','Morsang Sur Orge','Moscow','Moulins Les Metz ','Mount Laurel','Mount Vernon','Mountain View - Sunnyvale','Mulhouse','Mumbai','Münchberg','München','Münster','Nanaimo','Nanterre','Nantes ','Nanticoke','Napa','Napoli','Narbonne','Nashua','Nashville','Natick','Neath','Neiva','Netanya','Netherlands','Netherton','Nettingsdorf','Neuhausen','Neuilly Sur Seine','Neu-Isenburg','Neuss','Neustadt / Weinstraß','New Britain','New Castle','New Delhi','New Orleans','New York','Newark','Newbridge','Newbury','Newcastle','Newcastle Upon Tyne','Newcastle West','Newport','Nieuwegein','Niteroi','Noida','Norco','Norcross','Norfolk','Norristown','North Brunswick','North Chicago','North Hollywood','North Kansas City','North Royalton','North Sydney','North York','Northampton','Northridge','Nottingham','NOVA ERA','Nova Iguaçú','NUCLEO URBANO','Nuevo Casas Grandes','Nuevo Laredo','Nürnberg','Nva. San. Salvador','Nyíregyháza','Nyköping','Oahu','Oak Brook','Oak Creek','Oak Harbor','Oak Ridge','Oakland','Oaxaca','Oberursel','Ocala','Oeiras','OFallon','Offenbach','Oklahoma City','Omaha','Ontario','Orion','Orlando','Osasco','Oshawa','Oslo','Ottawa','Overland Park','Oviedo','Palmerston North','Palo','Palomar','Pamplona','Panama','Panama City ','Paris','Paris La Défense','PARIS LA DEFENSE Céd','Parma','Parris Island','Parsippany','Parthenay','Pasadena','Pascagoula','Pasto','Patuxent River','Pavia','Pécs','Pendelton','Pensacola','Pequia','Pereira','Petah Tikva','Petaling Jaya','Petaluma','Peterborough','Peterlee','Philadelphia','Phoenix','Pindaré Mirim','Pinheiros','Piracicaba','Piscataway','Pittsburgh','Plano','Pluakdaeng','Plymouth','Point Mugu','Pointe à Pitre - Guadeloupe','Pomezia - RM','Pompano Beach','Ponte de Sôr','Pontiac','Poole','Port Alberni','Port Allen','Port Elizabeth','Port Hueneme','Port Luis','Port Melbourne','Port Neches','Port Talbot','Portage','Portela de Queijas','Portland','Porto Alegre','Portsmith','Portsmouth','Potenza','Poulsbo','Pozzuoli','Prague','Praha 4','Preston','Prince Albert','Pringy','Providence','Pt Hawkesbury','Puebla','Puerto Real','Pune','Punta Gorda','Puteaux','Pyrmont','Quantico','Quarry Bay','Quebec City','Querétaro','Quincy','Quito','Rabahidveg','Radnor','Raleigh','Ramat Hasharon','Rancho Cordova','Rancho Cucamonga','Raynham','Reading','Recife / PE','Redditch','Redford','Redmond','Redwood City','Reggio Emilia','Regina','Reims','Rennes','Resende','Reynosa','Rhodes','Richardson','Richfield','Richmond','Ridgefield Park','Rio de Janeiro','Roanoke','Rochefort','Rochester','Rockland','Rockville','Rocky Hill','Roissy CDG Cédex','Roma','Rome','Romford','Romulus','Ros. Do Catete','Rosario','Rösrath','Rosslyn','Rotterdam','Ruesselsheim','Rüsselsheim','Rustenburg','Rutherford','Rye Brook','S. Donato Milanese','Sabara','Sacramento ','Saginaw','Saint Charles','Saint Denis','Saint Denis - La Réunion','Saint Doulchard','Saint Etienne','Saint Etienne du Rouvray','Saint John','Saint Laurent du Var','Saint Rémy','Saint Vallier Cedex','Salem','Salford','Salinas','Salt Lake City','Saltillo','Salvador','Samitri','San Antonio','San Cristobal','San Diego','San Félix','San Fernando','San Francisco','San Isidro','San Jose','San Leandro','San Luis Potosi','San Mateo','San Nicolas','San Nicolás','San Pedro Garza Garcia','San Pedro Sula','San Ramon','Sandusky','Sant Cugat','Sant Cugat del Valles','Santa Barbara','Santa Clara','Santa Luzia','Santiago','Santiago de Chile','Santo André','Santos','Santurce','Sao Bernardo','Sao Bernardo do Campo','São Caetano do Sul','São José do Rio Preto','São José dos Campos','São Luis - MA','Sao Paulo','São Paulo','Sault Ste Marie','Scarborough','Schaumburg','Schiedam','Schwalbach','Schweinfurt','Scotts Valley','Scottsdale','Seal Beach','Seaside','Seattle','Seixal','Seoul','Seymour','Shanghai','Sheffield','Shenzhen','Shepshed','Shetland','Shipley','Shrevport','Siena','Silao','Silver Spring','Silverdale','Sines','Singapore','Sittard','Sliedrecht','Slough','Smyrna','Solna','Somerset','Sorocaba','South Dunedin','South Gyle','South Melbourne','Southend on Sea','Southfield','Southlake','Sparrows Point','Spartansburg','Spijkenisse','Spokane','Spring Hill','Springfield','Springs','St Avertin','St Charles','St Cyr Sur Loire','St Helens','St Louis','St Petersburg','St. Catharines','St.Denis','Stamford','Stanford-Le-Hope','Stansted','Staunton','Ste Foy','Steelton','Stennis Space Center','Sterling Heights','Steyr','Stockholm','Strasbourg','Strasbourg Cédex','Stuttgart','Sulzbach','Sunbury on Thames','Sunderland','Sunnyvale','Surrey','Surry Hills','Swansea','Swanwick Southampton','Swindon','Sydney','Szekszárd','Szentgotthárd','Szolnok','Taboao','Tacoma','Tadcaster','Taichung ','Taipei','Tallahassee','Tampa','Tampines','Tamworth','Tapachula','Tapolca','Tarazona','Tarbes','Tarnos','Taunton','TBD','TBD - Sao Paulo','TBD - Tier II - Curitiba','Tel-Aviv','Telford','Teloche','Tempe','test','Tewkesbury','Theale','Thornby','Three Rivers','Tijuana','Tinker AFB','Tlalnepantla','Tlaxcala','Tokyo','Toledo','Toluca','Tonawanda','Tongeren','Topeka','Torbali','Torino','Toronto','Torrance','Tortuguitas','Totowa','Toulon La Garde ','Toulouse ','Tres Cantos','Trollhattan','Troy','Tucker','Tucson','Tulsa','Turin','Turnhout','Tuscaloosa','Tuxtla Gutierrez','Uberlandia','Ultimo','Unterpremstatten','Upper Hutt','Urbandale','Utrecht','Uxbridge','Valence','Valencia','Valladolid','Valledupar','Valparaiso','Vancouver','Vasvar','Veenendaal','Velizy ','Velizy Cedex','Venray','Venustiano Carranza','Veracruz','Vialonga','Vicenza','Victoria','VICTORVILLE CA 92392-4795','Vienna','Vila Anastacio','Vila Nova de Gaia','VILLAHERMOSA','Villavicencio','Villeneuve D'Ascq Cedex','Vilvoorde','Virgina Beach','Virginia Beach','Vitoria','Vlissingen','Wakefield','Walldorf','Walnut Creek','Wanganui','Wareham','Warren','Warrington','Warsaw','Warwick','Washington','Waterloo','Wattignies','Waukesha','Wayne','Waynesboro','Webster','Weehawken','Wellington','Welwyn Garden City','Wentzville','West Harriet','West Mifflin','West Palm Beach','West Palm Beach ','West Scaramento','Westerville','Westlake','Westwego','Whangarei','Whitby','White Marsh','White Plains','Whitehall','Wichita','Wien','Williamsport','Willich-Muenchheide','Williston','Wilmington','Wilrijk','Wincester','Winchester','Windsor','Winnipeg','Winston Salem','Witfield','Woerden','Wolfsburg','Wolvega','Wolverhampton','Woodbury','Woodridge','Woodstock','Worthing','Wright Patterson AFB','Wuhan','Wuppertal','Wyoming','Xalostoc','Yeovilton','Yokneam','York','Youngstown','Ypsilanti','Yuma','Zaandam','Zabierzow','Zafra','Zamora','Zapopan','Zaragoza','Zaventem','Zoetermeer','Zurich','Zurich - Airport','Zürich-Flughafen','Zutphen'
building-select DISTINCT facility_num as OptionValue from facility WHERE facility_num<>'' ORDER BY facility_num

'AR-BABGM','AR-BABIM','AR-BABIS','AR-BAMCK','AR-BANTE','AR-BANVS','AR-BAPEU','AR-BASKF','AR-BATS2','AR-BATSD','AR-BATSE','AR-BATSF','AR-BATSI','AR-BATSS','AR-BIMMA','AR-CAMFU','AR-CAZOP','AR-CCRM','AR-CFBBE','AR-CFBC','AR-CFBF','AR-CFBPA','AR-CFBR','AR-CFFC','AR-CFFP','AR-CFGM','AR-CFGMA','AR-CFHQU','AR-CFINT','AR-CFREN','AR-CFSAB','AR-CFSKF','AR-CFTCP','AR-CFTSD','AR-COAND','AR-CORC','AR-CORDB','AR-DOW-M','AR-DOWSI','AR-EMEL','AR-EXIRO','AR-FRVEN','AR-GLSC','AR-INTER','AR-MEAND','AR-MEBRC','AR-OLAD','AR-PBBP','AR-ROAND','AR-ROFLI','AR-ROGMR','AR-ROSGM','AR-TECAL','AT-GRHL','AT-NEPA','AT-SSKF','AT-WIBM','AT-WICO','AT-WIHQ','AT-WIMM','AT-WIOP','AT-WIUT','AT-WIXE','AU-ACT02','AU-ACT03','AU-ACT07','AU-ACT08','AU-NSW03','AU-NSW04','AU-NSW05','AU-NSW07','AU-NSW09','AU-NSW10','AU-NSW13','AU-NSW16','AU-NSW17','AU-NSW19','AU-NSW24','AU-NSW27','AU-NSW30','AU-NSW31','AU-NSW36','AU-NSW37','AU-NSW44','AU-NSW46','AU-NSW47','AU-NSW48','AU-NSW50','AU-NSW53','AU-NSW54','AU-NSW55','AU-NSW56','AU-NSW57','AU-NSW58','AU-QLD04','AU-QLD08','AU-QLD09','AU-QLD10','AU-SA03','AU-SA06','AU-SA22','AU-SA24','AU-SA29','AU-SA53','AU-TAS02','AU-VIC03','AU-VIC06','AU-VIC07','AU-VIC14','AU-VIC17','AU-VIC18','AU-VIC29','AU-VIC31','AU-VIC36','BE-ANAT','BE-ANBE','BE-ANCC','BE-ANCEN','BE-ANKBC','BE-ANPL2','BE-ANZIN','BE-BRABC','BE-BRAT','BE-BRBS','BE-BRDE','BE-BRDI','BE-BRFI','BE-BRFKA','BE-BRFZI','BE-BRHV','BE-BRKE','BE-BRLV','BE-BRPO','BE-BRRT','BE-BRSA','BE-BRTR','BE-BRVGB','BE-BRVGC','BE-BRVGF','BE-BRVGN','BE-BRVGP','BE-BRVGS','BE-BRWO','BE-DICIP','BE-EDDO','BE-ETING','BE-LEBR','BE-LEKBC','BE-LESTA','BE-MALI','BE-MAVO','BE-MEBT','BE-MEKBC','BE-TOSKF','BE-TUFO','BE-VIKOM','BE-WIAC','BE-ZADHL','BE-ZAWZ','BR-ACCV','BR-ADTEL','BR-ALCV','BR-ALFCA','BR-ALVIS','BR-BACV','BR-BADOW','BR-BAREA','BR-BATEL','BR-BECV','BR-BHCV','BR-BHXEH','BR-BRADM','BR-BRGM','BR-BRXE','BR-CATEL','BR-CFFER','BR-CMCV','BR-COGE','BR-CUXEC','BR-CUYOR','BR-DVFCA','BR-ESAND','BR-ESCV','BR-ESXEV','BR-FCESP','BR-GADOW','BR-GECV','BR-GMMOG','BR-GRGM','BR-GSCV','BR-GVCV','BR-H7TAM','BR-INGM','BR-IPCV','BR-MACV','BR-MAXEM','BR-MGCV','BR-MGFER','BR-MOCV','BR-MRCV','BR-NECV','BR-PACV','BR-PAXE','BR-PLFCA','BR-PMCV','BR-RENET','BR-REXE','BR-RJAN','BR-RJCAR','BR-RJCV','BR-RJEMB','BR-RJFCA','BR-RJFER','BR-RJLAP','BR-RJNET','BR-RJPRO','BR-RJPXV','BR-RJSAB','BR-RJXE','BR-RPROM','BR-RSYOR','BR-SACV','BR-SATEL','BR-SAVIS','BR-SAXE','BR-SBBSC','BR-SBRR','BR-SBSMC','BR-SCAB','BR-SCBSC','BR-SCBSF','BR-SCBU','BR-SCBUS','BR-SCGMG','BR-SCGMQ','BR-SCGOI','BR-SECV','BR-SJGMS','BR-SOGM','BR-SOSCV','BR-SPABR','BR-SPAMC','BR-SPARA','BR-SPBEA','BR-SPCOM','BR-SPCV','BR-SPDOW','BR-SPDT','BR-SPDUK','BR-SPGAT','BR-SPGE','BR-SPGMI','BR-SPINT','BR-SPITA','BR-SPJK','BR-SPNAU','BR-SPNET','BR-SPPAC','BR-SPPAN','BR-SPPJ','BR-SPSAB','BR-SPSKF','BR-SPTAM','BR-SPTE7','BR-SPTEL','BR-SPTEM','BR-SPTIC','BR-SPTWP','BR-SPVES','BR-SPXE','BR-SPYOR','BR-STCV','CA-ALAN','CA-BABA','CA-BRSP','CA-CA29','CA-CA3S','CA-CA4A','CA-CA6A','CA-CA6B','CA-CHGA','CA-CHQS','CA-CHUA','CA-DRDR','CA-DRDU','CA-ED10','CA-ED104','CA-ED15','CA-ED1A','CA-ED1C','CA-ED97','CA-ED9A','CA-ED9B','CA-EDST','CA-FRCA','CA-FRQU','CA-FSHI','CA-GABL','CA-GP7M','CA-GUVR','CA-HAKS','CA-HAWI','CA-HAWS','CA-HAYO','CA-HULM','CA-ININ','CA-KAMF','CA-LACL','CA-LODU','CA-MAIPC','CA-MICC','CA-MIED','CA-MIKT','CA-MTAP','CA-MTMC','CA-MTME','CA-MTR1','CA-MTRE','CA-MTRL','CA-NACO','CA-NAFR','CA-NYSH','CA-NYVP','CA-NYWA','CA-OSCHQ','CA-OSDI','CA-OSKA','CA-OSKB','CA-OSKC','CA-OSKS','CA-OSON','CA-OSWE','CA-OTBL','CA-OTBS','CA-OTCY','CA-OTKE','CA-OTLA','CA-OTMR','CA-OTOC','CA-OTOR','CA-OTOS','CA-OTVP','CA-PAHI','CA-PTHW','CA-QCCB','CA-RE11','CA-REA3','CA-RECA','CA-REH1','CA-REHA','CA-RELO','CA-RERD','CA-RES1','CA-RES2','CA-RESC','CA-RESS','CA-REV1','CA-REV2','CA-REV4','CA-REV5','CA-SCBI','CA-SCEX','CA-SFRE','CA-SJCR','CA-SMPS','CA-STGL','CA-STON','CA-SYWE','CA-TOEA','CA-TOJO','CA-TOKS','CA-TOLA','CA-TOSA','CA-TOSH','CA-TOSP','CA-TOVP','CA-TOXE','CA-TOYO','CA-VABU','CA-VAW1','CA-VAW2','CA-VAW3','CA-VICS','CA-VIHU','CA-VIO2','CA-VIO5','CA-VIQC','CA-VIRE','CA-WHWNO','CA-WICA','CA-WICB','CA-WICS','CA-WIG2','CA-WIGA','CA-WIGR','CA-WIGS','CA-WIJE','CA-WIKI','CA-WILO','CA-WILP','CA-WIMA','CA-WIMN','CA-WIMS','CA-WIOB','CA-WIOS','CA-WIPA','CA-WIPO','CA-WIWO','CA-WOPA','CH-BAEU','CH-BEDN','CH-BSFB','CH-GECN','CH-LSFG','CH-LSVE','CH-SHNE','CH-TIAG','CH-ZHFT','CH-ZHGS','CH-ZHMP','CH-ZHSH','CH-ZUAV','CH-ZUBA','CH-ZUBB','CH-ZUBL','CH-ZUFH','CL-AEROP','CL-ANDCO','CL-ARGMC','CL-BANCO','CL-BMTTO','CL-ECORP','CL-EDO10','CL-MIRAF','CL-SAAND','CL-SABIM','CL-SADOW','CL-SAEML','CL-SAGMC','CL-SAHEA','CL-SASAB','CL-SKF','CL-VALP','CN-BJWTC','CN-SHHBT','CN-SHKC','CN-SHSIT','CN-SNARM','CO-BARR','CO-BO004','CO-BO009','CO-BO026','CO-BO028','CO-BO032','CO-BO033','CO-BOTC','CO-BUCA','CO-CABO','CO-CALI','CO-CUCU','CO-DUIT','CO-IBAG','CO-MEDN','CO-MONT','CO-NEIV','CO-PAST','CO-PERE','CO-VALL','CO-VILA','CR-FMHE','CR-SABC','CR-SAPT','CZ-14000','CZ-BBC','CZ-PROL','CZ-PRST','CZ-PRTH','CZ-PRVI','CZ-STPA','DE-BEB3','DE-BEBO','DE-BECS','DE-BEGK','DE-BLIG','DE-BNDT','DE-BNDT2','DE-BOGM','DE-BOVS','DE-BRRM','DE-BRSB','DE-BZBZ','DE-BZS9','DE-DAES','DE-DOIG','DE-DOIT','DE-DRFR','DE-DRSNS','DE-DSIC','DE-DUDU','DE-DUIG','DE-DWRR','DE-EHEK','DE-EIGM','DE-ERIG','DE-ESKA','DE-ETMV','DE-FFIG','DE-FFSA','DE-FFTS','DE-FOWI','DE-FRAA','DE-FRBA','DE-FRES','DE-HAAD','DE-HACN','DE-HAHA','DE-HAIS','DE-HDIG','DE-HHBA','DE-HHJA','DE-HZCS','DE-INRI','DE-KAGM','DE-KARU','DE-KBTS','DE-KLIG','DE-KODE','DE-KOIG','DE-KOKO','DE-KOSO','DE-LEKD','DE-LUKB','DE-LVCR','DE-LWSK','DE-MAMM','DE-MBAG','DE-MSDT','DE-MUC3','DE-MUIG','DE-NERX','DE-NUNU','DE-NUUS','DE-NWIN','DE-OBRR','DE-OFPR','DE-OSG1','DE-ROGK','DE-RU02','DE-RU43','DE-RU48','DE-RU52','DE-RU54','DE-RU56','DE-RU58','DE-RUELF','DE-RUKO','DE-STBW','DE-STIG','DE-SWDOW','DE-SWLS','DE-SWSK','DE-WAAL','DE-WU01','DE-WUDE','DK-BABO','DK-CHAR','DK-DSB1','DK-KOST','EC-QUPN','EG-CACP','ES-BAAU','ES-BADI','ES-BANES','ES-BAPSJ','ES-CADI','ES-DELBC','ES-EADS','ES-FIGU','ES-GALP','ES-ISBAN','ES-LOGIS','ES-MAPA','ES-MAPE','ES-OVRO','ES-OVVI ','ES-PAMP','ES-SCEC','ES-SCH','ES-SKF','ES-TARA','ES-TELF1','ES-TELF2','ES-TRES','ES-VALE','ES-VALEC','ES-VALL','ES-VARE','ES-VODAF','ES-WANA','ES-XEROX','ES-ZAFR','ES-ZAGO','ES-ZAOME','ES-ZRPI','FI-ESME','FI-HEPA','FR-ABRX','FR-AERS','FR-AGBC','FR-AIXA','FR-AMQL','FR-APST','FR-ARGM','FR-BBJB','FR-BCCG','FR-BNRL','FR-BRRV','FR-BRTA','FR-CEGU','FR-COUE','FR-CYRLS','FR-DITEN','FR-DNDL','FR-FMRM','FR-FUSS','FR-FYJP','FR-GCDL','FR-GERS','FR-HSBP','FR-JOLIO','FR-LHCG','FR-LHRP','FR-LIRF','FR-LLIC','FR-LOOG','FR-LTAL','FR-LYRR','FR-MCRA','FR-MGZF','FR-MJCA','FR-MLSZ','FR-MONE','FR-MONSK','FR-MONT','FR-MSYA','FR-MZEB','FR-NEAT','FR-NEKI','FR-NNRM','FR-NRLA','FR-NTEA','FR-PAAB','FR-PABL','FR-PABM','FR-PACL','FR-PANT','FR-PARIS','FR-PASG','FR-PLAZA','FR-PRVR','FR-PYVH','FR-RFMP','FR-RMJJ','FR-RNSW','FR-RODL','FR-SAGG','FR-SDQS','FR-SEAD','FR-SRRB','FR-STDEN','FR-STPO','FR-STRAS','FR-STVAS','FR-TLSA','FR-TLSW','FR-TOCG','FR-VCSD','FR-VDAC','FR-VEBGT','FR-VGRN','FR-VLLD','GB-ABBP','GB-ABEDC','GB-ABWH','GB-ALTP','GB-ANDO','GB-ANNW','GB-BABP','GB-BALH','GB-BARN','GB-BASI','GB-BATH','GB-BCAR','GB-BDQE','GB-BECAS','GB-BEMI','GB-BEXE','GB-BICA','GB-BIDI','GB-BINE','GB-BIRM','GB-BLCL','GB-BLME','GB-BLPP','GB-BLSO','GB-BOLVC','GB-BOLVV','GB-BRAD','GB-BRFI','GB-BRIS','GB-BRIST','GB-BRNE','GB-BROM','GB-BRRE','GB-BRSH','GB-BRSI','GB-BRWY','GB-BTFO','GB-BUPO','GB-BUPU','GB-CAGA','GB-CAGU','GB-CAKI','GB-CARAF','GB-CAYH','GB-CDAB','GB-CDDA','GB-CDHA','GB-CDIF','GB-CLEL','GB-COAN','GB-COBP','GB-COLO','GB-COVE','GB-CRAW','GB-CRMR','GB-CRSH','GB-CRSX','GB-CTDO','GB-DEER','GB-DEHU','GB-DERA','GB-DERB','GB-DEVC','GB-DONN','GB-DOWKL','GB-DSMC','GB-DSMCH','GB-DUAD','GB-EABP','GB-EDIF','GB-EDIN','GB-EPNO','GB-EPSP','GB-EXET','GB-EXETH','GB-FAAR','GB-FABR','GB-FACSS','GB-FAFE','GB-FBED','GB-FLCE','GB-FLPL','GB-FLSY','GB-GAAV','GB-GLHI','GB-GLKH','GB-GLMA','GB-GLSE','GB-GLSM','GB-GLST','GB-GLTA','GB-GLVI','GB-GOSP','GB-GRAY','GB-GRBP','GB-GUBO','GB-HAAQ','GB-HACA','GB-HALI','GB-HEBR','GB-HELO','GB-HHGM','GB-HHMP','GB-HKBA','GB-HKBAD','GB-HKBAH','GB-HOBA','GB-HOHOE','GB-HOPR','GB-HUBP','GB-HUCK','GB-INNS','GB-LAGB','GB-LEDS','GB-LEEM','GB-LEIH','GB-LEJO','GB-LEPU','GB-LIMO','GB-LINL','GB-LOAV','GB-LOBA','GB-LOBC','GB-LOBIA','GB-LOBIB','GB-LOBIC','GB-LOBP','GB-LOCAN','GB-LOCGU','GB-LOCLH','GB-LOCU','GB-LODA','GB-LODE','GB-LODI','GB-LODS','GB-LOGO','GB-LOGR','GB-LOHA','GB-LOHI','GB-LOLAN','GB-LOLI','GB-LOLO','GB-LOMI','GB-LOMU','GB-LOPA','GB-LOPH','GB-LOQC','GB-LOQV','GB-LORR','GB-LOSC','GB-LOSH','GB-LOST','GB-LOSW','GB-LOVI','GB-LOWI','GB-LOWY','GB-LUAQ','GB-LUCA','GB-LUDE','GB-LUDO','GB-LUGR','GB-LUKI','GB-LULT','GB-LULU','GB-LUMA','GB-LUTO','GB-LUWY','GB-LVBU','GB-MABA','GB-MAGM','GB-MEAD','GB-MEXE','GB-MIAP','GB-MILL','GB-MKBP','GB-MKCLC','GB-MKKF','GB-MKSGH','GB-MKWT','GB-MTCH','GB-NEBP','GB-NEBU','GB-NECO','GB-NEPL','GB-NESH','GB-NESO','GB-NEST','GB-NEWB','GB-NEWC','GB-NOBA','GB-NOJO','GB-NOPU','GB-NOTT','GB-NTBP','GB-NTNE','GB-PASS','GB-PBCA','GB-PEAH','GB-PEBH','GB-PEBP','GB-PECE','GB-PECH','GB-PEEA','GB-PKHO','GB-POBA','GB-POBP','GB-POLV','GB-POVO','GB-PRAE','GB-PRFU','GB-PRLO','GB-PRQU','GB-PRVH','GB-REAL','GB-REAT','GB-REGR','GB-REWO','GB-ROCE','GB-ROHE','GB-ROSC','GB-SAHO','GB-SCED','GB-SCKR','GB-SCMA','GB-SCRE','GB-SCTD','GB-SDOA','GB-SHBP','GB-SHEF','GB-SHEP','GB-SHIC','GB-SHPH','GB-SHPO','GB-SHPR','GB-SHQU','GB-SHSU','GB-SLFD','GB-SLGFS','GB-SOES','GB-SONA','GB-SOTA','GB-SPAS','GB-STBA','GB-STFL','GB-STOS','GB-SUBP','GB-SUDO','GB-SURO','GB-SWMA','GB-SWOC','GB-SWWA','GB-SYAO','GB-TAMA','GB-TEBO','GB-TEDCS','GB-TEEP','GB-TEGR','GB-TEMA','GB-TEPL','GB-TERE','GB-THVO','GB-TKAI','GB-TRLO','GB-TSAS','GB-TWHE','GB-TWSM','GB-TWTV','GB-UXBR','GB-UXST','GB-WABI','GB-WABP','GB-WACO','GB-WACO3','GB-WADI','GB-WADU','GB-WGBE','GB-WLET','GB-WOBA','GB-WORT','GB-YEDCS','GR-MAET','GT-SABG','HK-CIS','HK-HKCB','HK-HKHC','HK-HKNP','HK-HKQR','HK-IMMD','HK-TPCH','HK-TPLH ','HK-TPWWH','HN-SPBH','HU-BOSZA','HU-BPBAR','HU-BPFEH','HU-BPHOR','HU-BPIN','HU-BPKAL','HU-BPKR','HU-BPMAR','HU-BPPET','HU-BPPH','HU-BPRMC','HU-BPSOR','HU-BPTAV','HU-BPVH','HU-BPVM','HU-DBBG','HU-EGBU','HU-EGER','HU-GYBZS','HU-KECS','HU-MIREP','HU-MIRPO','HU-NYKAL','HU-PERAK','HU-RHID','HU-SZESZ','HU-SZGOT','HU-SZOLN','HU-TAPOL','HU-VSARP','HU-VSBAR','IE-BCBP','IE-DUOP','IE-DUSFD','IE-DUTB','IE-DUXE','IE-FLS','IL-GEBA','IL-KANI','IL-LOKE','IL-NEHA','IL-PETI','IL-RABS','IL-RAGS','IL-SSHE','IL-TAAL','IL-TAAR','IL-TAMB','IL-TAPM','IL-YOK','IN-HY01','IN-IENERGIZER','IN-INFOWAVZ','IN-MH01','IN-MH07','IN-MH08','IN-MH09','IN-TN01','IN-TN02','IN-TN03','IN-TN04','IN-TN05','IN-TNCA ','IT-5173','IT-AIRA','IT-BALM','IT-CETE','IT-GEAP','IT-GECA','IT-MIAT','IT-MIBI','IT-MICE','IT-MIDE','IT-MIMP','IT-MIMQ','IT-MIMV','IT-MIWB','IT-MOSC','IT-MPMS','IT-NA01','IT-NAPO','IT-POIN','IT-PVIN','IT-RMAG','IT-RMBI','IT-RMCC','IT-RMCH','IT-RMCR','IT-RMEN','IT-RMFA','IT-RMGI','IT-RMIA','IT-RMIN','IT-RMINP','IT-RMINS','IT-RMLR','IT-RMMJ','IT-RMMO','IT-RMMOC','IT-RMMT','IT-RMSAC','IT-RMSOF','IT-RMTEL','IT-RMVM','IT-RMVMG','IT-RMWIN','IT-RMWIV','IT-SDEN','IT-SIBS','IT-TOAT','IT-TODE','IT-TOVA','IT-VI01','IT-VICE','JP-TOSK','KR-SEGM','KR-SLFC','KR-SSCT','LU-BALX','LU-LXGD','LU-LXPH','MX-BCBN','MX-BCBPT','MX-CHIBC','MX-CHSFC','MX-CJCAM','MX-CJDEL','MX-CJDES','MX-CJDPE','MX-CJLEC','MX-CJMIX','MX-CJNSC','MX-DFAMX','MX-DFBCM','MX-DFDIA','MX-DFDSC','MX-DFESM','MX-DFFMA','MX-DFFSF','MX-DFFTR','MX-DFGMS','MX-DFGNP','MX-DFLMA','MX-DFLUC','MX-DFMXC','MX-DFPBA','MX-DFSC','MX-DFSC2','MX-DFSC3','MX-DFSEC','MX-DFSFE','MX-DFVPO','MX-DFXEB','MX-DGOBL','MX-GJFTR','MX-GJSKF','MX-GTFTR','MX-GTOBC','MX-JALMO','MX-LGBBA','MX-MEXVC','MX-MEXVZ','MX-MTDEL','MX-MXPH','MX-NLBN','MX-NLMAR','MX-NLSDC','MX-NLVMY','MX-NTDEL','MX-PANAP','MX-PANCO','MX-PANIR','MX-PANLE','MX-PANV','MX-PANZA','MX-PUEBG','MX-PUSKF','MX-QROVQ','MX-RTDEL','MX-SCTEX','MX-SGGM','MX-SINDE','MX-SINMO','MX-SLBPO','MX-SONBN','MX-TABBS','MX-TABFV','MX-TBAMX','MX-TMGM','MX-TTTEX','MX-VERBG','MX-WLDF','MX-WLPN','MX-YUCBS','MX-ZZDEL','MY-CY042','MY-JO037','MY-KA022','MY-KL006','MY-KL007','MY-KL012','MY-KL023','MY-KL024','MY-KL026','MY-KL040','MY-MELA','MY-PJ019','NI-MAPN','NL-ADPL','NL-AMBY','NL-AMDI','NL-AMEL','NL-AMFO1','NL-AMFO2','NL-AMGO','NL-AMGR','NL-AMGU','NL-AMHOO','NL-AMKO','NL-AMPA1','NL-AMPA2','NL-AMPAA','NL-AMRO','NL-AMSP','NL-AMST','NL-AMVIJ','NL-ARRI','NL-BRDE','NL-BRLA','NL-CAQU','NL-CARI','NL-DEHA','NL-DEKO','NL-DEMA','NL-DIEE','NL-DIWI','NL-DUNI','NL-EUDA','NL-GELE','NL-GRQU','NL-HOHE','NL-LELO','NL-LWLA','NL-LWMEM','NL-MAGE','NL-MICO','NL-MIGO','NL-NIKE','NL-ROAE','NL-ROHE','NL-ROHO','NL-SCBW','NL-SIPO','NL-SLBH','NL-SPBW','NL-UTCA','NL-UTCO','NL-UTGR','NL-UTLA','NL-UTLAA','NL-UTLE','NL-UTLI','NL-UTMO','NL-UTOR','NL-VESC','NL-VLGS','NL-VYMW','NL-WOFS','NL-WOTJ','NL-ZAPR','NL-ZOLO','NL-ZUOO','NO-OSAS','NO-SKKV','NZ-AKABN','NZ-AKEL','NZ-AKHS','NZ-AKMD','NZ-AKMW','NZ-AKNL','NZ-AKPST','NZ-AKSF','NZ-AKSKF','NZ-AKTC','NZ-AKTH','NZ-AKYP','NZ-CHCH','NZ-CHTH','NZ-DNDN','NZ-DNMAR','NZ-EDGEC','NZ-HNCS','NZ-HNFOR','NZ-HNHN','NZ-HNLST','NZ-HNVST','NZ-KAURI','NZ-PNDFR','NZ-PNRES','NZ-PNTC','NZ-UHLS','NZ-WGIN','NZ-WNGL','NZ-WNIQ','NZ-WNJQ','NZ-WNMCT','NZ-WNPH','NZ-WNPPC','NZ-WNRNZ','NZ-WNTER','PA-PAEM','PE-LI002','PE-LI003','PL-AFFIN','PL-BIGR','PL-CYBER','PL-DELPH','PL-GLOP','PL-GMWAW','PL-KACH','PL-KRPO','PL-SBWA','PL-WADO','PT-ATRQ','PT-CCVL','PT-CGDL','PT-CTTL','PT-DCPS','PT-DESX','PT-DP01','PT-DP04','PT-GACS','PT-LIDP','PT-LIEU','PT-LIGE','PT-OP01','PT-OP02','PT-PE02','PT-PE03','PT-PE04','PT-RXLX','PT-SEDE','RU-LENPR','SE-GBDA','SE-GBHO','SE-GODR','SE-GOKA','SE-HFRS','SE-HLFS','SE-KTHM','SE-MAAB','SE-NYSP','SE-STBA','SE-STST','SE-TRSA','SE-TRSB','SE-TRSI','SG-SIAA','SG-SIAA1','SG-SICAL','SG-SICS','SG-SIDEL','SG-SIFMC','SG-SIFON','SG-SIGIC','SG-SINA','SG-SIRPC','SG-SISMC','SV-SSBE','TBD-ARBAOFW','TBD-ARCOR','TBD-ARGSC','TBD-ARXRX','TBD-BCVAN','TBD-BRCTREP','TBD-BRGS','TBD-BRSLV','TBD-BRSMC2','TBD-BRSP','TBD-BRSPEX','TBD-BRSPUR','TBD-BRTII','TBD-CAABED','TBD-CACH','TBD-CALA','TBD-CAREG','TBD-CHCQTEMP','TBD-CHGSC1','TBD-CHGSC2','TBD-CHIL','TBD-CHWHTEMP','TBD-CNCQHIL','TBD-COBO','TBD-DKCO','TBD-ESAMURA','TBD-FRLADEF','TBD-GBMKW1','TBD-GBMKW2','TBD-GBMKW3','TBD-GBTEEU','TBD-HUEXP ','TBD-INCH3A','TBD-INCYTEMP','TBD-INPUC8','TBD-JPTO','TBD-KSOP','TBD-KSTPKA','TBD-MXJZ','TBD-NHTBD','TBD-NSWBW','TBD-ONOTW','TBD-PLGSC ','TBD-PLTEMP','TBD-USCAIR','TBD-USCASV','TBD-USCOBO','TBD-USFLTAL','TBD-USGAAT','TBD-USIL','TBD-USMAEHRO','TBD-USMDAJ','TBD-USOHGOV','TBD-USRIWA','TBD-USTXPL','TBD-USWAPO','TBD-WEST','TBD-WIMD','TH-BABNA','TH-BANT','TH-BGEC','TH-BJSCO','TH-BSKF','TH-BSPRA','TH-PLRAY','TR-ISABC','TR-TOGME','TU-BBIS','TW-TACT','TW-TCG','UA-ICDU','US-AL009','US-AL011','US-AL015','US-AL017','US-AL018','US-AL034','US-AL054','US-AR006','US-AR007','US-AR015','US-AZ015','US-AZ016','US-AZ021','US-AZ026','US-AZ028','US-AZ040','US-AZ044','US-AZ059','US-AZ072','US-AZ073','US-AZ074','US-AZ080','US-AZ081','US-AZ085','US-CA080','US-CA082','US-CA083','US-CA084','US-CA085','US-CA089','US-CA091','US-CA092','US-CA100','US-CA102','US-CA103','US-CA104','US-CA106','US-CA107','US-CA111','US-CA118','US-CA120','US-CA123','US-CA124','US-CA126','US-CA128','US-CA129','US-CA134','US-CA135','US-CA138','US-CA141','US-CA147','US-CA160','US-CA165','US-CA173','US-CA184','US-CA185','US-CA187','US-CA199','US-CA207','US-CA209','US-CA214','US-CA216','US-CA245','US-CA249','US-CA258','US-CA259','US-CA266','US-CA271','US-CA272','US-CA277','US-CA278','US-CA282','US-CA290','US-CA295','US-CA300','US-CA302','US-CA312','US-CA314','US-CA315','US-CA318','US-CA320','US-CA321','US-CA328','US-CA330','US-CA334','US-CA344','US-CA350','US-CA358','US-CA361','US-CA362','US-CA367','US-CA368','US-CA373','US-CA374','US-CA376','US-CA377','US-CA378','US-CA381','US-CA386','US-CA387','US-CA390','US-CA391','US-CA392','US-CA393','US-CA394','US-CA395','US-CA396','US-CA397','US-CA398','US-CA399','US-CA400','US-CA401','US-CA402','US-CA410','US-CA412','US-CA413','US-CA416','US-CA421','US-CA425','US-CA428','US-CA432','US-CA435','US-CA442','US-CA445','US-CA448','US-CA451','US-CA465','US-CA469','US-CA472','US-CA475','US-CA489','US-CA491','US-CA518','US-CA522','US-CA526','US-CA528','US-CA529','US-CA708','US-CA718','US-CA766','US-CO020','US-CO022','US-CO024','US-CO027','US-CO031','US-CO041','US-CO048 ','US-CO049','US-CO053','US-CO062','US-CO068','US-CO078','US-CO080','US-CO084','US-CO085','US-CO089','US-CO093','US-CO133','US-CT017','US-CT021','US-CT032','US-CT037','US-CT049','US-CT051','US-CT060','US-CT082','US-DC004','US-DC006','US-DC017','US-DC018','US-DC021','US-DE002','US-DE005','US-DE011','US-FL050','US-FL051','US-FL052','US-FL059','US-FL060','US-FL063','US-FL073','US-FL075','US-FL092','US-FL129','US-FL151','US-FL153','US-FL170','US-FL174','US-FL176','US-FL197','US-FL208','US-FL209','US-FL210','US-FL211','US-FL221','US-FL223','US-FL224','US-FL243','US-FL248','US-FL256','US-FL259','US-FL266','US-FL267','US-FL293','US-FL302','US-FL360','US-FL422','US-GA024','US-GA026','US-GA028','US-GA036','US-GA050','US-GA053','US-GA059','US-GA072','US-GA081','US-GA086','US-GA102','US-GA111','US-GA112','US-GA120','US-GA123','US-GA125','US-GA134','US-GA138','US-GA139','US-GA140','US-GA141','US-GA142','US-GA144','US-GA146','US-GA156','US-GA175','US-HI009','US-HI012','US-HI015','US-HI016','US-IA008','US-IA009','US-IA010','US-IA012','US-IA014','US-IA016','US-IA020','US-IA021','US-IA030','US-IA031','US-IA038','US-ID001','US-ID007','US-ID008','US-IL016','US-IL017','US-IL020','US-IL023','US-IL025','US-IL027','US-IL034','US-IL037','US-IL044','US-IL045','US-IL048','US-IL052','US-IL057','US-IL062','US-IL063','US-IL072','US-IL083','US-IL089','US-IL091','US-IL095','US-IL096','US-IL097','US-IL106','US-IL119','US-IL121','US-IL122','US-IL123','US-IL125','US-IL129','US-IL134','US-IL143','US-IL152','US-IL153','US-IL174','US-IL175','US-IN014','US-IN015','US-IN016','US-IN017','US-IN018','US-IN019','US-IN020','US-IN021','US-IN022','US-IN023','US-IN024','US-IN026','US-IN028','US-IN029','US-IN030','US-IN031','US-IN032','US-IN034','US-IN035','US-IN036','US-IN037','US-IN041','US-IN043','US-IN046','US-IN059','US-IN062','US-IN064','US-IN066','US-IN071','US-IN074','US-IN075','US-IN076','US-IN078','US-IN092','US-IN108','US-IN136','US-IN137','US-IN153','US-KS009','US-KS011','US-KS026','US-KS039','US-KS044','US-KS048','US-KS050','US-KS052','US-KS053','US-KS055','US-KS071','US-KS073','US-KS074','US-KY007','US-KY008','US-KY011','US-KY014','US-KY018','US-KY021','US-KY024','US-KY026','US-KY031','US-KY037','US-KY048','US-LA011','US-LA013','US-LA015','US-LA022','US-LA026','US-LA030','US-LA037','US-MA016','US-MA020','US-MA021','US-MA023','US-MA028','US-MA031','US-MA032','US-MA034','US-MA036','US-MA040','US-MA045','US-MA048','US-MA049','US-MA052','US-MA068','US-MA075','US-MA088','US-MA092','US-MA093','US-MA094','US-MA097','US-MA114','US-MA122','US-MA128','US-MA165','US-MD015','US-MD017','US-MD019','US-MD030','US-MD036','US-MD037','US-MD041','US-MD043','US-MD048','US-MD04M','US-MD054','US-MD056','US-MD057','US-MD062','US-MD064','US-MD076','US-MD085','US-MD087','US-MD093','US-MD098','US-MD100','US-MD107','US-ME005','US-MI036','US-MI037','US-MI039','US-MI042','US-MI045','US-MI046','US-MI047','US-MI049','US-MI051','US-MI053','US-MI054','US-MI055','US-MI056','US-MI057','US-MI058','US-MI059','US-MI060','US-MI061','US-MI062','US-MI063','US-MI064','US-MI065','US-MI066','US-MI068','US-MI069','US-MI071','US-MI072','US-MI073','US-MI074','US-MI075','US-MI076','US-MI077','US-MI078','US-MI079','US-MI080','US-MI081','US-MI082','US-MI083','US-MI084','US-MI085','US-MI087','US-MI088','US-MI092','US-MI094','US-MI096','US-MI098','US-MI099','US-MI101','US-MI102','US-MI103','US-MI104','US-MI105','US-MI106','US-MI107','US-MI108','US-MI109','US-MI110','US-MI111','US-MI112','US-MI113','US-MI114','US-MI115','US-MI116','US-MI121','US-MI127','US-MI129','US-MI130','US-MI131','US-MI132','US-MI134','US-MI135','US-MI136','US-MI137','US-MI138','US-MI140','US-MI141','US-MI144','US-MI145','US-MI153','US-MI156','US-MI162','US-MI163','US-MI171','US-MI173','US-MI177','US-MI179','US-MI180','US-MI182','US-MI188','US-MI189','US-MI197','US-MI198','US-MI200','US-MI201','US-MI204','US-MI207','US-MI216','US-MI218','US-MI234','US-MI246','US-MI248','US-MI251','US-MI256','US-MI259','US-MI260','US-MI263','US-MI264','US-MI265','US-MI267','US-MI270','US-MI271','US-MI279','US-MI282','US-MI292','US-MI297','US-MI298','US-MI300','US-MI301','US-MI303','US-MI309','US-MI311','US-MI315','US-MI320','US-MI321','US-MI330','US-MI334','US-MI339','US-MI340','US-MI343','US-MI344','US-MI346','US-MI348','US-MI353','US-MI360','US-MI361','US-MI368','US-MI370','US-MI390','US-MI400','US-MI409','US-MI415','US-MI422','US-MI423','US-MI424','US-MI425','US-MI428','US-MI429','US-MI458','US-MN008','US-MN010','US-MN012','US-MN014','US-MN018','US-MN021','US-MN028','US-MN030','US-MN042','US-MN043','US-MN045','US-MN064','US-MN065','US-MN066','US-MN070','US-MN106','US-MO019','US-MO020','US-MO025','US-MO026','US-MO029','US-MO030','US-MO033','US-MO037','US-MO039','US-MO042','US-MO054','US-MO063','US-MO064','US-MO065','US-MO066','US-MO067','US-MO068','US-MO070','US-MO076','US-MO077','US-MO086','US-MS002','US-MS003','US-MS008','US-MS011','US-MS014','US-MS026','US-MS033','US-MT005','US-NC017','US-NC018','US-NC019','US-NC021','US-NC022','US-NC025','US-NC029','US-NC030','US-NC036','US-NC040','US-NC050','US-NC063','US-NC064','US-NC066','US-NC069','US-NC073','US-NC076','US-NC077','US-NC082','US-NC091','US-NC095','US-NC097','US-NC104','US-NC112','US-NC119','US-NC120','US-NC122','US-NC123','US-NC124','US-NC140','US-NC144','US-NC168','US-NE008','US-NH003','US-NH005','US-NH009','US-NH013','US-NH018','US-NJ025','US-NJ026','US-NJ030','US-NJ032','US-NJ033','US-NJ035','US-NJ036','US-NJ048','US-NJ054','US-NJ061','US-NJ066','US-NJ074','US-NJ078','US-NJ079','US-NJ080','US-NJ084','US-NJ090','US-NJ097','US-NJ098','US-NJ102','US-NJ109','US-NJ111','US-NJ116','US-NJ11M','US-NJ123','US-NJ127','US-NJ128','US-NJ132','US-NJ150','US-NM014','US-NV018','US-NV022','US-NY036','US-NY037','US-NY038','US-NY040','US-NY042','US-NY045','US-NY046','US-NY047','US-NY051','US-NY057','US-NY058','US-NY059','US-NY061','US-NY068','US-NY072','US-NY076','US-NY084','US-NY086','US-NY095','US-NY100','US-NY102','US-NY115','US-NY119','US-NY122','US-NY130','US-NY139','US-NY144','US-NY147','US-NY148','US-NY151','US-NY159','US-NY164','US-NY173','US-NY177','US-NY178','US-NY179','US-NY190','US-NY199','US-NY200','US-NY208','US-NY212','US-NY222','US-NY223','US-NY224','US-NY232','US-NY257','US-NY289','US-NY313','US-OH027','US-OH028','US-OH029','US-OH030','US-OH032','US-OH034','US-OH035','US-OH036','US-OH037','US-OH039','US-OH040','US-OH041','US-OH044','US-OH047','US-OH049','US-OH050','US-OH051','US-OH053','US-OH054','US-OH065','US-OH079','US-OH089','US-OH092','US-OH102','US-OH110','US-OH118','US-OH121','US-OH134','US-OH135','US-OH156','US-OH164','US-OH169','US-OH192','US-OH197','US-OH200','US-OK007','US-OK008','US-OK023','US-OK025','US-OK027','US-OK034','US-OK037','US-OR015','US-OR029','US-OR034','US-OR037','US-OR046','US-OR076','US-PA014','US-PA015','US-PA016','US-PA017','US-PA022','US-PA023','US-PA026','US-PA027','US-PA028','US-PA029','US-PA030','US-PA032','US-PA033','US-PA041','US-PA042','US-PA044','US-PA045','US-PA058','US-PA060','US-PA065','US-PA066','US-PA073','US-PA080','US-PA087','US-PA092','US-PA093','US-PA094','US-PA095','US-PA098','US-PA099','US-PA104','US-PA105','US-PA110','US-PA114','US-PA116','US-PA135','US-PA148','US-PA198','US-PA237','US-PA238','US-PA241','US-PR004','US-PR006','US-PR008','US-PR009','US-RI004','US-RI005','US-RI009','US-RI010','US-RI017','US-SC012','US-SC018','US-SC021','US-SC026','US-SC028','US-SC032','US-SC048','US-TN009','US-TN012','US-TN013','US-TN017','US-TN026','US-TN038','US-TN041','US-TN048','US-TN054','US-TN055','US-TN082','US-TX052','US-TX053','US-TX054','US-TX065','US-TX066','US-TX067','US-TX071','US-TX073','US-TX075','US-TX076','US-TX078','US-TX081','US-TX085','US-TX086','US-TX091','US-TX092','US-TX094','US-TX095','US-TX097','US-TX106','US-TX107','US-TX120','US-TX140','US-TX150','US-TX155','US-TX159','US-TX181','US-TX194','US-TX207','US-TX211','US-TX212','US-TX238','US-TX247','US-TX256','US-TX259','US-TX260','US-TX262','US-TX269','US-TX277','US-TX281','US-TX288','US-TX296','US-TX298','US-TX305','US-TX310','US-TX313','US-TX316','US-TX317','US-TX339','US-TX341','US-TX346','US-TX347','US-TX349','US-TX363','US-TX375','US-TX395','US-TX406','US-TX408','US-TX411','US-TX412','US-TX416','US-TX441','US-TX475','US-UT007','US-UT014','US-UT016','US-UT018','US-UT019','US-UT033','US-UT035','US-VA017','US-VA019','US-VA020','US-VA023','US-VA024','US-VA026','US-VA027','US-VA031','US-VA034','US-VA042','US-VA057','US-VA064','US-VA083','US-VA088','US-VA095','US-VA101','US-VA110','US-VA119','US-VA123','US-VA132','US-VA135','US-VA137','US-VA138','US-VA143','US-VA144','US-VA154','US-VA15M','US-VA173','US-VA187','US-VT003','US-WA011','US-WA013','US-WA017','US-WA021','US-WA023','US-WA030','US-WA031','US-WA043','US-WA045','US-WA046','US-WA047','US-WA050','US-WA051','US-WA056','US-WA065','US-WA072','US-WA078','US-WA086','US-WA090','US-WA093','US-WA094','US-WA102','US-WA149','US-WI017','US-WI019','US-WI020','US-WI023','US-WI030','US-WI033','US-WI041','US-WI043','US-WI068','US-WI074','US-WV004','US-WV007','US-WV011','VE-CAPAN','VE-CATA','VE-CATC','VE-GUBIM','VE-VAGM','XA-ARBAAM','XA-ATVITR','XA-AUMEWI','XA-AUSYFA','XA-BJWTC','XA-BRRJLM','XA-BRSPJF','XA-CATOQU','XA-CHGPSG','XA-CHZURE','XA-CLSAVI','XA-CNHSBC','XA-CTSOL','XA-CZPROV','XA-DEBECS','XA-DEDUKS','XA-DEMULN','XA-DKCOAM','XA-ESMAPC','XA-FLMBB','XA-FRPADL','XA-GRATKO','XA-HKPP','XA-IDJASU','XA-INGU','XA-INMUBK','XA-INNDGG','XA-ITMICV','XA-ITRMPA','XA-JPTOAK','XA-KRSESD','XA-LLH','XA-MISFMR','XA-MISFTC','XA-MYKLMM','XA-NLAMVH','XA-PLWAJP','XA-PTLIAL','XA-RUMOKO','XA-SESTBI','XA-SGSITE','XA-STIG','XA-THBGEC','XC-1043','XC-1401','XC-142','XC-1573','XC-1578','XC-1582','XC-1614','XC-416','XC-456','XC-466','XC-486','XC-5190','XC-5191','XC-5193','XC-5194','XC-5195','XC-5196','XC-5197','XC-5198','XC-5199','XC-5200','XC-5778','XC-5780','XC-5781','XC-5784','XC-5785','XC-5788','XC-5791','XC-5799','XC-5800','XC-5801','XC-5803','XC-5806','XC-5808','XC-5809','XC-5811','XC-5812','XC-5816','XC-5832','XC-5834','XC-5835','XC-5838','XC-5841','XC-5842','XC-5847','XC-5848','XC-5849','XC-5850','XC-5854','XC-5858','XC-5859','XC-5865','XC-5866','XC-5867','XC-5868','XC-5869','XC-5871','XC-5872','XC-5873','XC-5874','XC-5875','XC-5876','XC-5877','XC-5885','XC-5886','XC-5892','XC-5894','XC-5899','XC-5901','XC-5902','XC-5904','XC-5906','XC-5907','XC-5908','XC-5909','XC-5910','XC-5911','XC-5912','XC-5913','XC-5914','XC-5915','XC-5916','XC-5917','XC-5918','XC-5919','XC-5920','XC-5921','XC-5922','XC-5925','XC-5931','XC-5933','XC-6218','XC-6228','XC-6230','XC-6232','XC-6256','XC-6451','XC-6470','XC-6471','XC-6472','XC-6479','XC-6555','XC-6603','XC-6665','XC-6666','XC-6667','XC-6668','XC-6669','XC-6670','XC-6671','XC-6672','XC-6673','XC-6674','XC-6675','XC-7284','XC-7484','XC-8001','XC-8074','XC-8109','XC-8263','XC-8302','XC-8331','XC-8423','XC-8460','XC-8461','XC-8462','XC-8463','XC-8464','XC-8465','XC-8467','XC-8468','XC-8469','XC-8470','XC-8471','XC-8481','XC-8492','XC-8499','XC-8500','XC-8564','XC-8576','XC-8638','XC-8639','XC-8640','XC-8645','XC-8650','XC-8702','XC-8703','XC-8704','XC-8735','XC-9','XC-9009','XC-9025','XC-9044','XC-9071','XC-FRLADEF','XC-FRLVMH','XC-GBEDBP','XC-GRDESC','XC-GRPMC','XC-ILJRVR','XC-USAZYU580','XC-USAZYU645','XC-USCAAGC1458','XC-USCABA03','XC-USCABA170','XC-USCACL33','XC-USCAEC','XC-USCANO','XC-USCAPH','XC-USCASD140','XC-USCASD3445','XC-USCASD49274','XC-USCASD7494','XC-USFLMAY448','XC-USFLMIL','XC-USFLPE','XC-USGAKI','XC-USLAAG','XC-USMEBR','XC-USMEKI','XC-USMOKC100','XC-USMOKC616','XC-USMSME224','XC-USMSME225','XC-USMSME266','XC-USMSPA','XC-USMSSTEN','XC-USNCCJ','XC-USNCCP','XC-USNJLK','XC-USPA633','XC-USPADOD','XC-USPAMNS','XC-USSCGC','XC-USSCPI172','XC-USSCPI295','XC-USTXCC10','XC-USTXIN','XC-USVAFCT','XC-USVANOAMP','XC-USVANOLF','XC-USVAPO31','XC-USVAQT','XC-USWABR','XC-USWAOH113','XC-USWAOH2644','XC-USWAOH2700','XC-USWAOH976','XC-USWASI1005','XC-USWASI7074','XE-ALNE3','XE-ATU','XE-AUNSW03','XE-AUNSW09','XE-AUNSW36','XE-AUNSW46','XE-AUSYDC','XE-BRSPTP','XE-CACHB','XE-CACHO','XE-CAONKC','XE-CAONMG','XE-CARCA','XE-CARCP','XE-CARCT','XE-CASFM','XE-CASFRE','XE-CAWINTBD','XE-CHZUTA','XE-CHZUTB','XE-CLST','XE-COBC','XE-CRSJ','XE-DEDS','XE-DEFME','XE-DERE','XE-DESOV','XE-DEWF','XE-DEWM','XE-FLLAN','XE-FRBM','XE-FRBR','XE-FRCCB','XE-FRCL','XE-FRCN','XE-FRCR','XE-FREP','XE-FRES','XE-FRGQ','XE-FRIN','XE-FRLG','XE-FRLH','XE-FRMU','XE-FRMY','XE-FRNN','XE-FRPP','XE-FRPR','XE-FRRN','XE-FRSD','XE-FRSER','XE-FRSLV','XE-FRTB','XE-FRTG','XE-FRTL','XE-FRTN','XE-FRWA','XE-GBIEW','XE-GBLB','XE-GBLFR','XE-GBLLC','XE-GBLPS','XE-GBLSH','XE-GBLT3','XE-GBLV','XE-GBMKB','XE-GBNWTP','XE-GBPL','XE-GBTS','XE-GBWHS','XE-GREX','XE-IAAISU','XE-IAC10','XE-IAU106','XE-INCCR','XE-ITPOCE','XE-ITRPT','XE-NCRA','XE-OKOCE','XE-OKOCM','XE-OKTMR','XE-OKTNC','XE-ORLO5','XE-PANWL','XE-PHMAK','XE-RIOTBD','XE-RIPAK','XE-SDPARKHI','XE-SDPARKPK','XE-SETRD','XE-SGDC','XE-SGTM','XE-TNORML','XE-TXMAIR','XE-UKMKSP','XE-USCAES','XE-USCASJAOPS','XE-USGATP','XE-USIA012','XE-USIAUR','XE-USINCP','XE-USNC050','XE-USNJNWAOPS','XE-USNYRPARK','XE-USTXBRY','XE-USTXELEC','XE-USTXHELI','XE-USTXSYMP','XE-USVAVI','XE-USWABE','XE-USWI033','XE-USWIPK18','XE-USWIPK26','XE-USWIST16','XE-USWIWH29','XE-VAACP','XE-VAFCF','XE-VAHIPC','XE-WIMED','XE-WIMEO','XE-WIMH','XE-ZAAECI','XM-AUS','XM-CNS','XM-DEB','XM-DEH','XM-IED','XM-INA1','XM-INB1','XM-INB10','XM-INB11','XM-INB12','XM-INB13','XM-INB14','XM-INB2','XM-INB3','XM-INB4','XM-INB5','XM-INB6','XM-INB7','XM-INB8','XM-INB9','XM-INM1','XM-INM2','XM-INMG1','XM-INN1','XM-INP1','XM-JAT','XM-MAPL','XM-MXT1','XM-NL1','XM-SN1','XM-UKL','XM-UKS','XM-USAZ1','XM-USCASM','XM-USD1','XM-USNYM','XM-USTNM','XM-USTNT','XM-USTXH','XV-COG','XV-ILDG','XV-NCCH','XV-NJCH','XV-NJTO','XX-TEST','XX-TEST1','XX-TEST20','XX-TEST21','XX-TEST22','XX-TEST23','XX-TEST24','XX-TEST25','XX-TEST26','XX-TEST27','XX-TESTG','ZA-ATAF','ZA-ATAR','ZA-BEAC','ZA-BEEL','ZA-JOCS','ZA-JOFS','ZA-MAHS','ZA-PEKR','ZA-PITO','ZA-RGIM','ZA-RLEO','ZA-ROBR','ZA-RUHS','ZA-SEBR','ZA-SKFS','ZA-SPIM','ZA-SUKR'
0
forrest321Commented:
Hmm....

Villeneuve D'Ascq Cedex

This city contains a single quote.  Try switching that with a tick mark in the database, or use another replace..
tOptionValue = replace(tOptionValue, "'", "")
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
ASP

From novice to tech pro — start learning today.