Tæl hvor mange rs'er der i en tabel

SELECT count(feltnavn) FROM tabelnavn

Giver antallet af rækker i tabellen.

<%
Set Conn = Server.CreateObject("ADODB.Connection")
DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; "
DSN = DSN & "DBQ=" & Server.MapPath("/znuggle/candle/db.mdb")
Conn.Open DSN

strSQL = "Select count(id) From Candles"
count = Conn.Execute(strSQL)
%>
<p align="center"><%=count%> candles have been lit.</p>
<%
Conn.Close
Set Conn = Nothing
%>

Kan ikke helt få det til at virke...

Fejlen er:


Response object error 'ASP 0185 : 8002000e'

Missing Default Property

/znuggle/candle/index.asp, line 0

A default property was not found for the object.

Hvad har jeg gjort galt?

Kan det være

strSQL = "Select count(id) as Antal From Candles" ?

strSQL = "Select count(*) as Antal From Candles"
set rs = Conn.Execute(strSQL)

Response.Write("Antal: " & rs("Antal"))

<%
Set Conn = Server.CreateObject("ADODB.Connection")
DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; "
DSN = DSN & "DBQ=" & Server.MapPath("/znuggle/candle/db.mdb")
Conn.Open DSN

strSQL = "Select count(*) as NoOfCandles From Candles"
set rs = Conn.Execute(strSQL)
NoOfCandles = rs("NoOfCandles") %>
<p align="center"><% =NoOfCandles %> candles have been lit.</p>
<%
Conn.Close
Set Conn = Nothing %>

Jaah det virker :)

Danke...

PS: Check www.candles-for-mia.tk

Jeg synes at du skal finde et pænere starinlys, og så burde du placere lysene ved siden af hinanden - f.eks. 5 i hver række.