Hvorfor virker siden ikke? Er der problem fra forrige side eller?
jeg få denne fejl i koden:Error Type:
ADODB.Recordset (0x800A0CC1)
Item cannot be found in the collection corresponding to the requested name or ordinal.
/skiper/wwwroot/se_karakter.asp, line 28
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open "c:/Inetpub/wwwroot/data/karakter.mdb"
set rs=Server.CreateObject("ADODB.recordset")
rs.Open "SELECT * FROM ELEVER, HLEL, HOLD WHERE ELEVER.ElevId=HLEL.ElevId AND HLEL.HoldId=HOLD.HoldId AND HOLD.HoldId=" & Request.QueryString("HoldId"), conn
%>
<table border="0" width="667" cellspacing="5">
<tr>
<td width="33%" bgcolor="ffffcc"><div align="center" class="overskrift1">
<div align="left">Vis karakter for hele klassen</div>
</div></td>
</tr>
<tr>
<td width="33%">
<div align="left"><a href="indskriv_karakter4-6.asp?ElevId=<%= rs("ELEVER.ElevId")%>">
<%Response.Write(rs("ELEVER.Fornavn") & " " & rs <--- Line 28("ELEVER.Efternavn"))%> <---------------------------- Line 28
</a> </div></td>
</tr>
<tr>
<td width="33%" bgcolor="ffffcc"><div align="center" class="overskrift1">
<div align="left">Vis Karakter for en elev</div>
</div></td>
</tr>
<%do until rs.EOF%>
<%
intBg = 0
if bg mod 2 = 0 then
bgcolor = "bgcolor=#fffffc"
else
bgcolor = "bgcolor=#ffffcc"
end if
%>
<tr <%Response.Write(bgcolor)%>>
<%
bg = bg + 1
%>
<td width="33%">
<div align="left"><a href="indskriv_karakter4-6.asp?ElevId=<%= rs("ELEVER.ElevId")%>">
<%Response.Write(rs("ELEVER.Fornavn") & " " & rs("ELEVER.Efternavn"))%>
</a> </div></td>
</tr>
<%
rs.MoveNext
%>
<%
loop
rs.close
conn.close%>
HVORFOR?
