feljfinding i \"gæstebog\" 2
Jeg har tidligere fået jælp til min gæstebog/tagwall. denne gang er det ikke et egentlig problem. Der skar bare det, at hvis man skriver noget meget langt, kommer det hele til at stå på en linje.Desuden, vil jeg gerne have afstand mellem mine tabeller, så hvis der er en, der kan sætte <br> det rigtige sted vil jeg blive glad.
Her er siden
<%
Const adOpenKeyset = 1
Const adLockOptimistic = 3
strMode = Request.QueryString(\"mode\")
tempConn = \"PROVIDER=MSDASQL;DRIVER={Microsoft Access Driver (*.mdb)};DBQ=\" & Server.MapPath(\"andet/tagwall.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>
<style type=\"text/css\">
<!--
@import url(andet/link1.css);
-->
</style>
</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=\"tagwall.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=\'tagwall.asp\'\">
</td>
</tr>
</table>
</center>
</form>
<%
Case Else
strAddLine = \"<p><img src=images/add.gif width=16 height=16> <a href=tagwall.asp?mode=add><strong><font face=verdana size=2>Drop et comment</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)
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>\"
Response.Write \"<br>\"
Else
Response.Write \"<p><font face=verdana size=2>Der er endnu ikke nogle der har skrevet på wallen</font></p>\"
End If
myConn.Close
Set myConn = Nothing
Response.Write strAddLine
End Select
%>
</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>
