Du skal bare skrive det i selve koden, der hvor du sætter data ind i databasen.
Et eksempel:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "
http://www.w3.org/TR/html4/loose.dtd"><html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Untitled Document</title>
</head>
<body>
<% IF Request.Form("opret12") = "Opret" then
' korrigere indput fra bruger
var_link2 = server.HTMLEncode(Trim(Request.Form("opret12")))
var_text2 = server.HTMLEncode(Trim(Request.Form("opret12")))
' omsaetter linieskift til html
If Not isNull(var_text2 ) Then
var_text2 = Replace(var_text2, vbCrLf, "<br>")
End If
' forbindelse til database
'indsaet i database
strSQL = "Insert into tabel ("
strSQL = strSQL & "links, "
strSQL = strSQL & "tekst) "
strSQL = strSQL & "values( '"
strSQL = strSQL & var_links & "', '"
strSQL = strSQL & var_text2 & "')"
Conn.Execute(strSQL)
Conn.Close
Set Conn = Nothing
end if%>
<form ACTION="<%=MM_editAction%>" METHOD="POST" enctype="application/x-www-form-urlencoded" name="Box2" id="Box2">
<strong>
</strong>
<table width="100%" border="0">
<tr>
<th colspan="2" scope="col"><strong>
Box 2 ( Medlemsskab
)</strong></th>
</tr>
<tr>
<td colspan="2">Overskrift</td>
</tr>
<tr>
<td colspan="2"><input name="link2" type="text" id="link14" size="22" maxlength="22">
Max 22 Tegn </td>
</tr>
<tr>
<td colspan="2">Tekst</td>
</tr>
<tr>
<td width="56%"><textarea name="text2" cols="40" rows="10" id="textarea4"></textarea></td>
<td width="44%"><input name="Opret12" type="submit" id="Opret13" value="Opret"> </td>
</tr>
<tr>
<td colspan="2"> </td>
</tr>
</table>
<input type="hidden" name="MM_insert" value="Box2">
</form>
</body>
</html>
:-) Karsten