Insert into virker ikke
Når jeg prøver at oprette et nyt medlem, aå opretter den ganske vist felterne, men de er bare tomme, når de skal vises.Her er koden:
<form action="member_action.asp?action=5" method="POST" name="opret">
<table width="500" border="0" cellspacing="0" cellpadding="0" bgcolor="#FFFFFF">
<tr bgcolor="#FFFFFF">
<td height="10" colspan="2" align="left"></td>
</tr>
<TR bgcolor="#FFFFFF">
<td colspan="2" class="txt12blackbold"><font face="Verdana, Arial, Helvetica, sans-serif" size="1"><b>NYT
MEDLEM</b></font></td>
</TR>
<tr bgcolor="#FFFFFF">
<td height="10" colspan="2" align="left"><font face="Verdana, Arial, Helvetica, sans-serif" size="1"></font></td>
<TR bgcolor="#FFFFFF" valign="top">
<td width="100" align="left" class="txt10blackbold" bordercolor="#000000"><font size="1" face="Verdana, Arial, Helvetica, sans-serif" color="#000000">Nick:</font></td>
<TD> <font face="Verdana, Arial, Helvetica, sans-serif" size="1">
<INPUT class="field30" NAME="ovs1" TYPE="Text" size="40" >
</font></TD>
</TR>
<TR bgcolor="#FFFFFF" valign="top">
<td class="txt10blackbold" bordercolor="#000000"><font size="1" face="Verdana, Arial, Helvetica, sans-serif" color="#000000">By:</font></td>
<TD> <font face="Verdana, Arial, Helvetica, sans-serif" size="1">
<INPUT class="field480" NAME="dato1" TYPE="Text" SIZE=40 >
</font></TD>
</TR>
<tr valign="top">
<td class="txt10blackbold" bordercolor="#000000"><font size="1" face="Verdana, Arial, Helvetica, sans-serif" color="#000000">Alder:</font></td>
<td> <font face="Verdana, Arial, Helvetica, sans-serif" size="1">
<input class="field480" name="ini1" type="Text" size=40 >
</font></td>
</tr>
<tr valign="top">
<td class="txt10blackbold" height="16" bordercolor="#000000"><font size="1" face="Verdana, Arial, Helvetica, sans-serif" color="#000000">Tlf:</font></td>
<td height="16"> <font face="Verdana, Arial, Helvetica, sans-serif" size="1">
<input type="text" class="field480" name="txt" size="40" value="">
</font></td>
</tr>
<tr valign="top">
<td class="txt10blackbold" bordercolor="#000000"><font size="1" face="Verdana, Arial, Helvetica, sans-serif" color="#000000">ICQ:</font></td>
<td> <font face="Verdana, Arial, Helvetica, sans-serif" size="1">
<input class="field480" name="img1" type="Text" size=40 >
</font></td>
</tr>
<tr valign="top">
<td class="txt10blackbold" bordercolor="#000000"><font face="Verdana, Arial, Helvetica, sans-serif" size="1" color="#000000">Email:</font></td>
<td> <font face="Verdana, Arial, Helvetica, sans-serif" size="1">
<input class="field480" name="pris15" type="Text" size=40 >
</font></td>
</tr>
<tr valign="top">
<td class="txt10blackbold" bordercolor="#000000"><font face="Verdana, Arial, Helvetica, sans-serif" size="1" color="#000000">Rigtig
navn: </font></td>
<td> <font face="Verdana, Arial, Helvetica, sans-serif" size="1">
<input class="field480" name="pris16" type="Text" size=40 >
</font><font size="1" face="Verdana, Arial, Helvetica, sans-serif" color="#000000"></font></td>
</tr>
<tr valign="top">
<td class="txt10blackbold" bordercolor="#000000"><font size="1" face="Verdana, Arial, Helvetica, sans-serif" color="#000000">Våben:</font></td>
<td> <font face="Verdana, Arial, Helvetica, sans-serif" size="1">
<input class="field480" name="pris17" type="Text" size=40 >
</font><font size="1" face="Verdana, Arial, Helvetica, sans-serif" color="#000000"></font></td>
</tr>
<tr valign="top">
<td class="txt10blackbold" bordercolor="#000000"><font size="1" face="Verdana, Arial, Helvetica, sans-serif" color="#000000">Map:</font></td>
<td> <font face="Verdana, Arial, Helvetica, sans-serif" size="1">
<input class="field480" name="pris18" type="Text" size=40 >
</font></td>
</tr>
<tr valign="top">
<td class="txt10blackbold" bordercolor="#000000"><font size="1" face="Verdana, Arial, Helvetica, sans-serif" color="#000000">Quote:</font></td>
<td> <font face="Verdana, Arial, Helvetica, sans-serif" size="1">
<input class="field480" name="pris19" type="Text" size=40 >
</font><font size="1" face="Verdana, Arial, Helvetica, sans-serif" color="#000000">
<font color="#FF0000"> </font></font></td>
</tr>
<tr valign="top">
<td class="txt10blackbold" bordercolor="#000000"><font size="1" face="Verdana, Arial, Helvetica, sans-serif" color="#000000">Billednavn:</font></td>
<td> <font face="Verdana, Arial, Helvetica, sans-serif" size="1">
<input class="field480" name="pris19" type="Text" size=40 >
</font><font size="1" face="Verdana, Arial, Helvetica, sans-serif" color="#000000">
<font color="#FF0000"> </font></font></td>
</tr>
<tr valign="top">
<td class="txt10blackbold" colspan="2"> </td>
</tr>
<TR bgcolor="#FFFFFF">
<td height="40" colspan="2" align="center" valign="middle">
<div align="left">
<input class="button" type="submit" value="Opret" >
<BR>
</div>
</td>
</TR></FORM>
</TABLE>
<br>
<%
case 5
query = "insert into medlemmer (nick,city,alder,tlf,ice,email,irl,weapon,map,quote,billede) values ('"&request.form("nick1")&"','"&request.form("city1")&"','"&request.form("alder1")&"','"&request.form("tlf1")&"','"&request.form("ice1")&"','"&request.form("email1")&"','"&request.form("real1")&"','"&request.form("weapon1")&"','"&request.form("map1")&"','"&request.form("quote1")&"','"&request.form("billede1")&"')"
Response.Write Query
DBC.execute(Query)
Response.write("Profilen er oprettet <a href=member_list.asp>Gå tilbage her</a>")
case else
Response.write("Denne side kan ikke bruges denne måde")
end select
%>
