SQL-update
Jeg skal opdatere nogle poster i en access-db, vha. en form...Jeg har kopieret mit INSERT INTo-script, men får fejl i SQL-sætningen når jeg har udskiftet INSERT med UPDATE.
Koden ser således ud:
<%
Set Conn = Server.CreateObject("ADODB.Connection")
Set RS = Server.CreateObject("ADODB.RecordSet")
conn.Open "DBQ="&(Server.MapPath(".")) &"\ar.mdb; DefaultDir=DBQ="&(Server.MapPath(".")) &"\;Driver={Microsoft Access Driver (*.mdb)};"
if request("password") = "test" then
session("login") = "ok"
end if
%>
<title>Arrangementet er nu blevet tilføjet</title>
<%
if request("mode") = "1" then
SQL = "UPDATE Tabel1 ( Id, Overskrift, Ugedag, Dato, Klokken, Entre, Txt ) values ('" & request("Id") & "', '" & request("Overskrift") & "', '" & request("Ugedag") & "', '" & request("Dato") & "', '" & request("Klokken") & "', '" & request("Entre") & "', '" & request("Txt") & "')"
conn.execute (SQL)
SQL = "SELECT * from Tabel1"
RS.Open SQL, Conn, 3, 3
On Error Resume Next
RS.MoveFirst
Do While NOT RS.EOF
EML = RS("Email")
If EML = request("EMail") Then
Exit Do
End If
RS.MoveNext
Loop
response.write "<body bgcolor='557594' link='C0C0C0' vlink='C0C0C0' alink='808080'>"
response.write "<FONT COLOR='ffffff' SIZE='4' FACE='Tahoma,Verdana,Arial,Helvetica'>"
response.write "<BR><STRONG><CENTER>Arrangmentet er nu blevet tilføjet til UKH-ARRANGEMENT databasen.<BR><BR><I>Arrangementet har id-værdien: </I> <FONT COLOR='Red'>" & RS("id") & "<br><br>" & "<a href=admin2.asp?mode=list" & ">" & "Tilbage" & "</CENTER></STRONG></FONT>"
else
%>
<CENTER>
<TABLE BORDER="0" CELLSPACING="0" CELLPADDING="2">
<TR>
<TD COLSPAN="2" ALIGN="CENTER">
<FONT FACE="Arial" SIZE="2" COLOR="#000000">
<STRONG>Tilføj arrangement til UKH-ARRANGEMENT</A></STRONG>
</FONT>
</TD>
</TR>
<form action="tilfoj2.asp" METHOD="POST">
<input type="hidden" name="mode" VALUE="1"><br>
<TR>
<TD>
<STRONG>
<FONT FACE="Arial" SIZE="3" COLOR="#000000">
Id:
</FONT>
</STRONG>
</TD>
<TD>
<input type="text" name="Id" size="40"><br>
</TD>
</TR>
<TR>
<TD>
<STRONG>
<FONT FACE="Arial" SIZE="3" COLOR="#000000">
Overskrift:
</FONT>
</STRONG>
</TD>
<TD>
<input type="text" name="Overskrift" size="40"><br>
</TD>
</TR>
<TR>
<TD>
<STRONG>
<FONT FACE="Arial" SIZE="3" COLOR="#000000">
Ugedag:
</FONT>
</STRONG>
</TD>
<TD>
<input type="text" name="Ugedag" size="40"><br>
</TD>
</TR>
<TR>
<TD>
<STRONG>
<FONT FACE="Arial" SIZE="3" COLOR="#000000">
Dato:
</FONT>
</STRONG>
</TD>
<TD>
<input type="text" name="Dato" size="40"><br>
</TD>
</TR>
<TR>
<TD>
<STRONG>
<FONT FACE="Arial" SIZE="3" COLOR="#000000">
Klokken:
</FONT>
</STRONG>
</TD>
<TD>
<input type="text" name="Klokken" size="40"><br>
</TD>
</TR>
<TR>
<TD>
<STRONG>
<FONT FACE="Arial" SIZE="3" COLOR="#000000">
Entre:
</FONT>
</STRONG>
</TD>
<TD>
<input type="text" name="Entre" size="40"><br>
</TD>
</TR>
<TR>
<TD>
<STRONG>
<FONT FACE="Arial" SIZE="3" COLOR="#000000">
Yderligere info:
</FONT>
</STRONG>
</TD>
<TD>
<input type="text" name="Txt" size="40"><br>
</TD>
</TR>
<TR>
</TR>
<TR>
<TD VALIGN="TOP">
</TD>
<TD ALIGN="RIGHT">
<input type="submit" value="-- Tilføj arrangement --">
</TD>
</TR>
</form>
</TABLE>
<FORM NAME="login" METHOD="post">
<INPUT TYPE="password" NAME="password">
<input type="submit" value="-- Login --">
</FORM>
<% conn.close
end if
%>
</BODY>
</HTML>
Håber der er nogen der kan hjælpe...
