<%@LANGUAGE="VBSCRIPT"%>
<%if Request.Cookies("omg")("blnIsUserGood") <> "true" then
response.Redirect("index.html")
end if
%>
<%
Set objFSO = CreateObject("Scripting.FileSystemObject")
intCountry = request.querystring("country")
if intCountry = "" or isNull("intCountry") = true then
intCountry = 0
end if
%>
OMG: Outdoor Media Group
View our locations by country:
<%Set rsRec = Server.CreateObject("ADODB.Recordset")
strSQL = "Select Distinct(oml.country) FROM oml"
strSQL = "SELECT * FROM country WHERE country.ID IN (" & strSQL & ") Order By country.Description"
rsRec.Open strSQL, adoConn, adOpenDynamic , adLockOptimistic
if not rsRec.eof and not rsRec.bof Then
rsRec.movefirst
do while not rsRec.eof
ppath = "countries/" & rsRec("img")%>
