Avatar billede roslev Nybegynder
16. januar 2000 - 06:49 Der er 1 løsning

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&oslash;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&oslash;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....!
Avatar billede s Nybegynder
16. januar 2000 - 14:18 #1
Så kan du vel bare lave en lykke:


<%
Connection = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & server.MapPath("dindatabase.mdb")

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

Sql = "INSERT INTO tabelnavn ("
a = 0

for each x in request.form
if a = 0 then
Sql = Sql & x
else
Sql = Sql & ", " & x
end if
a = a + 1
next

Sql = Sql & ") VALUES("

a = 0

for each x in request.form
if a = 0 then
Sql = Sql & "'" & request.form(x) & "'"
else
Sql = Sql & ", '" & request.form(x) & "'"
end if
next

Conn.execute( Sql )

Conn.close
Set Conn = Nothing
%>
Avatar billede Ny bruger Nybegynder

Din løsning...

Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.

Loading billede Opret Preview
Kategori
Kurser inden for grundlæggende programmering

Log ind eller opret profil

Hov!

For at kunne deltage på Computerworld Eksperten skal du være logget ind.

Det er heldigvis nemt at oprette en bruger: Det tager to minutter og du kan vælge at bruge enten e-mail, Facebook eller Google som login.

Du kan også logge ind via nedenstående tjenester