ny linje i DB
Hejsa jeg har et script fra activeserverpages som jeg har ændret i. Men jeg kan ikke finde ud af hvordan at man får den til at huske de mellemrum man laver når man skriver beskeden.. mit script:<%
cookemail = request.cookies("tagwall")("email")
cooknavn = request.cookies("tagwall")("navn")
Const adOpenKeyset = 1
Const adLockOptimistic = 3
strMode = Request.QueryString("mode")
tempConn = "PROVIDER=MSDASQL;DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("tagwall.mdb") & ";UID=admin;PWD=;"
If Request.Form("Gem") <> "" Then
strNavn = Trim(Request.Form("Navn"))
strEmail = Trim(Request.Form("Email"))
strKommentar = Trim(Request.Form("Kommentar"))
response.cookies("tagwall")("navn")= strNavn
response.cookies("tagwall")("email")= strEmail
response.cookies("tagwall").expires = "19-01-2038"
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") = strNavn
rs("Email") = strEmail
rs("Kommentar") = strKommentar
rs("Dato") = Now()
rs.Update
End If
rs.Close
Set rs = Nothing
End If
%>
<html>
<head>
<title>tag-wall</title>
<link REL="StyleSheet" HREF="tagwall.css" TYPE="text/css" TITLE="Web-bruger style">
</head>
<body>
<div align="center"><center><table border="0" width="600" cellspacing="0" cellpadding="3">
<tr>
<td width="100%" bgcolor="#000000"><div align="center"><center><p><font face="verdana" size="4" color="#FFFFFF"><strong>Tag-Wall</strong></font></td>
</tr>
<tr align="center">
<td width="100%">
<%
Select Case strMode
Case "add"
%>
<form method="POST" action="tagwall.asp">
<table border="0" width="100%" cellspacing="0" cellpadding="2">
<tr>
<td valign="middle" align="left" colspan="2"><tt><br>
Indtast venligst oplysningerne i følgende felter:<br>
</td>
</tr>
<tr>
<td valign="middle" align="left"><div align="right"><p><strong><tt>DJ</tt></strong></td>
<td valign="middle" align="left"><input type="text" name="Navn" size="40" value="<%=cooknavn%>"></td>
</tr>
<tr>
<td valign="middle" align="left"><div align="right"><p><strong><tt>Mail</tt></strong></td>
<td valign="middle" align="left"><input type="text" name="Email" size="40" value="<%=cookemail%>"></td>
</tr>
<tr>
<td valign="top" align="left"><div align="right"><p><strong><tt>Tag</tt></strong></td>
<td valign="middle" align="left"><textarea rows="3" name="Kommentar" cols="40"></textarea></td>
</tr>
<tr>
<td valign="middle" align="left" colspan="2"><br>
<input type="submit" value="Sign" name="Gem"> <input type="button" value="Cancel" name="Annuller" onClick="java script:history.back();"></td>
</tr>
</table>
</form>
<%
Case Else
Set myConn = Server.CreateObject("ADODB.Connection")
strSQL = "SELECT * FROM Guestbook ORDER BY Dato DESC;"
myConn.Open tempConn
Set rs = myConn.Execute(strSQL)
If Not (rs.BOF Or rs.EOF) Then
Response.Write "<p><a href=tagwall.asp?mode=add><strong><font face=verdana size=2>Sign Da Tag-Wall!</font></strong></a></p><table border=0 cellpadding=0 cellspacing=0>"
Do While Not rs.EOF
Response.Write "<tr><td>" & rs("Dato") & "</td></tr>"
Response.Write "<tr><td><tt><strong><font color=''darkred''><a href=''mailto:" & rs("Email") &"''>" & rs("Navn") & "</a>:</font></strong></tt></td></tr>"
Response.Write "<tr><td><tt><font color=''darkred''>" & rs("Kommentar") & "</font></tt><br> </td></tr>"
rs.MoveNext
Loop
Response.Write "</table>"
Else
Response.Write "<p><font face=verdana size=2>Yet anyone haven''t signed the Tag-Wall</font></p>"
End If
myConn.Close
Set myConn = Nothing
Response.Write "<p><a href=tagwall.asp?mode=add><strong><font face=verdana size=2>Sign Da Tag-Wall!</font></strong></a></p>"
End Select
%>
</tr>
</table>
</center></div>
</body>
</html>
jeg har læst at man kan bruge:
<%=Replace(RS("feltnavn"),vbcrlf,"<br>")%>
men det kan jeg ikke få til at virke hvor og hvad skal jeg sætte ind ???
