<%@ Language=JavaScript %> <% Response.ContentType = "text/xml; charset=iso-8859-1"; var connectString = "Driver={Microsoft Access Driver (*.mdb)};DBQ=" + Server.MapPath("/cenaberta/bd/cenaberta.mdb"); // "d:\\projects\\Cena Lusófona\\suporte\\cenaberta2.mdb"; var connCena = Server.CreateObject("ADODB.Connection"); var rsCena = Server.CreateObject("ADODB.RecordSet"); connCena.Open(connectString); rsCena.Open("SELECT TOP 5 titulo, lead, data_hora, id_seccao, id_noticia FROM noticias " + "ORDER BY data_hora DESC",connCena); var isFirst = true; %> Jornal online da Cena Lusófona - Associação Portuguesa para o Intercâmbio Teatral pt (c) Cena Lusófona 2004 http://backend.userland.com/rss News <% while (! rsCena.EOF){ if (isFirst){ isFirst = false; Response.Write("" + rsCena.Fields("data_hora").Value + "\n"); } Response.Write(""); Response.Write(""); Response.Write("" + rsCena.Fields("lead").Value + ""); Response.Write("" + rsCena.Fields("data_hora").Value + "\n"); rsCena.MoveNext(); Response.Write(""); } rsCena.Close(); connCena.Close(); %>