Tæl antal af poster

Response.Write RS.RecordCount

et eksempel:

SET rs = Server.CreateObject(\"ADODB.Connection\")
rs.Open \"Driver={Microsoft Access Driver (*.mdb)}; DBQ=\" & Server.MapPath(\"xxx.mdb\")
Sql = \"Select count(*) as found FROM besked_indbakke\"
set rs = rs.Execute(SQL)   
found = rs(\"found\")
    Response.Write \"\" & found & \"\" 
RS.Close
set RS = nothing 

Fint nok, men jeg skal ikke tælle alle poster kun de der høre til det rigtige forum.

<%
SET rs = Server.CreateObject(\"ADODB.Connection\")
rs.Open \"Driver={Microsoft Access Driver (*.mdb)}; DBQ=\" & Server.MapPath(\"databasen.mdb\")
Sql = \"Select count(*) as found FROM Tabel where kolonne\"
set rs = rs.Execute(SQL)   
found = rs(\"found\")
    Response.Write \"<span> \" & found & \"</span>\" 
RS.Close
set RS = nothing %>

  et eksempel:

SET rs = Server.CreateObject(\"ADODB.Connection\")
rs.Open \"Driver={Microsoft Access Driver (*.mdb)}; DBQ=\" & Server.MapPath(\"xxx.mdb\")
Sql = \"Select count(*) as found FROM besked_indbakke where forum=det_rigtige\"
set rs = rs.Execute(SQL)   
found = rs(\"found\")
    Response.Write \"\" & found & \"\" 
RS.Close
set RS = nothing 

no_doubt > du har glemt noget i din sql sætning :-)
-Per

Hvilket ?

where kolonne = et_eller_andet

Lukker

hvad???

hvad er det du ikke kan få til at virke?