Fejlfinding i \"gæstebog\"
Jeg har downloaded et eksempel på en gæstebog i ASP. Jeg har nu skrevet lidt om id den, så den kommer til at passe til mit design.Guestbook.asp ser således ud:
<%
\' --------------------------------------------------------------------------------
\' Dette eksempel er skrevet af Dennis Knappe ( info@activeserverpages.dk )
\' Eksemplet kan downloades fra http://www.activeserverpages.dk
\' Scriptet kan frit anvendes til ikke kommercial brug, ønsker du at bruge scriptet
\' i et kommercial sammenhæng kontakt da venligst Dennis Knappe
\' --------------------------------------------------------------------------------
Const adOpenKeyset = 1
Const adLockOptimistic = 3
strMode = Request.QueryString(\"mode\")
tempConn = \"PROVIDER=MSDASQL;DRIVER={Microsoft Access Driver (*.mdb)};DBQ=\" & Server.MapPath(\"guestbook.mdb\") & \";UID=admin;PWD=;\"
If Request.Form(\"Gem\") <> \"\" Then
strError = \"\"
strNavn = Trim(Request.Form(\"Navn\"))
strEmail = Trim(Request.Form(\"Email\"))
strKommentar = Trim(Request.Form(\"Kommentar\"))
If Len(strNavn) = 0 Then
strError = \"<li>Du skal skrive dit navn!</li>\"
ElseIf validateEmail(strEmail) = False Then
strError = \"<li>Du skal skrive en gyldig e-mail adresse!</li>\"
ElseIf Len(strKommentar) = 0 Then
strError = \"<li>Du skal skrive en kommentar!</li>\"
End If
If Len(strError) = 0 Then
Set rs = Server.CreateObject(\"ADODB.RecordSet\")
strSQL = \"SELECT * FROM Guestbook WHERE (ID = 0)\"
rs.Open strSQL, tempConn, adOpenKeyset, adLockOptimistic
If (rs.BOF Or rs.EOF) Then
rs.AddNew
rs(\"Navn\") = Server.HTMLEncode(strNavn)
rs(\"Email\") = Server.HTMLEncode(strEmail)
rs(\"Kommentar\") = Server.HTMLEncode(strKommentar)
rs(\"Dato\") = Now()
rs.Update
End If
rs.Close
Set rs = Nothing
Else
strError = \"<p><ul><font color=#FF0000>\" & strError & \"</font></ul></p>\"
strMode = \"add\"
End If
End If
%>
<html>
<head>
<title>Tagwall</title>
</head>
<body background=\"images/backpic.gif\">
<center>
<table border=\"0\" width=\"600\" height=\"100%\" bgcolor=\"#000000\">
<tr valign=top>
<td width=\"100%\">
<center>
<table border=\"0\" width=\"600\" bgcolor=\"#000000\">
<tr>
<td width=\"100%\">
<img border=\"0\" src=\"images/tagwall.gif\">
<%
Select Case strMode
Case \"add\"
%>
<form method=\"POST\" action=\"guestbook.asp\">
<center>
<table border=\"1\" width=\"590\" bgcolor=\"#808080\" style=\"color: #000000\" bordercolor=\"#001E4F\" height=\"73\">
<tr>
<td width=\"100%\" align=\"left\" height=\"19\">
<table border=\"0\" width=\"100%\" style=\"font-family: Verdana; font-size: 8 pt; font-weight: bold; color: #000000\" bgcolor=\"#808080\">
<tr>
<td width=\"100%\">Drop et comment <%=strError%></td>
</tr>
</table>
</td>
</tr>
<tr valign=\"top\">
<td width=\"100%\" bgcolor=\"#C0C0C0\" align=\"left\" height=\"55\"><font size=\"3\" face=\"Garamond\">Navn:<br>
<input type=\"text\" name=\"Navn\" size=\"40\" value=\"<%=strNavn%>\"><br>
<font size=\"3\" face=\"Garamond\">Email:<br>
<input type=\"text\" name=\"Email\" size=\"40\" value=\"<%=strEmail%>\"><br>
<font size=\"3\" face=\"Garamond\">Kommentar:<br>
<textarea rows=\"3\" name=\"Kommentar\" cols=\"40\"><%=strKommentar%></textarea><br>
<input type=\"submit\" value=\"Gem\" name=\"Gem\"> <input type=\"button\" value=\"Annuller\" name=\"Annuller\" onClick=\"java script:location.href=\'guestbook.asp\'\">
</td>
</tr>
</table>
</center>
</form>
<%
Case Else
strAddLine = \"<p><img src=add.gif width=16 height=16> <a href=guestbook.asp?mode=add><strong><font face=verdana size=2>Skriv et indlæg i min gæstebog!</font></strong></a></p>\"
Response.Write strAddLine
strSQL = \"SELECT * FROM Guestbook ORDER BY Dato DESC;\"
Set myConn = Server.CreateObject(\"ADODB.Connection\")
myConn.Open tempConn
Set rs = myConn.Execute(strSQL)
If Not (rs.BOF Or rs.EOF) Then
Response.Write \"<table border=\"1\" width=\"590\" bgcolor=\"#808080\" style=\"color: #000000\" bordercolor=\"#001E4F\" height=\"73\">\"
Do While Not rs.EOF
dtmDato = rs(\"Dato\")
dtmDato = FormatDateTime(dtmDato,vbLongDate) & \" kl. \" & FormatDateTime(dtmDato,vbLongTime)
Response.Write \"<tr><td width=\"100%\" align=\"left\" height=\"19\"><table border=\"0\" width=\"100%\" style=\"font-family: Verdana; font-size: 8 pt; font-weight: bold; color: #000000\" bgcolor=\"#808080\"><tr>\"
If Len(rs(\"Email\")) > 0 Then
Response.Write \"<td width=\"250\"><a href=mailto:\" & rs(\"Email\") & \">\" & rs(\"Navn\") & \"</a> skriver:</td><td width=\"90\" style=\"font-family: Verdana; font-size: 8 pt; font-weight: bold\"><p align=\"center\"><b><font face=\"Verdana\">--==--</font></b></td><td width=\"250\"><p align=\"right\">\" & dtmDato & \"</td></tr></table></td></tr>\"
Else
Response.Write \"<td width=\"250\">\" & rs(\"Navn\") & \" skriver:</td><td width=\"90\" style=\"font-family: Verdana; font-size: 8 pt; font-weight: bold\"><p align=\"center\"><b><font face=\"Verdana\">--==--</font></b></td><td width=\"250\"><p align=\"right\">\" & dtmDato & \"</td></tr></table></td></tr>\"
End If
Response.Write \"<tr valign=\"top\"><td width=\"100%\" bgcolor=\"#C0C0C0\" align=\"left\" height=\"55\"><font size=\"3\" face=\"Garamond\">\" & rs(\"Kommentar\") & \"</td></tr>\"
rs.MoveNext
Loop
Response.Write \"</table>\"
Else
Response.Write \"<p><font face=verdana size=2>Der er endnu ikke nogle der har skrevet i gæstebogen</font></p>\"
End If
myConn.Close
Set myConn = Nothing
Response.Write strAddLine
End Select
%>
</tr>
<tr align=\"center\">
<td width=\"100%\" bgcolor=\"#000000\"><strong><font face=\"verdana\" size=\"4\"><div align=\"center\"><center><p></font></strong><font face=\"Verdana\" size=\"1\" color=\"#FFFFFF\">Dette
eksempel er skrevet af Dennis Knappe<br>
Eksemplet kan downloades fra <a href=\"http://www.activeserverpages.dk\">http://www.activeserverpages.dk</a></font></td>
</tr>
</table>
</center></div>
</body>
</html>
<script language=\"VBScript\" runat=\"Server\">
Function validateEmail(strEmail)
validateEmail = True
If Len(strEmail) < 6 Then
validateEmail = False
End If
If InStr(1, strEmail, \"@\", 1) < 2 Then
validateEmail = False
End If
If InStr(1, strEmail, \".\", 1) = 0 Then
validateEmail = False
End If
pos = InStr(1, strEmail, \"@\", 1)
If pos < 2 Then
validateEmail = False
Else
pos = InStr(pos+1, strEmail, \"@\")
If pos > 0 Then
validateEmail = False
End If
End If
End Function
</script>
Nu er det bare, at jeg får fejlbeskeden:
Microsoft VBScript compilation error \'800a0401\'
Expected end of statement
/vermork/guestbook.asp, line 98
Response.Write \"<table border=\"1\" width=\"590\" bgcolor=\"#808080\" style=\"color: #000000\" bordercolor=\"#001E4F\" height=\"73\">\"
-------------------------------^
Håber der er en, der kan hjælpe med denne smøre
