<%
strq="select * from events ORDER BY id DESC"
set objrs=server.createobject ("adodb.recordset")
objrs.CursorLocation = aduseclient
objrs.CursorType = adopenstatic
objrs.open strq, conn, , , adcmdtext
'set objrs.activeconnection = conn
'objrs.open strq
id = 1
do while not objrs.eof
%>
|
<%
response.write id
%>
|
<%
e = objrs("subject")
if e <> "" then
enew = replace(e, vbcrlf, " ")
end if
response.write enew
%>
|
| |
<%
e = objrs("detail")
if e <> "" then
enew = replace(e, vbcrlf, " ")
end if
response.write enew
%>
|
<%
objrs.movenext
id = id + 1
loop
%>
|
|