Database skrivning!
Hej....!¤Er der nogen derude der ved hvorfor følgende kode ikke gemmer nogen text i access databasen. Den laver bare tomme felter:
Skriv.asp:
<% response.buffer = true %>
<%
Response.Write(\"<font face=´Tahoma´>Indtast informationer:\")
Response.Write(\"<form action=´gem.asp´ method=´post´>\")
Response.Write(\"<font face=´Tahoma´>Username<br>\")
Response.Write(\"<input type=´text´ name=´username´ size=´20´>\")
Response.Write(\"<p>\")
Response.Write(\"<font face=´Tahoma´>Tekst<br>\")
Response.Write(\"<input type=´text´ name=´tekst´ size=´40´>\")
Response.Write(\"<p>\")
Response.Write(\"<font face=´Tahoma´>Dato<br>\")
Response.Write(\"<input type=´text´ name=´dato´ size=´20´>\")
Response.Write(\"<p>\")
Response.Write(\"<input type=´submit´ value=´Send´></font>\")
Response.Write(\"</form>\")
%>
Og gem.asp
<% response.buffer = true %>
<%
set conn = Server.CreateObject(\"ADODB.Connection\")
conn.Open \"Driver={Microsoft Access Driver (*.mdb)}; DBQ=\" & Server.MapPath(\"database.mdb\")
Username = Session(\"username\")
Tekst = Session(\"tekst\")
Dato = Session(\"dato\")
conn.Execute(\"INSERT INTO forum1 (Username, Tekst, Dato) VALUES (´\" & Username & \"´, ´\" & Tekst & \"´, ´\" & Dato & \"´)\")
conn.Close
set conn = text
Response.Redirect(\"http://www.eksperten.dk.dk\")
%>
/Thomas
