<% set conn=Server.CreateObject("ADODB.Connection") conn.Open Application("DBConn_Connectionstring") session.codepage=1252 Set rsnews=Server.CreateObject("ADODB.RecordSet") sql="SELECT top 10 * from tblNews where codelanguage=3 and active=1 and codeclass=432 order by ondate desc, ontime desc" rsnews.open sql,conn %>

News & Events <% while not rsnews.eof %> <% rsnews.movenext wend %> News Event ·  Date :  <%= rsnews("ondate")%>  <%= rsnews("long_desc")%> ·  Reference :   <%= rsnews("reference")%> ·  Text :   <%= rsnews("title")%>