Antal Entries

select count(id) from publicserver

hele koden tak...

Set DBConn = Server.CreateObject(\"ADODB.Connection\")
DBConn.Open \"DRIVER={Microsoft Access Driver (*.mdb)};DBQ=\" & Server.MapPath(\"settings.mdb\")

sqlString=\"select count(id) as antal from publicserver\"
Set RS = DBConn.Execute(sqlString)

response.write \"Antal poster: \" & rs(\"antal\")

Databasen skal her ligge i samme mappe. Jeg går ud fra at det er en access db

og at der er et id-felt

takker