---
title: "Numrera 5 poster"
type: "forum-thread"
url: "https://www.webforum.nu/amne/asp/11961-numrera-5-poster"
topic: "ASP"
topic_url: "https://www.webforum.nu/amne/asp"
author: "Nicklas"
published: "2001-10-05T12:55:00.000Z"
updated: "2001-10-05T13:05:00.000Z"
replies: 6
views: 223
page: 1
pages: 1
language: "sv-SE"
site: "webForum — webforum.nu"
rights: "Upphovsrätten till varje inlägg tillhör dess författare."
attribution: "Citera som: webForum, https://www.webforum.nu/amne/asp/11961-numrera-5-poster"
---

# Numrera 5 poster

## #1 — Nicklas, 2001-10-05T12:55Z

Hur gör man för att numrera 5 poster med 1,2,3 osv och när man lägger till en ny post så ska den få 1 och 5:an trilla ur i följande kod ?

```
<!-- #include file="adovbs.inc" -->

<%

		Set Connect = Server.CreateObject("ADODB.Connection")
		Connect.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" & Server.MapPath("link.mdb")
		Set RecSet = Server.CreateObject("ADODB.Recordset")

		Link = "SELECT TOP 5 * FROM tb ORDER BY ID DESC"
		RecSet.Open Link, Connect, adOpenDynamic
		Do Until RecSet.EOF

		Response.Write(RecSet("Namn") & "<BR>")

		RecSet.MoveNext
		Loop

		RecSet.Close
		Connect.Close
		Set RecSet=Nothing
		Set Connect=Nothing
%>
```

Plz help a newbie !

/ Nicklas

Permalänk: https://www.webforum.nu/p/11961

## #2 — Brimba, 2001-10-05T13:01Z

```
<!-- #include file="adovbs.inc" -->

<%
Dim i

Set Connect = Server.CreateObject("ADODB.Connection")
Connect.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" & Server.MapPath("link.mdb")
Set RecSet = Server.CreateObject("ADODB.Recordset")

i = 1
Link = "SELECT TOP 5 * FROM tb ORDER BY ID DESC"
RecSet.Open Link, Connect, adOpenDynamic
Do Until RecSet.EOF

Response.Write(i & " " & RecSet("Namn") & "<BR>")

RecSet.MoveNext
i = i + 1
Loop

RecSet.Close
Connect.Close
Set RecSet=Nothing
Set Connect=Nothing
%>
```

Permalänk: https://www.webforum.nu/p/291333

## #3 — erka, 2001-10-05T13:02Z

```
Cnt = 1

Do Until RecSet.EOF
Response.Write""& Cnt &" & " RecSet("Namn") &"<br>""
RecSet.MoveNext
Cnt = Cnt + 1
Loop
```

Permalänk: https://www.webforum.nu/p/291334

## #4 — erka, 2001-10-05T13:03Z

Darn it, 20 sekunder före :e

Permalänk: https://www.webforum.nu/p/291335

## #5 — Brimba, 2001-10-05T13:04Z

:e

Permalänk: https://www.webforum.nu/p/291336

## #6 — erka, 2001-10-05T13:05Z

Tur att man inte är lika snabb i sängen :e

Permalänk: https://www.webforum.nu/p/291337

## #7 — Nicklas, 2001-10-05T13:05Z

F-n ni e snabba :)

Tack !

Permalänk: https://www.webforum.nu/p/291338

---

Tråden på webben: https://www.webforum.nu/amne/asp/11961-numrera-5-poster