Hi Ralf,
Versuchs mal so:
<% set db=Server.CreateObject("ADODB.Recordset")
db.open "SELECT * FROM tabelle ORDER BY ID", Application("db"), 3, 1
do until db.eof
i = i + 1
if i/2 = fix(i/2) then
strBgColor = "red"
else
strBgColor = "blue"
end if%>
<table bgcolor="<%=strBgColor%>" width="100%" border="0">
<tr>
<td width="2%" ><b><%= db("name") %></b></td>
</tr>
</table>
<% db.movenext
loop
db.Close%>
Gruß
Stefan