<% connPage = Server.CreateObject("ADODB.Connection"); connPage.Open(Application("ConnectionString")); function PrintDate(TheDate){ var TheDate = new Date(TheDate); return(String(TheDate.getDate()+"/"+(parseInt(TheDate.getMonth()+1)<10?"0"+(TheDate.getMonth()+1):(TheDate.getMonth()+1))+"/"+TheDate.getFullYear())); } rs = Server.CreateObject("ADODB.Recordset"); rs.Open("SELECT * FROM News WHERE (language_id = 1) AND (website_scoop4steel = 1) ORDER BY dateofnews DESC;",connPage,3,1); %>
<% if (!rs.EOF) for (rs.MoveFirst();!rs.EOF;rs.MoveNext()){ Response.Write("

"+PrintDate(rs("dateofnews"))+" - "+rs("title")+"

"); Response.Write("

"+(rs("longdescription")>""?rs("longdescription"):"")+"

"); if (rs("link")>""){ Response.Write(""); } rsFiles = Server.CreateObject("ADODB.Recordset"); rsFiles.Open("SELECT id, description, [file] FROM News_Files WHERE (news_id = "+rs("id")+");",connPage,3,1); if (!rsFiles.EOF){ Response.Write(""); } rsFiles.Close(); rsFiles = null; } %>
<% rs.Close(); rs = null; connPage.Close(); connPage = null; %>

1/08/2011 - Testimonial of Companhia Siderúrgica Nacional, Brazil
"There are multiple advantages from the integrated model of SCOOP and they can be illustrated by many examples", says Mr. Sidiney NASCIMENTO SILVA, Manager of metallurgy processes. "SCOOP is used daily within CSN".

More