Opdatere database
Kan nogen hjälp mig :-)Jeg vil gerne opdatere min database men ved ikke rigtigt hvad jeg gör forkert.
Er nystartet med Asp
--------
<%
Set ObjConn=Server.CreateObject("ADODB.Connection")
ObjConn.ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source='"&Server.MapPath("data/data.mdb")&"'"
ObjConn.Open
%>
<%
If Request.QueryString("val") = "Spara" Then
SQL = "Insert Into * FROM start Where 1=2"
Set RS=ObjConn.Execute(SQL)
%>
<form name="spara" method="post" action="index.asp?val=spara">
<table border="0" cellspacing="0" width="100%">
<tr>
<td width="35%" valign="top"><img border="0" src="pictures/bild_start.jpg" width="232" height="422"></td>
<td width="65%" valign="top"><input type="text" name="overskrift" size="42" value="<%=RS("overskrift")%>"><br><br><%=RS("text")%><br><br><input type="submit" name="Spara" value="Spara">Spara</td>
</tr>
</table>
</form>
<%Else
If Request.QueryString("val") = "redigera" Then
SQL = "SELECT * FROM start"
Set RS=ObjConn.Execute(SQL)
%>
<table border="0" cellspacing="0" width="100%">
<tr>
<td width="35%" valign="top"><img border="0" src="pictures/bild_start.jpg" width="232" height="422"></td>
<td width="65%" valign="top"><input type="text" name="overskrift" size="42" value="<%=RS("overskrift")%>"><br><br><%=RS("text")%><br><br><a href="index.asp?val=spara">Spara</a></td>
</tr>
</table>
<%Else
If Request.QueryString("") = "" Then
SQL="SELECT * FROM start"
Set RS=ObjConn.Execute(SQL)
%>
<table border="0" cellspacing="0" width="100%">
<tr>
<td width="35%" valign="top"><img border="0" src="pictures/bild_start.jpg" width="232" height="422"></td>
<td width="65%" valign="top"><%=RS("overskrift")%><br><br><%=RS("text")%><br><br><a href="index.asp?val=redigera">Ändra</a></td>
</tr>
</table>
<%End If%>
<%End If%>
<%End If%>
