Solved

My cool script in my asp is having problems

Posted on 2007-03-28
13
1,441 Views
Last Modified: 2008-01-09
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>
0
Comment
Question by:pinkstonm
  • 6
  • 4
  • 3
13 Comments
 
LVL 16

Expert Comment

by:ThinkPaper
ID: 18811513
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
 

Author Comment

by:pinkstonm
ID: 18811519
<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
 
LVL 16

Expert Comment

by:ThinkPaper
ID: 18811629
>> 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
 
LVL 16

Expert Comment

by:ThinkPaper
ID: 18811661
=O  lots of code to work with. exactly what error do you get?
0
 
LVL 2

Expert Comment

by:forrest321
ID: 18811752
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
 

Author Comment

by:pinkstonm
ID: 18811756
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
6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

 

Author Comment

by:pinkstonm
ID: 18811795
The Where is eliminating and records that have a BLANK or NULL value in that field.
0
 
LVL 2

Expert Comment

by:forrest321
ID: 18811875
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
 

Author Comment

by:pinkstonm
ID: 18811910
thats the problem it is not returning anything for any if I uncomment.
0
 
LVL 2

Expert Comment

by:forrest321
ID: 18812022
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
 

Author Comment

by:pinkstonm
ID: 18812348
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
 

Author Comment

by:pinkstonm
ID: 18812374
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
 
LVL 2

Accepted Solution

by:
forrest321 earned 125 total points
ID: 18812530
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

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

I recently decide that I needed a way to make my pages scream on the net.   While searching around how I can accomplish this I stumbled across a great article that stated "minimize the server requests." I got to thinking, hey, I use more than one…
Have you ever needed to get an ASP script to wait for a while? I have, just to let something else happen. Or in my case, to allow other stuff to happen while I was murdering my MySQL database with an update. The Original Issue This was written…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now