update sql
Hey EHvad skal jeg skrive i UPDATE kode for opdatere en db, ud fra denne form-opsætning? Formen er fint udfyldt fra db'en. Jeg mangler at lave en "dynamisk" UPDATE SQL.
<body onunload="opener.location.reload(true);">
<% if mode = "edit" Then
If Request.ServerVariables("REQUEST_METHOD") = "POST" Then
hvilken = request.querystring("id")
HVAD SKAL DER STÅ HER?
%>
<!-- <script type="text/JavaScript">window.close()</script> -->
<% else 'post
if request.QueryString("id") <> "" then
hvilken = request.querystring("id")%>
<div class="left">
<form action="default.asp?mode=edit&id=<%=hvilken%>" method="post">
<table>
<% Dim tal
rs_select_1(3) 'start db
for each x in rs.fields
if x.name <> "aircraft_id" then
DBName = DBName & (x.value) & ";"
tal = tal + 1
end if
next
rs_end() 'end db
DBName = Split(DBName,";")%>
<table style="position:absolute; top:5px; left:0px;">
<% for a = 0 to tal %>
<tr height="22px">
<td><%=DBName(a)%></td>
</tr>
<% next %>
</table>
<table style="position:absolute; top:5px; left:81px;">
<% rs_select_x(hvilken) 'start db
for each x in rs.fields
if x.name <> "aircraft_id" then%>
<tr>
<td><input type="text" value="<%=x.value%>" name="<%=x.name%>" style="width:260px;"></td>
</tr>
<%end if
next
rs_end()%>
<tr>
<td colspan="2" align="right"><input type="submit" value="Update" style="height:18px;"></td>
</tr>
</table>
</form>
</div>
<% end if 'id
end if 'post
end if%>
</body>
