Vis kun de fem første poster
Hej, hvad skal jeg kører for at få mit script til kun at vise de sidste fem poster?Script:
<%
Set Conn = Server.CreateObject("ADODB.Connection")
DSN = "DRIVER={Microsoft Access Driver (*.mdb)};"
DSN = DSN & "DBQ=" & Server.MapPath("freeware.mdb")
Conn.Open DSN
strSQL = "SELECT * FROM news ORDER BY newsID DESC"
Set rs = Conn.Execute(strSQL)
Do
strOverskrift = rs("Overskrift") & " " & rs("Dato")
strLink = "<a href='showeditnews.asp?id=" & rs("newsID") & "'>" & strOverskrift & "</a>"
'Skriver liste
Response.Write "<td>" & strLink & "</td>"
Response.Write "<br>"
rs.MoveNext
Loop while not rs.EOF
Conn.Close
Set Conn = Nothing
%>
-----
