her er det script som formularen står i :
<%
Set Conn = Server.CreateObject("ADODB.Connection")
DBPath = "DBQ=" & server.mappath("members.mdb")
Conn.Open "DRIVER={Microsoft Access Driver (*.mdb)};" & DBPath & ";Uid=Admin;PW=Casius"
Button1Caption = "Create new"
Button1Name = "Create" ' Må ikke ændres
Button2Caption = ""
Button2Name = ""
title = ""
SQL = "SELECT * FROM members ORDER BY ID"
Set RS = Conn.Execute(SQL)
if request("Action")="Edit" then
Sql = "SELECT * FROM members WHERE ID = " & Request.QueryString("ID")
Set RS = Conn.Execute(SQL)
EditFlag = true
Name = RS.Fields("Name")
Rank = RS.Fields("Rank")
Nick = RS.Fields("Nick")
Age = RS.Fields("Age")
Email = RS.Fields("Email")
Icq = RS.Fields("Icq")
Fav_wea = RS.Fields("Fav_wea")
Fav_map = RS.Fields("Fav_map")
Connection = RS.Fields("Connection")
Button1Caption = "Apply changes"
Button1Name = "Edit"
Button2Caption = "Delete User"
Button2Name = "Delete"
end if
%>
<html>
<head>
<style>
A:link {
TEXT-DECORATION: none
}
A:visited {
TEXT-DECORATION: none
}
A:active {
TEXT-DECORATION: none
}
A:hover {
TEXT-DECORATION: underline
}
BODY, TD, TH
{
margin-top: 0em;
margin-right: 0em;
margin-bottom: 0em;
margin-left: 0em;
background-position: 0% 0%;
}
</style>
<title>Clan [BooM]</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body bgcolor="#384870" link="#000000" vlink="#000000" alink="#000000">
<form method="post" action="members_add_edit_delete.asp" name=""><div align="center">
<table width="500" border="1" cellspacing="0" cellpadding="0" bordercolor="#000000" align="center">
<tr bgcolor="#7088A0">
<td>
<div align="center"><font face="Verdana, Arial, Helvetica, sans-serif" size="2" color="#000000"><a href="news.asp">News</a>
- <a href="members.asp">Members</a> - <a href="results.asp">Results</a>
- <a href="schedule.asp">Schedule</a> - <a href="files.asp">Files</a>
- <a href="tagwall.asp">Tagwall</a> - <a href="
http://www.q2.dk/qm/boom/private/index.asp">Private</a></font></div> </td>
</tr>
</table>
<br>
<table width="500" border="1" cellspacing="0" cellpadding="0" align="center" bordercolor="#000000">
<tr bgcolor="#384870">
<td>
<div align="center"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><b>Add
A New Member to BooM</b></font></div>
</td>
</tr>
</table>
<table width="500" border="0" cellspacing="0" cellpadding="0" align="center" bgcolor="#384870">
<tr bgcolor="#384870">
<td>
<div align="left">
<p><font face="Verdana, Arial, Helvetica, sans-serif" size="2">
<input type="hidden" name="ID" value="<% = ID %>">
</font></p>
<p><font face="Verdana, Arial, Helvetica, sans-serif" size="2">ID</font><br>
<font face="Verdana, Arial, Helvetica, sans-serif" size="2" color="#000000">
<input type="text" name="ID" value="<%=ID%>">
<%=ID%><br>
NickName </font><br>
<input type="text" name="Nick" value="<%=Nick%>">
<%=Nick%> <font face="Verdana, Arial, Helvetica, sans-serif" size="2" color="#000000"><br>
Real Name<br>
<input type="text" name="Name" value="<%=Name%>">
<%=Name%><br>
Age <br>
<input type="text" name="Age" value="<%=Age%>">
<%=Age%><br>
Email <br>
<input type="text" name="Email" value="<%=email%>">
<%=email%><br>
Icq <br>
<input type="text" name="Icq" value="<%=Icq%>">
<%=Icq%> <br>
Favorite Weapon <br>
<input type="text" name="Fav_wea" value="<%=Fav_wea%>">
<%=Fav_wea%> <br>
Favorite Map<br>
<input type="text" name="Fav_map" value="<%=Fav_map%>">
<%=Fav_map%><br>
Rank <br>
<input type="text" name="Rank" value="<%=Rank%>">
<%=Rank%><br>
System - sort by Proccesor - 3d - sound - ram <br>
<textarea name="System"><%=System%></textarea>
<%=System%><br>
Connection <br>
</font><font face="Verdana, Arial, Helvetica, sans-serif" size="2" color="#000000"></font><font face="Verdana, Arial, Helvetica, sans-serif" size="2" color="#000000">
<input type="text" name="Connection" value="<%=Connection%>">
</font><font face="Verdana, Arial, Helvetica, sans-serif" size="2"><%=Connection%><br>
<% if request("Action")="Edit" then %> <br>
<input type="submit" name="<%=button1name%>2" value="<%=button1caption%>">
<input type="submit" name="<%=button2name%>" value="<%=button2caption%>">
<br>
<% else %> <br>
<input type="submit" name="<%=button1name%>" value="<%=button1caption%>">
<br>
<% end if %> </font> </p>
</div>
</td>
</tr>
</table>
<table width="500" border="0" cellspacing="0" cellpadding="0" bordercolor="#000000" align="center">
<tr bgcolor="#7088A0">
<td width="100%" colspan="2"><img src="../_images/trans.gif" width="5" height="10"><font face="Verdana,Tahoma,Arial" size="2" color="#3366FF"><font face="Verdana, Arial, Helvetica, sans-serif" size="1" color="#000000">User
Administration - Press user to EDIT/DELETE</font></font></td>
</tr>
<tr align="left" valign="top" bgcolor="#384870">
<td width="100%" colspan="2">
<table width="500" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><font face="Verdana, Arial, Helvetica, sans-serif" size="1"><img src="../_images/trans.gif" width="5" height="10"></font></td>
<td width="495" height="0" align="left" valign="top"> <font face="Verdana, Arial, Helvetica, sans-serif" size="2" color="#000000"><%
SQL = "SELECT * FROM members ORDER BY nick desc"
Set RS = Conn.Execute(SQL)
%> <% Do While Not RS.EOF %> <a href="add_member.asp?Action=Edit&ID=<%=RS("ID")%>"><%=RS("nick")%></a>
- <%=RS("ID")%><br>
<%
RS.MoveNext
loop %> </font></td>
</tr>
<tr>
<td colspan="2" height="3"><img src="../_images/trans.gif" width="200" height="3"></td>
</tr>
</table>
</td>
</tr>
</table>
<p align="center"><br>
<br>
</p>
<p> </p>
</FORM>
</div>
</body>
</html>