Hvor er fejlen her ?
-------------- retcms.asp ....<%@LANGUAGE="VBScript"%>
<%
if session("login") = "" Then
Response.redirect("login.asp")
end if
%>
<!--#include file="connect.asp"-->
<%
Set data = Server.CreateObject ("ADODB.Recordset")
data.Open "SELECT * From cms Where id ="& Request.QueryString("id") &"", MyConn
%>
<HTML>
<HEAD>
<style type="text/css">
body {
background-color: #FFFFFF;
background-image: url("bg_img.gif");
background-repeat: no-repeat;
background-attachment: fixed;
}
</STYLE>
</HEAD>
<BODY>
<P>
<TABLE BORDER="0" CELLPADDING="2" CELLSPACING="1" WIDTH="100%">
<TR>
<TD WIDTH="62%" BGCOLOR="#D1CAA9" style="border:solid black 1px;">
<P ALIGN="RIGHT"><FONT FACE="Arial"><B>Velkommen til Weide.dk
<BR>
</B></FONT>
</TD>
<TD WIDTH="38%"> </TD>
</TR>
<TR>
<TD WIDTH="62%" style="border:solid black 1px;"><FONT SIZE="2" FACE="Arial">
<FORM ACTION="updatecms.asp?id=<% = data.Fields ("id")%>" METHOD="POST">
<TABLE BORDER="0" CELLPADDING="3" CELLSPACING="0" WIDTH="54%">
<TR>
<TD WIDTH="34%" BGCOLOR="#99CCFF" style="border-top;bottom:solid black 1px;">
<FONT SIZE="2" FACE="Arial"><I>Titel</I></FONT></TD>
<TD WIDTH="66%" BGCOLOR="#99CCFF"><INPUT TYPE="TEXT" VALUE="<% = data.Fields ("title")%>" NAME="title" SIZE="16"></TD>
</TR>
<TR>
<TD WIDTH="34%" BGCOLOR="#FFCC99"><FONT SIZE="2" FACE="Arial"><I>Indhold</I></FONT></TD>
<TD WIDTH="66%" BGCOLOR="#FFCC99"><INPUT TYPE="TEXT" VALUE="<% = data.Fields ("contxt")%>" NAME="contxt" SIZE="25"></TD>
</TR>
<TR>
<TD WIDTH="34%"><I> </I></TD>
<TD WIDTH="66%"><INPUT TYPE="SUBMIT" NAME="Submit" VALUE="Opdatér"></TD>
</TR>
</TABLE></TD>
<TD WIDTH="38%"> </TD>
</TR>
</TABLE>
</BODY>
</HTML>
----------- updatecms.asp ....
<%@LANGUAGE="VBScript"%>
<!--#include file="connect.asp"-->
<%
SQL = "UPDATE cms Set navn = '" & request.form("navn") & "', "
SQL = SQL & "navn = '" & request.form("title") & "', "
SQL = SQL & "contxt = '" & request.form("contxt") & "', "
SQL = SQL & "WHERE id = " & Request.QueryString("id")
Myconn.Execute(SQL)
Response.Redirect("admincms.asp")
%>
------------- fejlmelding ....
Microsoft JET Database Engine error '80040e14'
Syntax error in UPDATE statement.
/updatecms.asp, line 10
