<% theURL = Request.ServerVariables("PATH_INFO") frenchURL = "francais" & theURL myBanner="" myFlash="banner_home.swf" %> Maxxam Analytics Inc ;MM_openBrWindow('/pop.htm','pop','width=600,height=500')<%end if%>">
     

<% 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 %>

<% rs.MoveNext%> <%Loop%>

<%If rs("Date") > (DateAdd("m", -3, Now)) then %> <%else%> <%end if%> <%=rs("title")%>

 

<%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("title")%>
<% rs.MoveNext%> <%Loop rs.close conn.close set conn = nothing set rs = nothing%>

<%end if%>