Lav felterne om så jeg kan rette indholdet.

sådan: ?

<form action="update.asp" id="form_tech">
<%
strSQL = "Select * from fault where F_ID = " & request.querystring("f_id")
set rs = conn.execute(strsql)
%>
<TABLE>
    <tr>
      <td>ID: <input name="f_id" type="text" value="<%=rs("F_ID")%>"></td><br>
      <td>Tech. Responsible: <input name="TechResponsible" type="text" value="<%=rs("TechResponsible")%>"></td><br>
      <td>Date in:  <input name="Datein" type="text" value="<%=rs("Datein")%>"></td><br>
      <td>PC Name:  <input name="PC_Name" type="text" value="<%=rs("PC_Name")%>"></td><br>
      <td>Date startet:  <input name="Datestart" type="text" value="<%=rs("Datestart")%>"></td><br>
      <td>Problem:  <input name="Problem" type="text" value="<%=rs("Problem")%>"></td><br>
      <td>Solution:  <input name="Solution" type="text" value="<%=rs("Solution")%>"></td><br>
      <td>Tech on task:  <input name="Technician" type="text" value="<%=rs("Technician")%>"></td><br>
      <td>Date Finished:  <input name="Dateend" type="text" value="<%=rs("Dateend")%>"></td><br>
    </tr>
    </table>
    <br><input type="submit" value="Edit" name="B1">
</form>
<br><a href = "index.asp">Back</a>

dsjk

Når jeg trykker på Knappen opdaterer den bare med det som stod der.. der skal åbenbart være en SQL til UPDATE felterne??

Jeg har nu forsøgt dette:

*details.asp*
<form method="POST" action="update.asp">
<%
strSQL = "Select * from fault where F_ID = " & request.querystring("f_id")
set rs = conn.execute(strsql)
%>
<TABLE>
    <tr>
      <td>ID: <input name="f_id" type="text" value="<%=rs("F_ID")%>" size="20"></td><br>
      <td>Tech. Responsible:
      <input name="TechResponsible" type="text" value="<%=rs("TechResponsible")%>" size="20"></td><br>
      <td>Date in: 
      <input name="Datein" type="text" value="<%=rs("Datein")%>" size="20"></td><br>
      <td>PC Name: 
      <input name="PC_Name" type="text" value="<%=rs("PC_Name")%>" size="20"></td><br>
      <td>Date startet: 
      <input name="Datestart" type="text" value="<%=rs("Datestart")%>" size="20"></td><br>
      <td>Problem: 
      <input name="Problem" type="text" value="<%=rs("Problem")%>" size="20"></td><br>
      <td>Solution: 
      <input name="Solution" type="text" value="<%=rs("Solution")%>" size="20"></td><br>
      <td>Tech on task: 
      <input name="Technician" type="text" value="<%=rs("Technician")%>" size="20"></td><br>
      <td>Date Finished: 
      <input name="Dateend" type="text" value="<%=rs("Dateend")%>" size="20"></td><br>
    </tr>
    </table>
    <br><input type="submit" value="Edit" name="B1">
</form>


*Update.asp*
<% strSQL = "UPDATE Fault SET (techresponsible, datein, PC_Name, datestart, problem, solution, technician, dateend) VALUES " _
& "('" & Request.Form("techresponsible") & "', " _
& "'"  & Request.Form("datein") & "', " _
& "'"  & Request.Form("PC_Name") & "', " _
& "'"  & Request.Form("datestart") & "', " _
& "'"  & Request.Form("problem") & "'," _
& "'"  & Request.Form("solution") & "', " _
& "'"  & Request.Form("technician") & "', " _
& "'"  & Request.Form("dateend") & "')"

Conn.Execute strSQL

Response.Write "Databasen er opdateret!"
%>

Får en intern 500 fejl.. F_ID er et unikt autonummer felt..

Jeg har desværre ikke haft tid til at kigge på det før nu.
Det du har lavet er næsten rigtig, dog skal update.asp lige rettes til:
<% strSQL = "UPDATE Fault SET "
strSQL = strSQL & "techresponsible='" & Request.Form("techresponsible") & "', "
strSQL = strSQL & "datein='" & Request.Form("datein") & "', "
strSQL = strSQL & "PC_Name='" & Request.Form("PC_Name") & "', "
strSQL = strSQL & "datestart='" & Request.Form("datestart") & "', "
strSQL = strSQL & "problem='" & Request.Form("problem") & "', "
strSQL = strSQL & "solution='" & Request.Form("solution") & "', "
strSQL = strSQL & "technician='" & Request.Form("technician") & "', "
strSQL = strSQL & "dateend='" & Request.Form("dateend") & "' "
strSQL = strSQL & "WHERE (F_ID = " & request.form("f_id") & ")"

Conn.Execute strSQL

Response.Write "Databasen er opdateret!"
%>

så skulle der gerne virke

dsjk

Det virkede sq... en grøn i det her..

såå takker...

selv tak :O)