Opret

Jeg kan sq ikke rigtig få det til at fungere.

En bruger skal have mulighed for at oprette et indlæg.

Her er koderne – hvad gør jeg forkert.


form.asp:

<form method="post" action="opret.asp">

<input type="text" size=45 name="dato">
<input type="text" size=45 name="overskrift">
<textarea cols=62 rows=18 name="indhold"></textarea>

<input type="submit">


opret.asp:

Set Conn = Server.CreateObject("ADODB.Connection")

DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath ("/database/test.mdb")
Conn.Open DSN

dato = request.form("dato")
overskrift = request.form("overskrift")
indhold = request.form("indhold")

set rs = Conn.Execute(sql)

strSQL = "insert into artikel("

strSQL = strSQL & "dato,"
strSQL = strSQL & "overskrift,"
strSQL = strSQL & "indhold)"

strSQL = strSQL & "values("
   
strSQL = strSQL & "'& dato &',"
strSQL = strSQL & "'& overskrift &',"
strSQL = strSQL & "'& indhold &')"

conn.execute(strSQL)

Conn.close
set Conn = nothing