kan ikke opdater min db
Jeg kan ikke opdater min db den sletter bare hvad jeg har lavet ..min filer set sådan ud:
<%
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & server.MapPath("dbs\db.mdb")
SQLstmt = "SELECT * FROM sponsors WHERE id = " & Request("id")
Conn.Execute (SQLstmt)
Set rs = conn.Execute(SQLstmt)
%>
<div align="left">
<table border="0" width="100%" height="204">
<tr>
<td width="20%" height="21"><%=rs("id")%></td>
<td height="21">AUTO</td>
</tr>
<tr><form method="POST" action="gem_ret_sponsors.asp?id=<%=rs("id")%>"> <td width="20%" height="25">Overskrift</td>
<td height="25">none </td>
</tr>
<tr>
<td width="20%" height="62">tekst</td>
<td height="62">
<p><textarea rows="20" name="Besked" cols="70"><%=rs("tekst")%></textarea></p>
</td>
</tr>
<tr>
<td width="20%" valign="top" align="left" height="27"></td>
<td height="27">
<p><input type="submit"></p>
</td>
</tr>
</table>
</form>
</div>
<%
conn.Close
Set conn = nothing
Set SQLstmt = nothing
%>
og den anden
<%
response.buffer = true
link = request.form("link")
if link = "" then link = 0
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>Ny side 2</title>
</head>
<body>
<%
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & server.MapPath("dbs\db.mdb")
SQLstmt = "UPDATE DISTINCTROW news SET Besked= '" & request.form("besked") & "', dato = #" & Now & "#, Forfatter = '" & request.form("Forfatter") & "', overskrift = '" & request.form("overskrift") & "', link = '" & request.form("link") & "' WHERE id = " & Request("id")
'SQLstmt = SQLstmt & " VALUES (" & request.form("besked") & ",#" & Now & "#,'" & request.form("Forfatter") & "','" & request.form("Overskrift") & "'," & request.form("link") & ")"
'response.write SQLstmt
Conn.Execute (SQLstmt)
conn.Close
Set conn = nothing
Set SQLstmt = nothing
response.redirect ("admin.asp")
%>
</body>
</html>
nogen der kan se fejlen?
