sort by dato
er der nogen der kan vise mig hvor jeg bestemmer hvad mdb filen skal sorteres efter?<body>
<div align="center">
<%
Set Conn = Server.CreateObject("ADODB.Connection")
DBPath = "DBQ=" & server.mappath("db.mdb")
Conn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; " & DBPath
Sql = "SELECT * FROM nyheder"
Set rs = Conn.Execute(Sql)
%><% Do While Not rs.EOF
SQL2 = "select count(*) as antal from kommentarer WHERE nyhedsId = " & rs("id")
Set TheCount = Conn.Execute(Sql2)
antal = TheCount("antal")
%>
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td>
<div align="center">
<font size="1" face="verdana"><%=rs("fuldtid")%></font></div>
</td>
</tr>
</table>
<% rs.MoveNext
Loop
%></div>
</body>
