|
|
<%
set conn = server.createObject("ADODB.connection")
set rs = server.createObject("ADODB.recordSet")
conn.open application("conn")
rs.open "SELECT * FROM dbo.maxnews WHERE dbo.maxnews.archive = 0 AND dbo.maxnews.language = 'english' ORDER BY dbo.maxnews.date DESC", conn
If NOT rs.EOF then%>
Latest News
<%Do While NOT rs.EOF %>
<%If rs("Date") > (DateAdd("m", -3, Now)) then %>
<%else%>
<%end if%> |
<%=rs("title")%>
|
<% rs.MoveNext%>
<%Loop%>
<%end if
set rs = server.createObject("ADODB.recordSet")
rs.open "SELECT * FROM dbo.maxevents WHERE dbo.maxevents.language = 'english' ORDER BY dbo.maxevents.date DESC", conn
If NOT rs.EOF then%>
Upcoming Events
<%Do While NOT rs.EOF %>
<% rs.MoveNext%>
<%Loop
rs.close
conn.close
set conn = nothing
set rs = nothing%>
|
<%end if%>
|