%@ LANGUAGE=VBScript LCID=1033 %> <% '********************************************************* ' @ Directives ' ' LCID ' English - United States '********************************************************* '********************************************************* ' Purpose: ' Security Requirements '********************************************************* Option Explicit Response.ContentType = "application/x" ' For IIS 5.0 and later, the default value is True. Response.Buffer = True '********************************************************* ' If this page generates custom HTML for every request, ' you won't improve performace by setting CacheControl to ' public. The default is Private, which means that only ' private caches may cache this page - proxy servers won't ' cache it. '********************************************************* 'Response.CacheControl = "Public" ' Assure that both expression are numeric, because how ' expressions are compared, depends on their underlying ' subtype. Function CheckRange(Value, Min, Max) CheckRange = True : If (Value < Min) Or (Value > Max) Then CheckRange = False End Function Dim lngContentID Dim dictCountry Dim dictTypeOfBsns On Error Resume Next lngContentID = CLng(Request.QueryString("content_id")) If Err.Number <> 0 Then lngContentID = -1 On Error GoTo 0 '********************************************************* ' The CLng function rounds the fractional part or a ' number. It returns 0 if expression is Empty. '********************************************************* If IsNumeric(lngContentID) = False Then lngContentID = -1 %> <% '********************************************************* ' Don't use the VBScript functions CreateObject and ' GetObject in server-side scripts. Use ' Server.CreateObject instead so that ASP can track the ' object instance. '********************************************************* Set dictCountry = Server.CreateObject("Scripting.Dictionary") ' Sets the comparison mode for comparing string keys in a ' Dictionary object. 'dictCountry = vbBinaryCompare With dictCountry .Add "4", "AFGHANISTAN" .Add "8", "ALBANIA" .Add "12", "ALGERIA" .Add "16", "AMERICAN SAMOA" .Add "20", "ANDORRA" .Add "24", "ANGOLA" .Add "660", "ANGUILLA" .Add "10", "ANTARCTICA" .Add "28", "ANTIGUA AND BARBUDA" .Add "32", "ARGENTINA" .Add "51", "ARMENIA" .Add "533", "ARUBA" .Add "36", "AUSTRALIA" .Add "40", "AUSTRIA" .Add "31", "AZERBAIJAN" .Add "44", "BAHAMAS" .Add "48", "BAHRAIN" .Add "50", "BANGLADESH" .Add "52", "BARBADOS" .Add "112", "BELARUS" .Add "56", "BELGIUM" .Add "84", "BELIZE" .Add "204", "BENIN" .Add "60", "BERMUDA" .Add "64", "BHUTAN" .Add "68", "BOLIVIA" .Add "70", "BOSNIA AND HERZEGOVINA" .Add "72", "BOTSWANA" .Add "74", "BOUVET ISLAND" .Add "76", "BRAZIL" .Add "86", "BRITISH INDIAN OCEAN TERRITORY" .Add "96", "BRUNEI DARUSSALAM" .Add "100", "BULGARIA" .Add "854", "BURKINA FASO" .Add "108", "BURUNDI" .Add "116", "CAMBODIA" .Add "120", "CAMEROON" .Add "124", "CANADA" .Add "132", "CAPE VERDE" .Add "136", "CAYMAN ISLANDS" .Add "140", "CENTRAL AFRICAN REPUBLIC" .Add "148", "CHAD" .Add "152", "CHILE" .Add "156", "CHINA" .Add "162", "CHRISTMAS ISLAND" .Add "166", "COCOS (KEELING) ISLANDS" .Add "170", "COLOMBIA" .Add "174", "COMOROS" .Add "178", "CONGO" .Add "180", "CONGO, THE DEMOCRATIC REPUBLIC OF THE" .Add "184", "COOK ISLANDS" .Add "188", "COSTA RICA" .Add "384", "COTE D'IVOIRE" .Add "191", "CROATIA" .Add "192", "CUBA" .Add "196", "CYPRUS" .Add "203", "CZECH REPUBLIC" .Add "208", "DENMARK" .Add "262", "DJIBOUTI" .Add "212", "DOMINICA" .Add "214", "DOMINICAN REPUBLIC" .Add "626", "EAST TIMOR" .Add "218", "ECUADOR" .Add "818", "EGYPT" .Add "222", "EL SALVADOR" .Add "226", "EQUATORIAL GUINEA" .Add "232", "ERITREA" .Add "233", "ESTONIA" .Add "231", "ETHIOPIA" .Add "238", "FALKLAND ISLANDS (MALVINAS)" .Add "234", "FAROE ISLANDS" .Add "242", "FIJI" .Add "246", "FINLAND" .Add "250", "FRANCE" .Add "249", "FRANCE, METROPOLITAN" .Add "254", "FRENCH GUIANA" .Add "258", "FRENCH POLYNESIA" .Add "260", "FRENCH SOUTHERN TERRITORIES" .Add "266", "GABON" .Add "270", "GAMBIA" .Add "268", "GEORGIA" .Add "276", "GERMANY" .Add "288", "GHANA" .Add "292", "GIBRALTAR" .Add "300", "GREECE" .Add "304", "GREENLAND" .Add "308", "GRENADA" .Add "312", "GUADELOUPE" .Add "316", "GUAM" .Add "320", "GUATEMALA" .Add "324", "GUINEA" .Add "624", "GUINEA-BISSAU" .Add "328", "GUYANA" .Add "332", "HAITI" .Add "334", "HEARD AND MC DONALD ISLANDS" .Add "336", "HOLY SEE (VATICAN CITY STATE)" .Add "340", "HONDURAS" .Add "344", "HONG KONG" .Add "348", "HUNGARY" .Add "352", "ICELAND" .Add "356", "INDIA" .Add "360", "INDONESIA" .Add "364", "IRAN (ISLAMIC REPUBLIC OF)" .Add "368", "IRAQ " .Add "372", "IRELAND" .Add "376", "ISRAEL" .Add "380", "ITALY" .Add "388", "JAMAICA" .Add "392", "JAPAN" .Add "400", "JORDAN" .Add "398", "KAZAKHSTAN" .Add "404", "KENYA" .Add "296", "KIRIBATI" .Add "408", "KOREA, DEMOCRATIC PEOPLE'S REPUBLIC OF" .Add "410", "KOREA, REPUBLIC OF" .Add "414", "KUWAIT" .Add "417", "KYRGYZSTAN" .Add "418", "LAO PEOPLE'S DEMOCRATIC REPUBLIC" .Add "428", "LATVIA" .Add "422", "LEBANON" .Add "426", "LESOTHO" .Add "430", "LIBERIA" .Add "434", "LIBYAN ARAB JAMAHIRIYA" .Add "438", "LIECHTENSTEIN" .Add "440", "LITHUANIA" .Add "442", "LUXEMBOURG" .Add "446", "MACAU" .Add "807", "MACEDONIA, THE FORMER YUGOSLAV REPUBLIC OF" .Add "450", "MADAGASCAR" .Add "454", "MALAWI" .Add "458", "MALAYSIA" .Add "462", "MALDIVES" .Add "466", "MALI" .Add "470", "MALTA" .Add "584", "MARSHALL ISLANDS" .Add "474", "MARTINIQUE" .Add "478", "MAURITANIA" .Add "480", "MAURITIUS" .Add "175", "MAYOTTE" .Add "484", "MEXICO" .Add "583", "MICRONESIA, FEDERATED STATES OF" .Add "498", "MOLDOVA, REPUBLIC OF" .Add "492", "MONACO" .Add "496", "MONGOLIA" .Add "500", "MONTSERRAT" .Add "504", "MOROCCO" .Add "508", "MOZAMBIQUE" .Add "104", "MYANMAR" .Add "516", "NAMIBIA" .Add "520", "NAURU" .Add "524", "NEPAL" .Add "528", "NETHERLANDS" .Add "530", "NETHERLANDS ANTILLES" .Add "540", "NEW CALEDONIA" .Add "554", "NEW ZEALAND" .Add "558", "NICARAGUA" .Add "562", "NIGER" .Add "566", "NIGERIA" .Add "570", "NIUE" .Add "574", "NORFOLK ISLAND" .Add "580", "NORTHERN MARIANA ISLANDS" .Add "578", "NORWAY" .Add "512", "OMAN" .Add "586", "PAKISTAN" .Add "585", "PALAU" .Add "591", "PANAMA" .Add "598", "PAPUA NEW GUINEA" .Add "600", "PARAGUAY" .Add "604", "PERU" .Add "608", "PHILIPPINES" .Add "612", "PITCAIRN" .Add "616", "POLAND" .Add "620", "PORTUGAL" .Add "630", "PUERTO RICO" .Add "634", "QATAR" .Add "638", "REUNION" .Add "642", "ROMANIA" .Add "643", "RUSSIAN FEDERATION" .Add "646", "RWANDA" .Add "659", "SAINT KITTS AND NEVIS" .Add "662", "SAINT LUCIA" .Add "670", "SAINT VINCENT AND THE GRENADINES" .Add "882", "SAMOA" .Add "674", "SAN MARINO" .Add "678", "SAO TOME AND PRINCIPE" .Add "682", "SAUDI ARABIA" .Add "686", "SENEGAL" .Add "690", "SEYCHELLES" .Add "694", "SIERRA LEONE" .Add "702", "SINGAPORE" .Add "703", "SLOVAKIA (Slovak Republic)" .Add "705", "SLOVENIA" .Add "90", "SOLOMON ISLANDS" .Add "706", "SOMALIA" .Add "710", "SOUTH AFRICA" .Add "239", "SOUTH GEORGIA AND THE SOUTH SANDWICH ISLANDS" .Add "724", "SPAIN" .Add "144", "SRI LANKA" .Add "654", "ST. HELENA" .Add "666", "ST. PIERRE AND MIQUELON" .Add "736", "SUDAN" .Add "740", "SURINAME" .Add "744", "SVALBARD AND JAN MAYEN ISLANDS" .Add "748", "SWAZILAND" .Add "752", "SWEDEN" .Add "756", "SWITZERLAND" .Add "760", "SYRIAN ARAB REPUBLIC" .Add "158", "TAIWAN, PROVINCE OF CHINA" .Add "762", "TAJIKISTAN" .Add "834", "TANZANIA, UNITED REPUBLIC OF" .Add "764", "THAILAND" .Add "768", "TOGO" .Add "772", "TOKELAU" .Add "776", "TONGA" .Add "780", "TRINIDAD AND TOBAGO" .Add "788", "TUNISIA" .Add "792", "TURKEY" .Add "795", "TURKMENISTAN" .Add "796", "TURKS AND CAICOS ISLANDS" .Add "798", "TUVALU" .Add "800", "UGANDA" .Add "804", "UKRAINE" .Add "784", "UNITED ARAB EMIRATES" .Add "826", "UNITED KINGDOM" .Add "840", "UNITED STATES" .Add "581", "UNITED STATES MINOR OUTLYING ISLANDS" .Add "858", "URUGUAY" .Add "860", "UZBEKISTAN" .Add "548", "VANUATU" .Add "862", "VENEZUELA" .Add "704", "VIET NAM" .Add "92", "VIRGIN ISLANDS (BRITISH)" .Add "850", "VIRGIN ISLANDS (U.S.)" .Add "876", "WALLIS AND FUTUNA ISLANDS" .Add "732", "WESTERN SAHARA" .Add "887", "YEMEN" .Add "891", "YUGOSLAVIA" .Add "894", "ZAMBIA" .Add "716", "ZIMBABWE" End With Set dictTypeOfBsns = Server.CreateObject("Scripting.Dictionary") With dictTypeOfBsns .Add "1", "Government" .Add "2", "Individual" .Add "3", "Media" .Add "4", "Military" .Add "5", "Non-profit / NGO" .Add "6", "OHR" .Add "7", "Other" .Add "8", "Other international organizations" .Add "9", "Private sector" .Add "10", "Research and academic" .Add "11", "Student" End With %> <% ' ADO Objects Dim conn Dim cmd Dim rs Set conn = Server.CreateObject("ADODB.Connection") '********************************************************* ' By default, CursorLocation property is set to the ' server-side cursor library. '********************************************************* ' This setting doesn't take effect until the next time you ' call BeginTrans method. 'conn.IsolationLevel ' Because we are only going to read data, set the Mode ' property to adModeRead. conn.Mode = adModeReadWrite ' Dynamic properties defined by the underlying data ' provider (SQLOLEDB). 'conn.Properties ' Opens the connection synchronously. conn.Open Application("CONN_STRING") ' Cancels execution of an asynchronous method call (Open ' Method). 'conn.Cancel 'conn.Error '********************************************************* ' Use the Command object to execute the stored procedure. '********************************************************* Set cmd = Server.CreateObject("ADODB.Command") cmd.ActiveConnection = conn '********************************************************* ' p_GetDocument ' ' None of the stored procedure arguments have a default ' value. ' ' doc_header_id ' ' Result Set ' ' doc_header_id ' content_category_id ' author_id ' title ' published ' exp_date ' public ' keywords ' description ' publisher ' language_id ' os_filename ' content ' dir ' dir_desc ' par_desc ' ' For more information, see the description of the columns ' in the modFile2DB.inc script. '********************************************************* cmd.CommandText = "p_ShowVacancy" cmd.CommandType = adCmdStoredProc ' Pass parameter names to the provider. 'cmd.NamedParameters = True '********************************************************* ' Whenever possible, avoid calling the Refresh method of ' the Parameters collection because this causes the client ' to make unnecessary trips to the server to retrieve ' information. '********************************************************* '********************************************************* ' Included in the parameters is the stored procedure's ' return value. '********************************************************* With cmd .Parameters.Append .CreateParameter("@inc_vac_appl_id", adInteger, , , lngContentID) End With ' Handle any run-time errors that the CreateParameter ' method might generate. If Err.Number <> 0 Then ReportError(conn) Set rs = Server.CreateObject("ADODB.Recordset") ' The default value is 1. 'rs.CacheSize = 1 '********************************************************* ' Open Method (ADO Recordset) ' ' CursorType ' The cursor type is set to adOpenKeyset because we ' have a large result set and need to select just one ' row. ' LockType ' The default value is adLockReadOnly. The table data ' can't be altered. ' Options ' Set the Options parameter only if the Source argument ' represents something other than a Command object. '********************************************************* '********************************************************* ' I can't change the CursorType. ' ' For more information, see the following KB article: ' ' Q188857 PRB: Use Open Method to Change CursorType and ' LockType '********************************************************* rs.Open cmd ', , adOpenStatic %>
Office of the High Representative | Employment Application Form |
<% If rs.EOF = False Then Response.Write("" & rs.Fields.Item("PD_NTC_NUMB_SELECT").Value & " | ") End If %><% If rs.EOF = False Then Response.Write(FormatDateTime(rs.Fields.Item("ADD_DATE").Value, vbLongDate)) %> | |
|
|
|
<% ' It also closes any active Recordset objects associated with ' with the connection. If conn.State = adStateOpen Then conn.Close Set rs = Nothing Set cmd = Nothing Set conn = Nothing Set dictTypeOfBsns = Nothing Set dictCountry = Nothing %>