jeg skal tælle antal indlæg som... men det virker ikke :-/
jeg har følgende kode<html>
<head>
<META HTTP-EQUIV="Pragma" CONTENT="no-cache">
<title>Forums</title>
<link rel="stylesheet" type="text/css" href="">
</head>
<body>
<table align="center" width="100%">
<tr>
<td id="toptext" align="center"></td>
</tr>
</table>
<br>
<p align="center"> </p>
<%
Farve = 1
Set myConn = Server.CreateObject("ADODB.Connection")
myConn.Open "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("Forum.mdb")
%>
<%
strSQL = "SELECT * FROM Forums ORDER BY ForumID"
Set forums = myConn.Execute(strSQL)
%>
<table border=0 cellspacing=0 width=50% align=CENTER style="BORDER-BOTTOM: #222222 1px solid; BORDER-LEFT: #222222 1px solid; BORDER-RIGHT: #222222 1px solid; BORDER-TOP: #222222 1px solid">
<tr>
<td width=35% valign=TOP style="BORDER-BOTTOM: #222222 1px solid;BORDER-RIGHT: #222222 1px solid"><b>Forum</b></td>
<td valign=TOP style="BORDER-BOTTOM: #222222 1px solid"><b>Beskrivelse</b></td>
<td valign=TOP style="BORDER-BOTTOM: #222222 1px solid"><b>Indlæg</b></td>
<% DO UNTIL Forums.EOF
If farve=1 Then
baggrund="#999966"
Farve= Farve + 1
Else
baggrund="#999966"
farve=1
End If
%>
<tr>
<td id="entry4" bgcolor=<%=Baggrund%> style="BORDER-RIGHT: #222222 1px solid;"><a href=show_data.asp?ForumID=<%=Forums("ForumID")%>><br><%=Forums("Navn")%> </a></td>
<td id="entry4" bgcolor=<%=Baggrund%>><br><%=Forums("Beskrivelse")%> </td>
<td id="entry4" bgcolor=<%=Baggrund%>>
<%
Sql = "Select count(*) as Found from Messages where ForumID = '"& Forums("ForumID") &"'"
Set Record = Rs.Execute(Sql)
antal = Record("found")
%>
<b> <% =antal %></td>
<%Forums.MoveNext
LOOP %>
</table>
</body>
</html>
