Fejl når jeg prøver at opdatere database
Jeg får følgende fejl når jeg prøver at opdatere min database."syntax error in update statement"
- Har det noget at gøre med at mine tabelnavne er forkerte?
Jeg er ikke den store ASP / Access haj, men ved dog at der er nogle ord man ikke må bruge i navnene på ens felter.
<%
dim id
dim action
id = request.querystring("id")
action = request.querystring("action")
select case action
case 1
Query="SELECT * FROM medlemmer WHERE ID = " & id
Set Res = DBC.Execute(Query)
%>
<form action="member_action.asp?id=<%=id%>&action=2" method="POST" name="ret">
<table width="500" border="0" cellspacing="0" cellpadding="0" bgcolor="#ffffff" bordercolor="#000000">
<tr bgcolor="#FFFFFF">
<td height="10" colspan="2" align="left"><font color="#000000"></font></td>
</tr>
<TR bgcolor="#FFFFFF">
<td colspan="2" class="txt12blackbold"><font size="1" face="Verdana, Arial, Helvetica, sans-serif" color="#000000"><b>RET
NYHED</b></font></td>
</TR>
<tr bgcolor="#FFFFFF">
<td height="10" colspan="2" align="left"><font size="1" face="Verdana, Arial, Helvetica, sans-serif" color="#000000"></font></td>
<TR bgcolor="#FFFFFF" valign="top">
<td width="100" align="left" class="txt10blackbold"><font size="1" face="Verdana, Arial, Helvetica, sans-serif" color="#000000">Overskrift</font></td>
<TD> <font size="1" face="Verdana, Arial, Helvetica, sans-serif" color="#000000">
<INPUT class="field30" NAME="nickfo" VALUE="<%=Res("nick") %>" TYPE="Text" size="40" >
</font></TD>
</TR>
<TR bgcolor="#FFFFFF" valign="top">
<td class="txt10blackbold"><font size="1" face="Verdana, Arial, Helvetica, sans-serif" color="#000000">Dato</font></td>
<TD><font size="1" face="Verdana, Arial, Helvetica, sans-serif" color="#000000">
<INPUT class="field480" NAME="byfo" VALUE="<%=Res("by")%>" TYPE="Text" SIZE=40 >
<font color="#FF0000"> </font></font></TD>
</TR>
<tr bgcolor="#FFFFFF" valign="top">
<td class="txt10blackbold"><font size="1" face="Verdana, Arial, Helvetica, sans-serif" color="#000000">Dit
navn </font></td>
<td><font size="1" face="Verdana, Arial, Helvetica, sans-serif" color="#000000">
<input class="field480" name="alderfo" value="<%=Res("alder")%>" type="Text" size=40 >
</font></td>
</tr>
<tr bgcolor="#FFFFFF" valign="top">
<td class="txt10blackbold" height="16"><font size="1" face="Verdana, Arial, Helvetica, sans-serif" color="#000000">Tekst</font></td>
<td height="16"><font size="1" face="Verdana, Arial, Helvetica, sans-serif" color="#000000">
<input type="text" class="field480" name="tlffo" size="40" value="<%=Res("tlf")%>">
</font></td>
</tr>
<tr bgcolor="#FFFFFF" valign="top">
<td class="txt10blackbold"><font size="1" face="Verdana, Arial, Helvetica, sans-serif" color="#000000">Billednavn</font></td>
<td><font size="1" face="Verdana, Arial, Helvetica, sans-serif" color="#000000">
<input class="field480" name="icefo" value="<%=Res("ice")%>" type="Text" size=40 >
</font></td>
</tr>
<tr bgcolor="#FFFFFF" valign="top">
<td class="txt10blackbold"><font face="Verdana, Arial, Helvetica, sans-serif" size="1" color="#000000">Pris
15'</font></td>
<td><font size="1" face="Verdana, Arial, Helvetica, sans-serif" color="#000000">
<input class="field480" name="emailfo" value="<%=Res("email")%>" type="Text" size=40 >
</font></td>
</tr>
<tr bgcolor="#FFFFFF" valign="top">
<td class="txt10blackbold"><font size="1" face="Verdana, Arial, Helvetica, sans-serif" color="#000000">Pris
16' </font></td>
<td><font size="1" face="Verdana, Arial, Helvetica, sans-serif" color="#000000">
<input class="field480" name="realfo" value="<%=Res("real")%>" type="Text" size=40 >
<font color="#FF0000"> </font></font></td>
</tr>
<tr bgcolor="#FFFFFF" valign="top">
<td class="txt10blackbold"><font size="1" face="Verdana, Arial, Helvetica, sans-serif" color="#000000">Pris
17' </font></td>
<td><font size="1" face="Verdana, Arial, Helvetica, sans-serif" color="#000000">
<input class="field480" name="weaponfo" value="<%=Res("weapon")%>" type="Text" size=40 >
</font></td>
</tr>
<tr bgcolor="#FFFFFF" valign="top">
<td class="txt10blackbold"><font size="1" face="Verdana, Arial, Helvetica, sans-serif" color="#000000">Pris
18' </font></td>
<td><font size="1" face="Verdana, Arial, Helvetica, sans-serif" color="#000000">
<input class="field480" name="mapfo" value="<%=Res("map")%>" type="Text" size=40 >
</font></td>
</tr>
<tr bgcolor="#FFFFFF" valign="top">
<td class="txt10blackbold"><font size="1" face="Verdana, Arial, Helvetica, sans-serif" color="#000000">Pris
19' </font></td>
<td><font size="1" face="Verdana, Arial, Helvetica, sans-serif" color="#000000">
<input class="field480" name="quotefo" value="<%=Res("quote")%>" type="Text" size=40 >
<font color="#FF0000"> </font></font></td>
</tr>
<tr bgcolor="#FFFFFF" valign="top">
<td class="txt10blackbold"><font size="1" face="Verdana, Arial, Helvetica, sans-serif" color="#000000">Pris
19' </font></td>
<td><font size="1" face="Verdana, Arial, Helvetica, sans-serif" color="#000000">
<input class="field480" name="billedefo" value="<%=Res("billede")%>" type="Text" size=40 >
</font></td>
</tr>
<tr bgcolor="#FFFFFF" valign="top">
<td class="txt10blackbold" colspan="2"><br>
</td>
</tr>
<TR bgcolor="#FFFFFF">
<td height="40" colspan="2" align="center" valign="middle">
<div align="left"> <font color="#000000">
<input class="button" type="submit" value=" Send Rettelse " >
<BR>
</font></div>
</td>
</TR></FORM>
</TABLE>
<br>
<%
case 2
query = "update m8s set nick='"&request.form("nickfo")&"',by='"&request.form("byfo")&"',alder='"&request.form("alderfo")&"',tlf='"&request.form("tlffo")&"',ice='"&request.form("icefo")&"',email='"&request.form("emailfo")&"',real='"&request.form("realfo")&"',weapon='"&request.form("weaponfo")&"',map='"&request.form("mapfo")&"',quote='"&request.form("quotefo")&"',billede='"&request.form("billedefo")&"' WHERE ID=" & id
DBC.execute(Query)
response.write("Nyheden er rettet <a href=newslist.asp>Gå tilbage her</a>")
case 3
query = "delete from news where ID = " & id
DBC.Execute(query)
Response.write("Nyheden er slettet <a href=newslist.asp>Gå tilbage her</a> ")
case 4
%>
