> Hvad har den gang i ? <
ADODB.Field fejl '80020009'Either BOF or EOF is True, or the current record has been deleted; the operation requested by the application requires a current record.
?
For det første er min DB ikke tom.
Min kode:
<% Response.Buffer = True %>
<%
Set meConn = Server.CreateObject("ADODB.Connection")
meConn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("/nb/sims-world/data/main.mdb")
Set rs1 = Server.CreateObject("ADODB.RecordSet")
strSQL1 = "SELECT Top 10 * FROM Houses ORDER BY Hits DESC"
rs1.Open strSQL1, meConn, 1, 3
%>
<%
Set m1Conn = Server.CreateObject("ADODB.Connection")
m1Conn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("/nb/sims-world/skins/skins.mdb")
Set rs2 = Server.CreateObject("ADODB.RecordSet")
strSQL2 = "SELECT Top 10 * FROM Skins"
rs2.Open strSQL2, m1Conn, 1, 3
%>
<html>
<head>
<base target="_self">
<style>
<!--
A:link {text-decoration: none; color: #FFFFFF}
A:visited {text-decoration: none; color: #FFFFFF}
A:hover {text-decoration: underline; background=#0080C0; color: #FFFFFF}
A:active {text-decoration: none; color: #Fonts (seperate with comma)}
-->
</style>
<title></title>
</head>
<body background="Img/back.jpg" text="#FFFFFF">
<p align="center"><img src="Links/Img/TheSimsWorld.gif" WIDTH="233" HEIGHT="46"></p>
<div align="center"><center>
<table border="0" cellpadding="2" cellspacing="0">
<tr>
<td><small><font face="Verdana">Skins Online:</font></small></td>
<td><font face="Verdana" color="#FF0000"><small><!-- #include Virtual="nb/Sims-World/Skins/Skins.Inc" --></small></font></td>
</tr>
<tr>
<td><small><font face="Verdana">Houses Online:</font></small></td>
<td><font face="Verdana" color="#FF0000"><small><!-- #include Virtual="nb/Sims-World/Houses/Houses.Inc" --></small></font></td>
</tr>
</table>
</center></div><div align="center"><center>
<table border="0" cellpadding="2" cellspacing="0">
<tr>
<td colspan="4"><img src="Img/Top10_DL.gif" WIDTH="224" HEIGHT="39"></td>
</tr>
<tr>
<td colspan="2"><img src="Img/Houses_top.gif" WIDTH="82" HEIGHT="31"></td>
<td colspan="2"><img src="Img/Skins_top.gif" WIDTH="63" HEIGHT="31"></td>
</tr>
<tr>
<td background="Img/baggrnd.jpg"><small><font face="Verdana"><strong>House Name</strong></font></small></td>
<td background="Img/baggrnd.jpg"><small><font face="Verdana"><strong>Hits</strong></font></small></td>
<td background="Img/baggrnd.jpg"><small><font face="Verdana"><strong>Skin Name</strong></font></small></td>
<td background="Img/baggrnd.jpg"><small><font face="Verdana"><strong>Hits</strong></font></small></td>
</tr>
<tr>
<% Do While Not rs1.EOF %>
<% Do While Not rs2.EOF %>
<td><a href="Houses/Get_House.asp?Id=<%=RS1("id")%>"><small><font face="Verdana"><%=RS1("File_Name")%></font></small></a></td>
<td><small><font face="Verdana"><%=RS1("Hits")%> </font></small></td>
<td><a href="Skins/Get_Skin.asp?Id=<%=RS2("id")%>"><small><font face="Verdana"><%=RS2("File_Name")%></font></small></a></td>
<td><small><font face="Verdana"><%=RS2("Hits")%> </font></small></td>
</tr>
<%rs1.Movenext
Loop
%>
<%rs2.Movenext
Loop
%>
<%
meConn.Close
Set meConn = Nothing
m1Conn.Close
Set m1Conn = Nothing
%>
</table>
</center></div>
</body>
</html>
Håber at der er en der kan se den dumme fejl :)
Mvh
<% Wall %>
