Tilføj/opdater
Håber i kan hjælpe en der totalt "grøn" m.h.t. ASP...!Nedenstående side skal laves sådan, at når man indtaster i felterne tilføjes/opdateres det i databasen, og herefter loades samme side.
<html>
<head>
<title>Administrationsmodul</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body bgcolor="#000000" text="#FFFFFF" link="#FFFFFF" vlink="#FFFFFF" alink="#FFFFFF">
<%
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("cgi-bin/invite.mdb")
%>
<%
SQL = "select * from T_INVITE ;"
Set RS = Conn.Execute(SQL)
%>
<%
response.write "<p align='center'><font face='Verdana' size='2'>Administrationsmodul</font></p>"
response.write "<p align='center'><font face='Verdana' size='2'>Tilmeldte</font></p>"
response.write "<table width='600' border='0' cellspacing='0' cellpadding='0' align='center'><tr>"
response.write "<td width='50'><font face='Verdana' size='-1'>ID</font></td>"
response.write "<td width='150'><font face='Verdana' size='-1'>Fornavn</font></td>"
response.write "<td width='150'><font face='Verdana' size='-1'>Efternavn</font></td>"
response.write "<td width='250'><font face='Verdana' size='-1'>E-mail</font></td></tr>"
Do While Not RS.EOF
response.write "<tr><td width='50'><font face='Verdana' size='-1'>" & RS("ID") & "</td>"
response.write "<td width='150'><font face='Verdana' size='-1'>" & RS("FNAME") & "</td>"
response.write "<td width='150'><font face='Verdana' size='-1'>" & RS("LNAME") & "</td>"
response.write "<td width='250'><font face='Verdana' size='-1'><a href='mailto:" & RS("MAIL") & "?subject=Inv&body=http://rroslev/invite.asp?ID=" & RS("ID") & "'>SEND MAIL</td></tr>"
RS.movenext
loop
response.write " </table>"
response.write " <br>"
response.write " <div align='center'><font face='Verdana' size='2'>Tilføj</font><br>"
response.write " <br></div>"
response.write " <table width='600' border='0' cellspacing='0' cellpadding='0' align='center'><tr>"
response.write " <td width='50'><font face='Verdana' size='-1'>ID</font></td>"
response.write " <td width='150'><font face='Verdana' size='-1'>Fornavn</font></td>"
response.write " <td width='150'><font face='Verdana' size='-1'>Efternavn</font></td>"
response.write " <td width='250'><font face='Verdana' size='-1'>E-mail</font></td>"
response.write " </tr><tr>"
response.write " <td width='50'><font face='Verdana' size='-1'>"
response.write " <form method='post' action='admin2.asp'><input type='text' name='ID' size='3' maxlength='3'></font></td>"
response.write " <td width='150'><font face='Verdana' size='-1'>"
response.write " <input type='text' name='FNAME' size='15' maxlength='255'></font></td>"
response.write " <td width='150'><font face='Verdana' size='-1'>"
response.write " <input type='text' name='LNAME' size='15' maxlength='255'></font></td>"
response.write " <td width='250'>"
response.write " <input type='text' name='MAIL' size='33' maxlength='255'>"
response.write " </td>"
response.write " </tr>"
response.write " <tr><td width='50'></td>"
response.write " <td width='150'></td>"
response.write " <td width='150'></td>"
response.write " <td width='250' align ='right'><input type='submit' name='Submit' value='Tilføj'></td></tr></table>"
%>
</body>
</html>
Siden hedder admin2.asp
Navnene på input-felterne er de samme, som navnene på de kolonner de skal opdatere i db'en....!
