Either BOF or EOF is True....
Arrrgh! jeg får hele tiden den fejlmeddelelse der hedder: Either BOF or EOF is True...bla bla...Men jeg har en "<%if (RS.BOF or RS.EOF) then
response.write("der er ikke nogen poster at vise")
else %>"-sætning på...
Hvad kan det så være?
Min kode er som følger:
<%@ Language=VBSCRIPT %>
<html>
<head>
<title>ErhvervsNettet - Underkategorier</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<STYLE type="text/css">
<!--
A {color: #425A9C; text-decoration: none;}
A:link {color: #425A9C"; text-decoration: bold;}
A:visited {color: #425A9C"; text-decoration: none;}
A:hover {text-decoration: underline; color: #425A9C;}
-->
</STYLE>
</head>
<body bgcolor="#FFFFFF" >
<table width="450" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td colspan="3">
<div align="center"><font face="Arial, Helvetica, sans-serif" size="3"><b><img src="images/erhverv.gif" width="450" height="68"></b></font></div>
</td>
</tr>
</table>
<br>
<table width="450" border="0" cellspacing="0" cellpadding="0" align="center">
<%
Set Conn2 = Server.CreateObject("ADODB.Connection")
Conn2.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath ("\database\soeg.mdb")
SQL2 = "select * from AlfaBeta ORDER BY AlfaNavn"
Set RS2 = Conn2.Execute(SQL2)%>
<tr>
<td>
<div align="center"><font face="Arial, Helvetica, sans-serif" size="1" color="#4A63A5">
<% bogstav = ""
oldBogstav = ""
while not RS2.eof
Navn = RS2("AlfaNavn")
bogstav = LEFT(Navn, 3)
if bogstav <> oldBogstav then%>
<a href="alfa.asp?ID=<%=RS2("AlfaNavn")%>"><%response.write bogstav%></a>,
<% end if
oldBogstav = bogstav
RS2.movenext
WEND %> <%
RS2.Close
Conn2.Close
Set Conn2 = Nothing
%> </font></div>
</td>
</tr>
</table>
<%
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath ("\database\soeg.mdb")
SQL = "select * from Firma, UnderKategori WHERE (UnderKategori.UnderID = "&request("ID")&") AND (UnderKategori.UnderID = Firma.UnderID) ORDER BY FirmaNavn"
Set RS = Conn.Execute(SQL)%>
<br>
<table width="450" border="0" cellspacing="0" cellpadding="0" align="center">
<tr bgcolor="#425A9C">
<td><b><font face="Arial, Helvetica, sans-serif" size="3" color="#FFFFFF"><%=RS("UnderNavn")%></font></b></td>
</tr>
</table>
<%if (RS.BOF or RS.EOF) then
response.write("der er ikke poster")
else %>
<br>
<table width="400" border="0" cellspacing="0" cellpadding="0" align="center">
<%Do until RS.EOF %>
<tr bgcolor="#000099" valign="top">
<td width="180" bgcolor="#FFFFFF"><font face="Arial, Helvetica, sans-serif" size="2"><b><font color="#FFFFFF"><img src="images/dot.gif" width="8" height="8" border="0">
<a href="firma/firma.asp?ID=<%=RS("FirmaID")%>"><%=RS("FirmaNavn")%></a></font></b><br>
</font></td>
<%rs.movenext
loop %><%end if%>
</tr>
</table>
<br>
<table width="450" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td colspan="3">
<div align="center"><font face="Arial, Helvetica, sans-serif" size="3"><b><img src="images/banner.gif" width="450" height="68"></b></font></div>
</td>
</tr>
</table>
<%
RS.Close
Conn.Close
Set Conn = Nothing
%>
</body>
</html>
