Hjælp til ASP - 200 points !?!?!?!?
Jeg har et brugersystem, som skulle kunne oprette brugere... men der sker altså ikke noget! :-( Er der nogen der gider at kigge på det?-------------opret.asp---------------
<HTML>
<form action=\"opret_data.asp\" method=\"POST\" class=\"css\">
<HEAD>
<TITLE>The Donald Duck Club</TITLE>
<style type=\"text/css\">
.tyndramme {border-style: solid; border-width: 1; border-color:black;}
</style>
<style>a { text-decoration: none }
a:hover { color: #FFBD00 }
</style>
</HEAD>
<BODY BGCOLOR=\"#cb0000\" TEXT=\"#000000\" LINK=\"#006699\" ALINK=\"#FF0000\" VLINK=\"#000080\" MARGINHEIGHT=\"4\" MARGINWIDTH=\"4\" LEFTMARGIN=\"4\" TOPMARGIN=\"4\">
<TABLE WIDTH=\"100%\" CELLSPACING=\"0\" CELLPADDING=\"0\" BORDER=\"0\">
<TR><TD HEIGHT=\"20%\"> </TD></TR>
<TR><TD ALIGN=\"center\">
<TABLE BGCOLOR=\"#FFFFFF\" WIDTH=\"700\" CELLSPACING=\"0\" CELLPADDING=\"0\" BORDER=\"0\">
<TR>
<TD COLSPAN=\"6\" BGCOLOR=\"#000000\"><IMG SRC=\"/images/transparent.gif\" WIDTH=\"2\" HEIGHT=\"2\" ALT=\"\"></TD>
</TR>
<TR>
<TD ROWSPAN=\"6\" BGCOLOR=\"#000000\"><IMG SRC=\"/images/transparent.gif\" WIDTH=\"2\" HEIGHT=\"2\" ALT=\"\"></TD>
<TD COLSPAN=\"4\"><IMG SRC=\"/images/transparent.gif\" WIDTH=\"696\" HEIGHT=\"5\" ALT=\"\"></TD>
<TD ROWSPAN=\"6\" BGCOLOR=\"#000000\"><IMG SRC=\"/images/transparent.gif\" WIDTH=\"2\" HEIGHT=\"2\" ALT=\"\"></TD>
</TR>
<TR>
<TD ROWSPAN=\"3\"><IMG SRC=\"/images/transparent.gif\" WIDTH=\"5\" HEIGHT=\"5\" ALT=\"\"></TD>
<TD COLSPAN=\"2\" VALIGN=\"top\">
<!-- toplogo starter her! -->
<p align=\"center\"><img src=\"toplogo.jpg\" width=\"401\" height=\"75\"><br>
<font size=\"2\" face=\"verdana, arial, helvetica\">[<a href=\"information.asp\">Information</a>] -
[<a href=\"data.asp\">Indstillinger</a>] - [<a href=\"annoncer.asp\">Annoncer</a>] -
[<a href=\"forum.asp\">Debat</a><a href=\"annoncer.asp\"></a>] - [<a href=\"udgivelser.asp\">Udgivelser</a>] -
[<a href=\"logout.asp\">Log ud</a>]<br> </font></p>
</TD>
<TD ROWSPAN=\"3\"><IMG SRC=\"/images/transparent.gif\" WIDTH=\"5\" HEIGHT=\"5\" ALT=\"\"></TD>
</TR>
<TR VALIGN=\"top\">
<TD width=\"100%\">
<FONT FACE=\"Verdana,Arial,Helvetica\" SIZE=\"1\" COLOR=\"#000000\">
<FONT FACE=\"Verdana,Arial,Helvetica\" SIZE=\"2\" COLOR=\"#000000\">
<p align=\"center\">
<table align=\"center\" border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"5\" height=\"100%\">
<tr> <td width=\"160\" valign=\"top\">
<table class=\"tyndramme\" border=\"0\" cellpadding=\"10\" width=\"150\" bgcolor=\"lightyellow\">
<tr>
<TD VALIGN=\"top\"><font face=\"Verdana, Arial, Helvetica\" size=\"1\">
<b>Ekspertspørgsmål, November 2001:</b>
<p>
I hvilken Carl Barks-historie har Rip, Rap eller Rup knækket Hexia de Tricks tryllestav? Der skal mindst svares med historiekode og titel.
</p>
<p align=\"center\">
<a href=\"ekspert/alle.html#nov2001\"><img src=\"pic0005.jpg\" border=\"0\" style=\"border-color:black;\" width=\"120\" height=\"86\"></a>
</p>
<p>
Indsend dit svar på <a href=\"mailto:shaagerup@hotmail.com\">shaagerup@ hotmail.com</a>
</p>
<p align=\"right\"><b>Se gamle opgaver</b>
<font face=\"Verdana, Arial, Helvetica\" size=\"1\">
<a href=\"vote/alle.html\"><img src=\"pil.gif\" border=\"0\" width=\"8\" height=\"9\"></a></font></p>
<p align=\"center\"><a target=\"_blank\" href=\"http://www.chart.dk/ref.asp?id=5618\"><img alt=\"chart.dk\" border=\"0\" src=\"http://cluster.chart.dk/chart.asp?id=5618&style=7\"></a></p>
</font>
</td>
</tr>
</table>
</td>
</font></font>
<td valign=\"top\">
<table class=\"tyndramme\" border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"5\"><tr><td>
<p align=\"left\">
<FONT FACE=\"Verdana, Arial, Helvetica\" size=\"2\" color=\"#000000\">
<b>Opret bruger:</b></font></p>
<p align=\"left\">
<div align=\"center\"><center><table border=\"0\" cellpadding=\"2\"
cellspacing=\"0\" width=\"90%\">
<tr>
<td align=\"left\" width=\"40%\" valign=\"top\"><font size=\"2\" face=\"Verdana\">Brugernavn:</font></td>
<td colspan=\"2\" width=\"60%\"><INPUT TYPE=\"text\" NAME=\"bnavn\" size=\"20\"></td>
</tr>
<tr>
<td align=\"left\" width=\"40%\" valign=\"top\"><font size=\"2\" face=\"Verdana\">Password</font></td>
<td colspan=\"2\" width=\"60%\"><INPUT TYPE=\"text\" NAME=\"pas\" size=\"20\"></td>
</tr>
<tr>
<td align=\"left\" width=\"20%\" valign=\"top\"><font size=\"2\" face=\"Verdana\">Rigtig
Navn:</font></td>
<td colspan=\"2\" width=\"80%\"><INPUT TYPE=\"text\" NAME=\"rnavn\" size=\"20\"></td>
</tr>
<tr>
<td align=\"Left\" valign=\"top\" width=\"20%\"><font size=\"2\" face=\"Verdana\">E-mail:</font></td>
<td valign=\"top\" width=\"80%\">
<INPUT TYPE=\"text\" NAME=\"email\" size=\"20\">
</td>
</tr>
<tr>
<td width=\"20%\"></td>
<td colspan=\"2\" width=\"80%\"><input type=\"submit\"
name=\"B1\" value=\"Tilføj\"> <INPUT TYPE=\"reset\" NAME=\"Slet\"></td>
</tr>
</table>
</center></div>
</form>
<p align=\"center\"><a href=\"godkendt.asp\"><font size=\"2\" face=\"Verdana\">Forside</font></a></p></td></tr></table>
</td>
<FONT FACE=\"Verdana,Arial,Helvetica\" SIZE=\"1\" COLOR=\"#000000\">
<FONT FACE=\"Verdana,Arial,Helvetica\" SIZE=\"2\" COLOR=\"#000000\">
<td width=\"160\" valign=\"top\"><script language=\"javascript\"
src=\"http://www.chart.dk/vote.asp?id=1885\"></script><br>
<table class=\"tyndramme\" border=\"0\" cellpadding=\"10\" width=\"150\" bgcolor=\"lightyellow\">
<tr>
<TD VALIGN=\"top\"><font face=\"Verdana, Arial, Helvetica\" size=\"1\">
<p align=\"right\"><b>Afstemninger</b> <a href=\"vote/alle.html\"><img src=\"pil.gif\" border=\"0\" width=\"8\" height=\"9\"></a></p>
</font>
</td>
</tr>
</table>
<br>
<table class=\"tyndramme\" border=\"0\" cellpadding=\"10\" width=\"150\" bgcolor=\"lightyellow\">
<tr>
<TD VALIGN=\"top\"><font face=\"Verdana, Arial, Helvetica\" size=\"1\">
<b>Ekspertspørgsmål, November 2001:</b>
<p>
I hvilken Carl Barks-historie har Rip, Rap eller Rup knækket Hexia de Tricks tryllestav? Der skal mindst svares med historiekode og titel.
</p>
<p align=\"center\">
<font face=\"Verdana, Arial, Helvetica\" size=\"1\"><a href=\"ekspert/alle.html#nov2001\"><img src=\"pic0005.jpg\" border=\"0\" style=\"border-color:black;\" width=\"120\" height=\"86\"></a>
</font>
</p>
<p>
Indsend dit svar på <a href=\"mailto:shaagerup@hotmail.com\">shaagerup@ hotmail.com</a>
</p>
<p align=\"right\"><b>Se gamle opgaver</b>
<font face=\"Verdana, Arial, Helvetica\" size=\"1\">
<a href=\"vote/alle.html\"><img src=\"pil.gif\" border=\"0\" width=\"8\" height=\"9\"></a></font></p>
<p align=\"center\"><a target=\"_blank\" href=\"http://www.chart.dk/ref.asp?id=5618\"><img alt=\"chart.dk\" border=\"0\" src=\"http://cluster.chart.dk/chart.asp?id=5618&style=7\"></a></p>
</font>
</td>
</tr>
</table>
</td>
</tr>
</table>
<p>
<center><hr size=\"1\" width=\"545\" noshade><font face=\"verdana\" size=\"1\" color=\"gray\">
Copyright © 1999 - 2001 <b>The Donald Duck Club</b><br>Hel eller delvis gengivelse kun tilladt med tydelig kildeangivelse<br>Alle billeder af Disneys produkter og/eller figurer er <b>© Walt Disney Company.</center>
</FONT>
</TD>
</TR>
<TR>
<TD COLSPAN=\"4\"><IMG SRC=\"/images/transparent.gif\" WIDTH=\"5\" HEIGHT=\"5\" ALT=\"\"></TD>
</TR>
<TR>
<TD COLSPAN=\"5\" BGCOLOR=\"#000000\"><IMG SRC=\"/images/transparent.gif\" WIDTH=\"2\" HEIGHT=\"2\" ALT=\"\"></TD>
</TR>
</TABLE>
</TD></TR>
</TABLE>
</BODY>
</HTML>
-------------------------------------
--------------opret_data.asp----------
<%
Const adOpenKeyset = 1
Const adLockOptimistic = 3
Set Conn = Server.CreateObject(\"ADODB.Connection\")
Conn.Open \"PROVIDER=MSDASQL;DRIVER={Microsoft Access Driver (*.mdb)};DBQ=\" & Server.MapPath(\"http://www.friserverplads.dk/donaldduckclub/ddc-asp2/adgangskontrol.mdb\") & \";UID=admin;PWD=;\"
Set rs = Server.CreateObject(\"ADODB.RecordSet\")
strSQL = \"Select * From users\"
rs.Open strSQL, Conn, adOpenKeyset, adLockOptimistic
rs.AddNew
rs(\"Username\") = Request.form(\"bnavn\")
rs(\"Password\") = Request.form(\"pas\")
rs(\"RealName\") = Request.form(\"rnavn\")
rs(\"Email\") = Request.form(\"email\")
rs.Update
rs.Close
Set rs = Nothing
Conn.Close
set Conn = Nothing
%>
<html>
<head>
<META HTTP-EQUIV=\"Refresh\" CONTENT=\"5;URL=godkendt.asp\">
</style>
</head>
<BODY bgcolor=\"#008080\" text=\"#FFFF00\" link=\"#800000\" vlink=\"#800000\" alink=\"#800000\" topmargin=\"10\" leftmargin=\"0\"
rightmargin=\"0\">
<center><FONT FACE=\"Arial\" SIZE=\"+2\">Du kan nu benytte admin Funktionen.</FONT></center>
</body>
</html>
-----------------------------------------
Og så har jeg selvfølgelig en access-database, som indeholder flg. tabeller:
RealName
Username
Password
... hvad er der galt?
Hvis nogen kan hjælpe mig, er der 200 points på højkant! ;-)
/Cliecard
