%
order = "CommentTime"
timeoffset = 6 'add 6 hours to eastern time to get local time
if UCase(Request.querystring("sort"))="DESC" then order = order & " DESC"
select case UCASE(request.querystring("mode"))
case "SUB"
t = "ICANN-Berlin Real-Time Comments as of " & Dateadd("h", timeoffset, Now())
thtml = "ICANN-Berlin Substantive Real-Time Comments as of " & Dateadd("h", timeoffset, Now())
crit = "Substantive=Yes AND Show=Yes AND boolPublic=Yes"
case "NEWSUB"
t = "ICANN-Berlin Unread Real-Time Comments as of " & Dateadd("h", timeoffset, Now())
thtml = "ICANN-Berlin Unread Substantive Real-Time Comments as of " & Dateadd("h", timeoffset, Now())
crit = "Substantive=Yes AND Show=Yes AND boolPublic=Yes AND boolRead=No"
case "NONSUB"
t = "Additional ICANN-Berlin Real-Time Comments as of " & Dateadd("h", timeoffset, Now())
thtml = "Additional ICANN-Berlin Real-Time Comments as of " & Dateadd("h", timeoffset, Now())
crit = "Substantive=No AND Show=yes AND boolPublic=Yes"
case "INT"
t = "Internal ICANN-Berlin Real-Time Comments as of " & Dateadd("h", timeoffset, Now())
thtml = "Internal ICANN-Berlin Real-Time Comments as of " & Dateadd("h", timeoffset, Now())
crit = "boolPublic=No AND Show=yes AND boolRead=No"
case ""
t = "ICANN-Berlin Real-Time Comments"
thtml = "ICANN-Berlin Real-Time Comments"
crit = "TRUE"
end select
if request.querystring("commentid") <> "" then
crit = crit & " AND (False"
for each cid in split(request.querystring("commentid"),",")
crit = crit & " OR CommentID=" & cid
next
crit = crit & ")"
t = "Real-Time Comments"
thtml = t
' if request.querystring("c") <> "" then t = t & " of " & request.querystring("c") 'company name
' thtml = "Real-Time Comment from " & request.querystring("f") & "
" & request.querystring("c")
end if
select case UCASE(request.querystring("location"))
case "REMOTE"
crit = crit & " AND boolRemote=yes"
case "INROOM"
crit = crit & " AND boolRemote=no"
case else
end select
if request.querystring("day")<>"" then
crit = crit & " AND commenttime > #" & request.querystring("day") & "# AND commenttime < #" & dateadd("d",1,request.querystring("day")) & "#"
end if
%>
| "
if UCase(request.querystring("i"))="I" then
response.write "*"
end if
' if request.querystring("commentid") = "" then
response.write rs("Firstname") & " " & rs("Lastname") & " " & rs("Company") & " " ' end if response.write "" & RS("Subject") & " (" & Dateadd("h", timeoffset, RS("CommentTime")) & ", #" & RS("CommentID") & ")" if rs("BoolRead")=True then response.write " (Message has been read to the assembled group)" if (rs("boolRemote")=False) then response.write " (in-room)" response.write " " response.write replace(rs("Message"),chr(13)," ") response.write " |
All times are Berlin (GMT +1)
This file is automatically generated.