% strConnection ="Driver={Microsoft Access Driver (*.mdb)};DBQ=" & server.MapPath("database/voiceofthecape.mdb") & ";" Set Connn = Server.CreateObject("ADODB.Connection") Connn.Open(strConnection) sqlPalestine = "SELECT TOP 5 * FROM News_Article WHERE EventType = 'PALESTINE' ORDER BY date DESC;" Set rsPalestine = Connn.Execute(sqlPalestine) %>
|