<%
'##### 選んだ地域別のタイトル画像を書き出す。 #####
Select Case regionCode
'Oseania
Case "1"
Response.Write("
" & vbNewLine)
'Middle East
Case "2"
Response.Write("
" & vbNewLine)
'Africa
Case "3"
Response.Write("
" & vbNewLine)
'CIS
Case "4"
Response.Write("
" & vbNewLine)
'Asia
Case "5"
Response.Write("
" & vbNewLine)
'Europe
Case "6"
Response.Write("
" & vbNewLine)
End Select
%>
" & vbNewLine)
Response.Write("
" & vbNewLine)
Response.Write(" " & vbNewLine)
Response.Write("
" & vbNewLine)
Response.Write(" " & vbNewLine)
'##### 選んだ地域別のタイトル画像を書き出す。 #####
Select Case regionCode
'Oseania
Case "1"
Response.Write("
" & vbNewLine)
'Middle East
Case "2"
Response.Write("
" & vbNewLine)
'Africa
Case "3"
Response.Write("
" & vbNewLine)
'CIS
Case "4"
Response.Write("
" & vbNewLine)
'Asia
Case "5"
Response.Write("
" & vbNewLine)
'Europe
Case "6"
Response.Write("
" & vbNewLine)
End Select
Response.Write("
" & vbNewLine)
Response.Write(" " & vbNewLine)
IF (objRs.RecordCount = 0) Then
Response.Write("NO DATA")
Else
'##### 国名や代理店情報を書き出す #####
Dim t
t = 1
Do Until objRs.EOF
Response.Write("
" & vbNewLine)
Response.Write("
" & vbNewLine)
Response.Write(" " & vbNewLine)
Response.Write("
" & vbNewLine)
Response.Write("
" & vbNewLine) t = t + 1 objRs.MoveNext Loop objRs.MoveFirst End IF Response.Write("
" & vbNewLine)
Response.Write("
" & objRs("Country").value & "
" & vbNewLine)
Response.Write("
" & objRs("Company name").value & "
" & vbNewLine)
Response.Write(" | " & vbNewLine) Response.Write(" | Address | " & vbNewLine) Response.Write("" & objRs("Address").value & " | " & vbNewLine) Response.Write("
| " & vbNewLine) Response.Write(" | Phone | " & vbNewLine) Response.Write("" & objRs("Phone").value & " | " & vbNewLine) Response.Write("
| " & vbNewLine) Response.Write(" | Fax | " & vbNewLine) Response.Write("" & objRs("FAX").value & " | " & vbNewLine) Response.Write("
| " & vbNewLine) Response.Write(" | " & objRs("E-mail").value & " | " & vbNewLine) Response.Write("|
| " & vbNewLine) Response.Write(" | URL | " & vbNewLine) Response.Write("" & objRs("URL").value & " | " & vbNewLine) Response.Write("
" & vbNewLine) t = t + 1 objRs.MoveNext Loop objRs.MoveFirst End IF Response.Write("
" & vbNewLine)
Response.Write(" " & vbNewLine)
Response.Write("
" & vbNewLine)
Response.Write("
" & vbNewLine)
'##### レコードセットのクローズ #####
objRs.Close
Set objRs = Nothing
'##### コネクションのクローズ #####
objCon.Close
Set objCon = Nothing
%>
