Hmm hva gør jeg galt
Hej jeg har en gæstebog... men når jeg vil åbne den kommer der denne fejl:Microsoft VBScript runtime error '800a01a8'
Object required: ''
/GB/viewguest.asp, line 57
Her er hele koden:
<html>
<head>
<title>Iceo</title>
<LINK href="../scoll1.css" type=text/css rel=stylesheet>
</head>
<BODY TOPMARGIN="0" LEFTMARGIN="0" BGCOLOR="#003355" TEXT="#FFFFFF" style="font-size: 8 pt; font-family: Verdana; margin-left:20" link="#FFFFFF">
<center>
<p style="margin-top: 0; margin-bottom: 0">
<img border="0" src="../images/logotop.jpg" width="707" height="137"></p>
<p style="margin-top: 0; margin-bottom: 0">
</p>
<table width="716" border="0" cellspacing="0" cellpadding="0" height="1" style="border-collapse: collapse"><tr>
<td width="140" valign=top style="font-size: 8 pt; font-family: Verdana" height="1" background="images/menu-back1.jpg">
<div style="width: 130; height: 10; border: 1px solid #003355; padding-left: 4; padding-right: 4; padding-top: 1; padding-bottom: 1; background-color: #FFFFFF; background-image: url('../images/menu.jpg')">
<p style="margin-top: 0; margin-bottom: 0" align="center">
<font color="#000000"><b>Menu</b></font></p>
</div>
<div style="width: 130; height: 86; background-image: url('../images/menu%20back.jpg')">
<p style="margin-top: 0; margin-bottom: 0" align="center"> <a href="me.html">ME</a></p>
<p style="margin-top: 0; margin-bottom: 0" align="center"> </p>
<p style="margin-top: 0; margin-bottom: 0" align="center">
<a href="download.html">Download</a></p>
<p style="margin-top: 0; margin-bottom: 0" align="center"> </p>
<p style="margin-top: 0; margin-bottom: 0" align="center"> <a href="hp.html">HP'en</a></p>
<p style="margin-top: 0; margin-bottom: 0" align="center">
</p>
<p style="margin-top: 0; margin-bottom: 0" align="center">
GB!</p>
</div>
<p style="margin-top: 0; margin-bottom: 0" align="center"> </p>
<p style="margin-top: 0; margin-bottom: 0" align="center">
<p style="margin-top: 0; margin-bottom: 0" align="center"></div>
<td width="443" valign=top height="1" bgcolor="#003355">
<p style="margin-top: 0; margin-bottom: 0" align="center">
</p>
<table width="443" height="7" border="0" cellpadding="0" cellspacing="0">
<tr valign="top">
<td height="7">
<div style="width: 430; height: 18; border: 1px solid #000000; padding-left: 4; padding-right: 4; padding-top: 1; padding-bottom: 1; background-image: url('../images/menubig.jpg')">
<p align="center"><b><font size="1"> Dem der har skrevet i min GB!
<a href="guestbook.asp"> Skriv i GB'en</a></font></b></div>
</td>
</tr>
</table> <p style="margin-top: 0; margin-bottom: 0" align="center">
</p>
<p style="margin-top: 0; margin-bottom: 0" align="left">
<%
SQL = "select * from guestbook order by created desc"
set guestbook = conn.execute( SQL )
if guestbook.eof then
Response.Write "Gæstebogen er tom !"
Else
Response.Write "<br><br>"
do while not guestbook.eof
Response.Write "<b>Navn :</b> " & guestbook("guest_name") & "<br>"
Response.Write "<b>E-mail :</b> " & guestbook("email") & "<br>"
Response.Write "<b>Kommentar :</b> " & guestbook("comments") & "<br>"
Response.Write "<br><b>Indtastet :</b> " & guestbook("created") & "<br>"
Response.Write "<br><hr>"
guestbook.movenext
loop
Response.Write "</table>"
End If
Response.Write "<br><br>Klik <a href='default.asp'>her</a> for at komme tilbage!"
' Jesper Lund - jesper@netcoders.dk
%>
</p>
</td>
<td width="133" valign=top height="1" background="images/menu-back1.jpg">
<div style="width: 130; height: 10; border: 1px solid #003355; padding-left: 4; padding-right: 4; padding-top: 1; padding-bottom: 1; background-color: #FFFFFF; background-image: url('../images/menu.jpg')">
<p style="margin-top: 0; margin-bottom: 0" align="center">
<font color="#000000"><span style="font-size: 8pt"><b>Links</b></span></font></p>
</div>
<div style="width: 130; height: 91; background-image: url('../images/menu%20back.jpg')">
<p style="margin-top: 0; margin-bottom: 0" align="center">
<span style="font-size: 8pt"><a target="_blank" href="http://www.reschat.dk">
Reschat.dk</a></span></p>
<p style="margin-top: 0; margin-bottom: 0" align="center">
<span style="font-size: 8pt"><a target="_blank" href="http://www.newz.dk">
Newz.dk</a></span></p>
<p style="margin-top: 0; margin-bottom: 0" align="center">
<span style="font-size: 8pt">
<a target="_blank" href="http://www.eksperten.dk">Eksperten.dk</a></span></p>
<p style="margin-top: 0; margin-bottom: 0" align="center">
<span style="font-size: 8pt">
<a target="_blank" href="http://www.serverguider.dk">Serverguider.dk</a></span></p>
<p style="margin-top: 0; margin-bottom: 0" align="center">
<span style="font-size: 8pt"><a target="_blank" href="http://www.dummies.com">
Dummies.com</a></span></p>
<p style="margin-top: 0; margin-bottom: 0" align="center">
<span style="font-size: 8pt">
<a target="_blank" href="http://www.microsof.com">Micosof.com</a></span></p>
</div>
<p style="margin-top: 0; margin-bottom: 0" align="center"> </p>
<p style="margin-top: 0; margin-bottom: 0" align="center"> </p>
<p style="margin-top: 0; margin-bottom: 0" align="center"> </p>
<p style="margin-top: 0; margin-bottom: 0" align="center"> </p>
</td></tr>
</table>
</body>
</html>
Det her er linie 57:
SQL = "select * from guestbook order by created desc"
håber nogen kan hjælpe på forhånd tak
m.v.h to
