update + form + url = problem
Jeg har en form der skal opdatere en tuble i db. men når jeg trykker opdater, opdatere den ikke og skriver en forkert url i adresse-linien?!?!?Koden se sådan ud:
<%Dim ID,opslag
id=Request.QueryString("ID")
Set Connection = Server.CreateObject("ADODB.Connection")
Connection.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ="&Server.MapPath("/tennisklub/databaser/database.mdb")
if request.querystring("knap")<>"Ret" then
SQLstringK="SELECT * FROM aktivitet WHERE id="&id
SET opslag=Connection.Execute(SQLstringK)
else
SQLstringK="UPDATE aktivitet SET navn='"&Request.QueryString("navn")&"',
overskrift='"&Request.QueryString("overskrift")&"', tekst='"&Request.QueryString("tekst")&"' WHERE id="&id
Connection.Execute(SQLstringK)
response.buffer=true
response.clear
response.redirect "oversigt.asp"
response.end
end if
%>
<head>
<title>Ret Aktivitets kalender</title>
<link rel="stylesheet" href="../styles.css" type="text/css">
</head>
<body bgcolor="#FFFFFF" text="#000000" link="#006699" vlink="#006699" alink="#006699">
<p>
<table border="0" width="500" bgcolor="#ffffff" cellspacing="0s" cellpadding="0" align="center">
<tr>
<td width="100%" bgcolor="#FFFFFF" valign="top">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr bgcolor="#FFFFFF">
<td width="100%">
<font size="5">
<b>
<font face="Verdana, Arial, Helvetica, sans-serif">
Ret aktivitets kalender
</font>
</b>
</font>
</td>
<td align="right" valign="bottom" nowrap width="50%">
<div align="right"></div>
</td>
</tr>
</table>
</td>
</tr>
</table>
<table border='0' cellspacing='0' cellpadding='0' width='500' align="center" height="19">
<tr>
<td width='0' valign='top' bgcolor='#ffffff'><img src="images/intet.gif" width='0'></td>
<td width='500' valign='top' bgcolor='#ffffff'>
<table width="100%" border="0" cellspacing="0" cellpadding="0" height="17">
<tr>
<td width="50%">
<font face="Verdana, Arial, Helvetica, sans-serif">
<b>
<font size="2">
[
<a href="../portal.asp">
Forsiden
</a>
|
<a href="../aktivitetskalender.asp">
Vis Aktivitets kalender
</a>
|
<a href="portal.asp" target="_self">
Administrator forside
</a>
]
</font>
</b>
</font>
</td>
</tr>
</table>
</td>
</tr>
</table>
<table border="0" width="500" bgcolor="#ffffff" cellspacing="1" cellpadding="0" align="center">
<tr>
<td bgcolor="#FFFFFF" valign="top" colspan="2">
<div align="center"> <br>
<%if not opslag.eof then %>
<form method="GET" action="portal.asp?page=ret.asp?<%=request.servervariables("SCRIPT_NAME")%>">
<table width="400" border="0" cellspacing="1" cellpadding="3" class="bottom" align="center" bgcolor="#f7f7f7">
<tr>
<td width="134"><font size="2" face="tahoma">Tilføjet af<br>
<input type="text" name="navn" maxlength="100" class="bottom" value="<%=OPSLAG("navn")%>">
</font></td>
<td width="251"><font size="2" face="tahoma">overskrift<span class="rot"><br>
<input type="text" name="overskrift" maxlength="100" class="bottom" value="<%=OPSLAG("overskrift")%>">
</span></font></td>
</tr>
<tr>
<td colspan="2" height="167"><font size="2" face="tahoma"> Nyhed<span class="rot"><font color="#FFFFFF">
</font></span></font><font color="#FF0000" face="tahoma" size="2"><br>
</font> <font face="tahoma" size="2">
<textarea name="tekst" cols="50" rows="8" class="bottom"><%=OPSLAG("tekst")%></textarea>
</font></td>
</tr>
<tr>
<td colspan="2" height="4">
</span></font></td>
</tr>
</table>
<INPUT type="hidden" name="id" value="<%=opslag("id")%>">
<input type="submit" value="Ret" name="knap">
</form>
<%end if%>
<br>
</div>
</td>
</tr>
</table>
</body>
Jeg indkredset problemet til denne linie:
<form method="GET" action="portal.asp?page=ret.asp?<%=request.servervariables("SCRIPT_NAME")%>">
Hvad er der galt?
