Hej til thesurfer og keyseroze.
Jeg forstår udemærket dit eksempel keysersoze, men tror dog alligevel jeg vil følge thesurfers råd og give et eksempel :-)
Dette er de filer jeg har til at opdaterer en enkelt post:
update_entry.asp
<%
'Dimension variables
Dim adoCon 'Holds the Database Connection Object
Dim rsUpdateEntry 'Holds the recordset for the record to be updated
Dim strSQL 'Holds the SQL query for the database
Dim lngRecordNo 'Holds the record number to be updated
'Read in the record number to be updated
lngRecordNo = CLng(Request.Form("id_no"))
'Create an ADO connection odject
Set adoCon = Server.CreateObject("ADODB.Connection")
'Set an active connection to the Connection object using a DSN-less connection
adoCon.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("Kalender.mdb")
'Set an active connection to the Connection object using DSN connection
'adoCon.Open "DSN=Kalender"
'Create an ADO recordset object
Set rsUpdateEntry = Server.CreateObject("ADODB.Recordset")
'Initialise the strSQL variable with an SQL statement to query the database
strSQL = "SELECT tblData.* FROM tblData WHERE ID_no=" & lngRecordNo
'Set the cursor type we are using so we can navigate through the recordset
rsUpdateEntry.CursorType = 2
'Set the lock type so that the record is locked by ADO when it is updated
rsUpdateEntry.LockType = 3
'Open the tblComments table using the SQL query held in the strSQL varaiable
rsUpdateEntry.Open strSQL, adoCon
'Update the record in the recordset
rsUpdateEntry.Fields("bianca_priv") = Request.Form("bianca_priv")
rsUpdateEntry.Fields("bianca_arb") = Request.Form("bianca_arb")
rsUpdateEntry.Fields("bjoern_priv") = Request.Form("bjoern_priv")
rsUpdateEntry.Fields("bjoern_arb") = Request.Form("bjoern_arb")
'Write the updated recordset to the database
rsUpdateEntry.Update
'Reset server objects
rsUpdateEntry.Close
Set rsUpdateEntry = Nothing
Set adoCon = Nothing
'Return to the update select page incase another record needs deleting
Response.Redirect "update_select.asp"
%>
************************************************************************
Update_form.asp
<%
'Dimension variables
Dim adoCon 'Holds the Database Connection Object
Dim rsKalender 'Holds the recordset for the record to be updated
Dim strSQL 'Holds the SQL query for the database
Dim lngRecordNo 'Holds the record number to be updated
'Read in the record number to be updated
lngRecordNo = CLng(Request.QueryString("ID"))
'Create an ADO connection odject
Set adoCon = Server.CreateObject("ADODB.Connection")
'Set an active connection to the Connection object using a DSN-less connection
adoCon.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("Kalender.mdb")
'Set an active connection to the Connection object using DSN connection
'adoCon.Open "DSN=Kalender"
'Create an ADO recordset object
Set rsKalender = Server.CreateObject("ADODB.Recordset")
'Initialise the strSQL variable with an SQL statement to query the database
strSQL = "SELECT tblData.* FROM tblData WHERE ID_no=" & lngRecordNo
'Open the recordset with the SQL query
rsKalender.Open strSQL, adoCon
%>
<html>
<head>
<title>Kalender 2008 * Opdater</title>
<meta name="Generator" content="Stone's WebWriter 4">
</head>
<body bgcolor="#000000" text="#FF0000" link="#FF0000" vlink="#FF0000" alink="#FF0000">
<!-- Begin form code -->
<h1><p align="center">Opdater kalender</h1><br><br>
<p align="left"><b>Dato: </b>
<%
Response.Write (rsKalender("ugedag")) & ", d. "
Response.Write (rsKalender("dato")) & "-"
Response.Write (rsKalender("maaned")) & "-"
Response.Write (rsKalender("aar")) & "."
%><br><br>
<table border="0" width="90%">
<tr>
<td>
<p align="center">
<form name="form" method="post" action="update_entry.asp">
<p align="Center">Bianca Arbejde:<br>
<textarea wrap="physical" rows="5" cols="40" name="bianca_arb"><% Response.Write (rsKalender("bianca_arb")) %> </textarea>
</td>
<td>
<p align="Center">Bianca Privat:<br>
<textarea wrap="physical" rows="5" cols="40" name="bianca_priv"><% Response.Write (rsKalender("bianca_priv")) %> </textarea>
</td>
</tr>
<tr>
<td>
<br>
</td>
</tr>
<tr>
<td>
<p align="Center">Bjørn Arbejde: <br>
<textarea wrap="physical" rows="5" cols="40" name="bjoern_arb"><% Response.Write (rsKalender("bjoern_arb")) %> </textarea>
</td>
<td>
<p align="Center">Bjørn Privat: <br>
<textarea wrap="physical" rows="5" cols="40" name="bjoern_priv"><% Response.Write (rsKalender("bjoern_priv")) %> </textarea>
</td>
</tr>
<tr>
<td colspan="2">
<p align="center">
<input type="hidden" name="id_no" value="<% = rsKalender("id_no") %>">
<input type="submit" name="Submit" value="Opdater">
</form>
</td>
</tr>
</table>
<!-- End form code -->
</body>
</html>
<%
'Reset server objects
rsKalender.Close
Set rsKalender = Nothing
Set adoCon = Nothing
%>
