kode er sikkert rodet men se lige her:
det er hvad man skriver i textarea "beskrivelse" som det skal bruges i
:)
<%
Const adOpenKeyset = 1
Const adLockOptimistic = 3
str = replace(request.form("textarea"),vbCrLf,"<br>")
strMode = Request.QueryString("mode")
tempConn = "PROVIDER=MSDASQL;DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("/dbs/db.mdb") & ";UID=admin;PWD=;"
If Request.Form("Gem") <> "" Then
strurl = Trim(Request.Form("url"))
strnavn = Trim(Request.Form("navn"))
strbeskrivelse = Trim(Request.Form("beskrivelse"))
Set rs = Server.CreateObject("ADODB.RecordSet")
strSQL = "SELECT * FROM downloads WHERE (ID = 0)"
rs.Open strSQL, tempConn, adOpenKeyset, adLockOptimistic
If (rs.BOF Or rs.EOF) Then
rs.AddNew
rs("url") = strurl
rs("navn") = strNavn
rs("beskrivelse") = strbeskrivelse
rs.Update
End If
rs.Close
Set rs = Nothing
End If
%>
<div align="left"><table width="488" border="0" cellspacing="0" cellpadding="3">
<tr>
<td width="488"><font face="Arial" size="5" color="Black"><i><B>Add Download</i></B></font></td>
</tr>
<tr align="center">
<td width="100%">
<form method="POST" action="add_download.asp">
<table border="0" width="100%" cellspacing="0" cellpadding="2">
<tr>
<td valign="middle" align="left"><div align="right"><p><B><font face="arial" size="2">
Http://</font></B></td> <td valign="middle" align="left"><input type="text" name="url" size="40"></td>
</tr>
<tr>
<td valign="middle" align="left"><div align="right"><p><B><font face="arial" size="2">Navn</font></B></td>
<td valign="middle" align="left"><input type="text" name="navn" size="40"></td>
</tr>
<tr>
<td valign="top" align="left"><div align="right"><p><B><font face="arial" size="2">Beskrivelse</font></B></td>
<td valign="middle" align="left"><textarea rows="5" name="beskrivelse" cols="40"></textarea></td>
</tr>
<tr>
<td valign="middle" align="left" colspan="2"><br>
<input type="submit" value="Gem" name="Gem"> <input type="button" value="Annuller" name="Annuller" onClick="java script:history.back();"></td>
</tr>
</table>
</form>
</tr>
</table>
</div>