en ting jeg ik kan finde ud af!!
Jeg har en default.asp som laver et udtræk af en base det går fint. Problemet er at hver anden record skal være grå..Pt. har jeg lavet det sådannne
%
Set Conn = Server.CreateObject(\"ADODB.Connection\")
Conn.Open \"DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=\" & server.MapPath(\"../../mdb/kalender.mdb\")
SQLstmt = \"SELECT * FROM main ORDER BY date1\"
Conn.Execute (SQLstmt)
Set rs = conn.Execute(SQLstmt)
%>
<center>
<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"4\" align=\"center\">
<tr bgcolor=\"black\">
<td width=\"100%\" colspan=\"7\" align=\"center\"><font face=\"tahoma\" color=\"white\"><b>Kalender.</b></font></td>
</tr>
<tr>
<td width=\"10%\"><b>Fra Dato:</b></td>
<td width=\"10%\"><b>Til Dato:</b></td>
<td width=\"10%\"><b>Tidsrum:</b></td>
<td align=\"Center\"><b>Overskrift:</b></td>
<td width=\"20%\"><b>Hold:</b></td>
</tr>
<tr>
<% DO WHILE NOT rs.EOF
id = rs(\"id\")
title = rs(\"title\")
hold = rs(\"hold\")
date1 = rs(\"date1\")
date2 = rs(\"date2\")
day1 = rs(\"day1\")
day2 = rs(\"day2\")
clock = rs(\"clock\")
%>
<td><%=date1%></td>
<td><%=date2%></td>
<td><%=clock%></td>
<td><a href=\"show_details.asp?id=<%=id%>\" class=\"blacklink\"><%=title%></a></td>
<td><%=hold%></td>
<td align=\"center\"><a href=\"form_change.asp?id=<%=id%>\" class=\"blacklink\">Ret</td>
<td align=\"center\"><a href=\"del_db_entry.asp?id=<%=id%>\" class=\"blacklink\">Slet</td>
</tr>
<%
rs.MoveNext
%>
<tr bgcolor=\"#c0c0c0\">
<td><%=date1%></td>
<td><%=date2%></td>
<td><%=clock%></td>
<td><a href=\"show_details.asp?id=<%=id%>\" class=\"blacklink\"><%=title%></a></td>
<td><%=hold%></td>
<td align=\"center\"><a href=\"form_change.asp?id=<%=id%>\" class=\"blacklink\">Ret</td>
<td align=\"center\"><a href=\"del_db_entry.asp?id=<%=id%>\" class=\"blacklink\">Slet</td>
</tr>
<%
LOOP
RS.Close
conn.Close
Set conn = nothing
Set SQLstmt = nothing
%>
<tr bgcolor=\"black\">
<td colspan=\"8\" align=\"center\"><font face=\"tahoma\" color=\"white\" acolor=\"white\" size=\"1\"><a href=\"form.asp\" class=\"alink\">Ny Kalender Entry</a></a></font></td>
</tr>
</table>
Men den viser alle entrys 2 gange hvorfor det???
