Databaseudtræk - hvordan kommer jeg videre??
Jeg har lavet nedenstående side og det virker fint med et lige antal poster i tabellen - men kommer med en fejl ved ulige antal poster! Jeg forstår godt hvorfor (RS.Movenext), men hvordan undgår jeg problemet??<!-- #include file=\"lbw.inc\" -->
<html>
<head>
<meta http-equiv=\"Content-Language\" content=\"da\">
<meta http-equiv=\"Content-Type\" content=\"text/html; charset=windows-1252\">
<meta name=\"GENERATOR\" content=\"Microsoft FrontPage 3.0\">
<meta name=\"ProgId\" content=\"FrontPage.Editor.Document\">
<title><% =scriptnavn%></title>
<style type=\"text/css\">
<!--
a:active {text-decoration: none}
a:link {text-decoration: none}
a:visited {text-decoration: none}
-->
</style>
</head>
<body bgcolor=\"<% =Body%>\" text=\"<% =Text%>\" link=\"<% =Text%>\" vlink=\"<% =Text%>\"
alink=\"<% =Text%>\" leftmargin=\"75\">
<script language=\"JavaScript1.2\">
if (document.all)
document.body.style.cssText=\"background:<% =Body%> url(back2.gif) no-repeat fixed center center\"
</script>
<%
set conn=server.createobject(\"adodb.connection\")
conn.open StrConnect
strSQL = \"Select * From links \"
Set RS = Conn.Execute(strSQL)
%>
<p><font face=\"Comic Sans MS\"><big>Links:</big></font> </p>
<small><font face=\"Arial\">
<table border=\"0\" width=\"450\">
<%
DO WHILE NOT rs.EOF
%>
</font></small>
<tr>
<td width=\"150\" valign=\"top\" align=\"center\"><font size=\"2\" face=\"Comic Sans MS\"><a
href=\"http://<% =rs(\"WWW\")%>\" target=\"_blank\"><% =rs(\"Beskrivelse\") %></a></font></td>
<small><font face=\"Arial\"><% rs.movenext %>
</font></small><td width=\"150\" valign=\"top\" align=\"center\"><font
size=\"2\" face=\"Comic Sans MS\"><a href=\"http://<% =rs(\"WWW\")%>\" target=\"_blank\"><% =rs(\"Beskrivelse\") %></a></font></td>
<small><font face=\"Arial\"><% rs.movenext %>
</font></small><td width=\"150\" valign=\"top\" align=\"center\"><font
size=\"2\" face=\"Comic Sans MS\"><a href=\"http://<% =rs(\"WWW\")%>\" target=\"_blank\"><% =rs(\"Beskrivelse\") %></a></font></td>
<font face=\"Arial\"><small><% rs.movenext %>
</tr>
<tr>
<td width=\"150\" height=\"10\" valign=\"top\" align=\"center\"></td>
<td width=\"150\" height=\"10\" valign=\"top\" align=\"center\"></td>
<td width=\"150\" height=\"10\" valign=\"top\" align=\"center\"></td>
</tr>
<% LOOP %>
</table>
</small><%
Conn.Close
Set Conn = Nothing
%>
</font>
<p> </p>
</body>
</html>
