---
title: "antal poster"
type: "forum-thread"
url: "https://www.webforum.nu/amne/asp/45930-antal-poster"
topic: "ASP"
topic_url: "https://www.webforum.nu/amne/asp"
author: "fatcap"
published: "2002-06-14T19:42:29.000Z"
updated: "2002-06-15T11:11:01.000Z"
replies: 5
views: 305
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/45930-antal-poster"
---

# antal poster

## #1 — fatcap, 2002-06-14T19:42Z

Hur gör jag en räknare som visar hur många poster det finns i en databas ???

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

## #2 — sin_adec, 2002-06-14T20:08Z

Så här..

```
<% Set db = Server.CreateObject("ADODB.Connection")
db.Open "Driver={Microsoft Access Driver (*.mdb)}; DBQ="& Server.MapPath("exempel.mdb")&";"
 
SQL = "SELECT Count(*) From exempel"
Set rs = db.Execute(SQL)
%>
<%=RS.Fields(0) %> poster i databasen
```

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

## #3 — pirro, 2002-06-14T21:20Z

\<%SQL = "SELECT \* FROM exempel"
set rs = db.Execute(SQL)%\>
\<%=rs.RecordCount%\> poster i db...

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

## #4 — cyprys, 2002-06-14T22:30Z

\<%
set rs = db.Execute("SELECT \* FROM exempel") 
response.write rs.RecordCount & " poster i db..."
%\>
:) :) :e :e

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

## #5 — cyprys, 2002-06-14T22:33Z

\<% 
response.write db.Execute("SELECT \* FROM exempel").RecordCount & " poster i db..." 
%\> 
 :e

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

## #6 — kristoffer, 2002-06-15T11:11Z

En gång till!

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

---

Tråden på webben: https://www.webforum.nu/amne/asp/45930-antal-poster