Flytte record fra en tabel til en anden....
Hej,Jeg har lavet mig en lille ICQ liste...
Når brugeren signer op bliver han/hun smidt ind i tabellen validate.
Her skal jeg så ind på min admin side og sige OK for at brugeren kommer ind i tabellen MEMBERS.
Jeg bruger følgende kode:
-------------------------
<%
if session("godkendt") = false then
response.redirect "login.asp"
end if
%>
<%
Response.buffer = True
%>
<HTML>
<HEAD>
<TITLE>Slet bruger</TITLE>
<link rel="stylesheet" type="text/css" href="../style.css">
</HEAD>
<BODY>
<div align='center'>
<font face='verdana' size='2'><b>Validér bruger !</b></font>
</div>
<%
set conn = Server.CreateObject ("ADODB.connection")
conn.Open "DBQ=" & Server.MapPath("../db/icq.mdb") &";Driver={Microsoft Access Driver (*.mdb)};"
SQL = "SELECT * FROM validate order BY id DESC"
Set RS = conn.execute(SQL)
Do While Not RS.eof
response.write "<table width='50%' border='1' align='center'>"
response.write "<tr>"
response.write "<td width='24%'><font face='Verdana' size='2'><b>Dato:</b></font></td>"
response.write "<td width='76%' align='right'><font face='Verdana' size='2'>"& RS("dato") &"</font></td>"
response.write "</tr>"
response.write "<tr>"
response.write "<td width='24%'><font face='Verdana' size='2'><b>Nickname:</b></font></td>"
response.write "<td width='76%' align='right'><font face='Verdana' size='2'>"& RS("nick") &"</font></td>"
response.write "</tr>"
response.write "<tr>"
response.write "<td width='24%'><font face='Verdana' size='2'><b>Realname:</b></font></td>"
response.write "<td width='76%' align='right'><font face='Verdana' size='2'>"& RS("realname") &"</font></td>"
response.write "</tr>"
response.write "<td width='24%'><font face='Verdana' size='2'><b>Adresse:</b></font></td>"
response.write "<td width='76%' align='right'><font face='Verdana' size='2'>"& RS("adresse") &"</font></td>"
response.write "</tr>"
response.write "<td width='24%'><font face='Verdana' size='2'><b>Postnummer:</b></font></td>"
response.write "<td width='76%' align='right'><font face='Verdana' size='2'>"& RS("postnummer") &"</font></td>"
response.write "</tr>"
response.write "<td width='24%'><font face='Verdana' size='2'><b>By:</b></font></td>"
response.write "<td width='76%' align='right'><font face='Verdana' size='2'>"& RS("city") &"</font></td>"
response.write "</tr>"
response.write "<tr>"
response.write "<td width='24%'><font face='Verdana' size='2'><b>Alder:</b></font></td>"
response.write "<td width='76%' align='right'><font face='Verdana' size='2'>"& RS("alder") &"</font></td>"
response.write "</tr>"
response.write "<tr>"
response.write "<td width='24%'><font face='Verdana' size='2'><b>ICQ #:</b></font></td>"
response.write "<td width='76%' align='right'><font face='Verdana' size='2'>"& RS("icqnummer") &"</font></td>"
response.write "</tr>"
response.write "<tr>"
response.write "<td width='24%'><font face='Verdana' size='2'><b>URL:</b></font></td>"
response.write "<td width='76%' align='right'><font face='Verdana' size='2'>"& RS("url") &"</font></td>"
response.write "</tr>"
response.write "<tr>"
response.write "<td width='24%'><font face='Verdana' size='2'><b>E-Mail:</b></font></td>"
response.write "<td width='76%' align='right'><font face='Verdana' size='2'>"& RS("email") &"</font></td>"
response.write "</tr>"
response.write "<tr>"
response.write "<td width='24%'><font face='Verdana' size='2'><b>Titel på hjemmeside:</b></font></td>"
response.write "<td width='76%' align='right'><font face='Verdana' size='2'>"& RS("titel") &"</font></td>"
response.write "</tr>"
response.write "<tr>"
response.write "<td width='24%'><font face='Verdana' size='2'><b>Info:</b></font></td>"
response.write "<td width='76%' align='right'><font face='Verdana' size='2'>"& RS("info") &"</font></td>"
response.write "</tr>"
response.write "<tr>"
response.write "<td width='24%'> </td>"
response.write "<td width='76%' align='right'> </td>"
response.write "</tr>"
response.write "<tr>"
response.write "<td width='24%'><font face='Verdana' size='2'><b>Action:</b></font></td>"
response.write "<td width='76%' align='right'><font face='Verdana' size='2'>[<a href='validate.asp?id="& RS("id") &"'>valider</a>] / [<a href=validate_del.asp?mode=" & RS("ID") & ">delete</a>]</font></td>"
response.write "</tr>"
response.write "</table>"
response.write "<br>"
RS.MoveNext
loop
%>
<br>
<br>
<br>
<div align='center'>
<font face='verdana' size='2'><b>Slet af brugere !</b></font>
</div>
<%
set conn = Server.CreateObject ("ADODB.connection")
conn.Open "DBQ=" & Server.MapPath("../db/icq.mdb") &";Driver={Microsoft Access Driver (*.mdb)};"
SQL = "SELECT * FROM members order BY id DESC"
Set RS = conn.execute(SQL)
%>
<%
Do While Not RS.eof
%>
<div align="center">
<center>
<table border="0" width="75%">
<tr>
<td width="50%" class="text"><b>Dato:</b></td>
<td width="50%" class="text"><%= rs("dato") %></td>
</tr>
<tr>
<td width="50%" class="text"><b>Nickname:</b></td>
<td width="50%" class="text"><%= rs("nick") %></td>
</tr>
<tr>
<td width="50%" class="text"><b>Realname:</b></td>
<td width="50%" class="text"><%= rs("realname") %></td>
</tr>
<tr>
<td width="50%" class="text"><b>Adresse:</b></td>
<td width="50%" class="text"><%= rs("adresse") %></td>
</tr>
<tr>
<td width="50%" class="text"><b>Postnummer:</b></td>
<td width="50%" class="text"><%= rs("postnummer") %></td>
</tr>
<tr>
<td width="50%" class="text"><b>By:</b></td>
<td width="50%" class="text"><%= rs("city") %></td>
</tr>
<tr>
<td width="50%" class="text"><b>Alder:</b></td>
<td width="50%" class="text"><%= rs("alder") %></td>
</tr>
<tr>
<td width="50%" class="text"><b>ICQ #:</b></td>
<td width="50%" class="text"><%= rs("icqnummer") %></td>
</tr>
<tr>
<td width="50%" class="text"><b>URL:</b></td>
<td width="50%" class="text"><%= rs("url") %></td>
</tr>
<tr>
<td width="50%" class="text"><b>E-Mail:</b></td>
<td width="50%" class="text"><%= rs("email") %></td>
</tr>
<tr>
<td width="50%" class="text"><b>Titel på hjemmeside:</b></td>
<td width="50%" class="text"><%= rs("titel") %></td>
</tr>
<tr>
<td width="50%" class="text" valign="top"><b>Info:</b></td>
<td width="50%" class="text"><%= Replace(rs("info"), VbCrLf, "<BR>") %></td>
</tr>
<tr>
<td width="50%" class="text"></td>
<td width="50%" class="text"></td>
</tr>
<tr>
<td width="50%" class="text"><b>Action:</b></td>
<td width="50%" class="text">[<a href=slet.asp?mode=<%= RS("ID") %>>Slet</a>]</td>
</tr>
<tr>
<td width="50%" class="text"></td>
<td width="50%" class="text"></td>
</tr>
</table>
</center>
</div>
<%
RS.MoveNext
loop
%>
<br>
<br>
-----------------------------
validate.asp
-----------------------------
<%
set conn = Server.CreateObject ("ADODB.connection")
conn.Open "DBQ=" & Server.MapPath("../db/icq.mdb") &";Driver={Microsoft Access Driver (*.mdb)};"
Sql = "INSERT INTO members (dato, nick, realname, alder, icqnummer, url, email, titel, info) values('" & Date() & "','" & Request("nick") & "','" & Request("realname") & "','" & Request("alder") & "','" & Request("icqnummer") & "','" & Request("url") & "','" & Request("email") & "','" & Request("titel") & "','" & Request("info") & "')"
Set RS = conn.execute(SQL)
%>
<%
Response.redirect "deluser.asp"
%>
---------------------------------
Nogen der har nogen forslag til en løsning på dette problem ?
<//morpheus\\>
