<% 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 %> <% = t %> <% Param = Request.QueryString("Param") Data = Request.QueryString("Data") %> <% If IsObject(Session("\\140.247.216.106\inetpub\dbs\ICANN_RCS.mdb_conn")) Then Set conn = Session("\\140.247.216.106\inetpub\dbs\ICANN_RCS.mdb_conn") Else Set conn = Server.CreateObject("ADODB.Connection") conn.open "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=\\140.247.216.106\inetpub\dbs\ICANN-realtime.mdb","","" Set Session("\\140.247.216.106\inetpub\dbs\ICANN-realtime.mdb_conn") = conn End If %> <% sql = "SELECT * FROM [tComments]" sql = sql & " WHERE EventID=1 " If cstr(Param) <> "" And cstr(Data) <> "" Then sql = sql & " AND [" & cstr(Param) & "] = " & cstr(Data) End If sql= sql & " AND " & crit & " ORDER BY " & order 'response.write sql Set rs = Server.CreateObject("ADODB.Recordset") rs.Open sql, conn, 3, 3 %>
<% =thtml %>

<% On Error Resume Next rs.MoveFirst do while Not rs.eof response.write "" rs.MoveNext loop%>
" 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 "


<% response.write "(" & rs.recordcount & " messages total)
" %>

All times are Berlin (GMT +1)

This file is automatically generated.