Fejl i response.redirect.
<%'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
if Request.form("kodeord") <> Request.form("kodeord2") then
Response.Redirect "update_form.asp?msg=" & Server.URLEncode ("Kodeord stemmer ikke overens!.")& "&brugernavn=" & Server.URLEncode(strbrugernavn)& "&fornavn=" & Server.URLEncode(strFornavn)& "&efternavn=" & Server.URLEncode(strEfterNavn)& "&email=" & Server.URLEncode(stremail)
end if
'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("../db/bruger.mdb")
'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 brugerdata.* FROM brugerdata 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("brugernavn") = Request.Form("brugernavn")
rsUpdateEntry.Fields("fornavn") = Request.Form("fornavn")
rsUpdateEntry.Fields("efternavn") = Request.Form("efternavn")
rsUpdateEntry.Fields("email") = Request.Form("email")
rsUpdateEntry.Fields("kodeord") = Request.Form("kodeord")
if Request.Form("admin") = "on" then
rsUpdateEntry.Fields("admin") = true
else
rsUpdateEntry.Fields("admin") = false
end if
'Write the updated recordset to the database
rsUpdateEntry.Update
'Reset server objects
rsUpdateEntry.Close
Set rsUpdateEntry = Nothing
Set adoCon = Nothing
'Redirect to the guestbook.asp page
Response.Redirect "update_select.asp"
%>
********
<%
msg= request.querystring("msg")
fornavn=request.querystring("fornavn")
efternavn=request.querystring("efternavn")
email= request.querystring("Email")
'Dimension variables
Dim adoCon 'Holds the Database Connection Object
Dim rsGuestbook '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("../db/bruger.mdb")
'Set an active connection to the Connection object using DSN connection
'adoCon.Open "DSN=guestbook"
'Create an ADO recordset object
Set rsGuestbook = Server.CreateObject("ADODB.Recordset")
'Initialise the strSQL variable with an SQL statement to query the database
strSQL = "SELECT brugerdata.* FROM brugerdata WHERE ID_no=" & lngRecordNo
'Open the recordset with the SQL query
rsGuestbook.Open strSQL, adoCon
%>
<html>
<head>
<title></title>
<link rel="stylesheet" type="text/css" href="fiskestil.css">
</head>
<body bgcolor="#d7dadf" text="black">
<div align="center">
<center>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="350" id="AutoNumber2">
<tr>
<td width="100%">
<p align="center">
<font face="Verdana" size="1">
rediger bruger <br>
</font>
</p>
</td>
</tr>
<tr>
<td width="100%">
<hr width="350px">
</td>
</tr>
</table>
</center>
</div>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" width="530px" align=center>
<tr>
<td align=center>
<%
Response.write "<FONT size=1 face=verdana><b>" & (msg) & "</b></FONT>"
%>
</td>
</tr>
</table>
<br>
<!-- Begin form code -->
<form name="form" method="post" action="update_entry.asp">
<div align="center">
<center>
<table width="300">
<tr>
<td width="50px">
<FONT size=1 face=verdana>
Brugernavn
</font>
</td>
<td width="270px">:<% =rsguestbook("Brugernavn")%>
<!-- <input type="text" name="brugernavn" size="30" style="border-style: dotted; border-width: 1; background-color: #F9F9F9"> -->
</td>
</tr>
<tr>
<td width="50px">
<FONT size=1 face=verdana>
Fornavn
</font>
</td>
<td width="270px">:
<input type="text" value="<% =rsguestbook("fornavn")%>" name="Fornavn" size="30" style="border-style: dotted; border-width: 1; background-color: #F9F9F9">
</td>
</tr>
<tr>
<td width="50px" >
<FONT size=1 face=verdana>
Efternavn
</font>
</td>
<td width="270px" >:
<input type="text" value="<% =rsguestbook("efternavn")%>" name="Efternavn" size="30" style="border-style: dotted; border-width: 1; background-color: #F9F9F9">
</td>
</tr>
<tr>
<td width="50px" >
<FONT size=1 face=verdana>
</font>
</td>
<td width="270px" >:
<input type="text" value="<% =rsguestbook("email")%>" name="email" size="30" style="border-style: dotted; border-width: 1; background-color: #F9F9F9">
</td>
</tr>
<tr>
<td width="50px" >
<FONT size=1 face=verdana>
Kodeord
</font>
</td>
<td width="270px" >:
<input type="password" value="<% =rsguestbook("kodeord")%>" name="kodeord" size="30" style="border-style: dotted; border-width: 1; background-color: #F9F9F9">
</td>
</tr>
<tr>
<td width="50px" >
<FONT size=1 face=verdana>
Kodeord igen
</font>
</td>
<td width="270px" >:
<input type="password" value="<% =rsguestbook("kodeord")%>" name="kodeord2" size="30" style="border-style: dotted; border-width: 1; background-color: #F9F9F9">
</td>
</tr>
<tr>
<td width="50px" >
<FONT size=1 face=verdana>
Admin
</font>
</td>
<td width="270px" >:
<INPUT type="checkbox" id="checkbox" name="admin" <%if rsguestbook("admin")= true then %> checked <%end if %>>
</td>
</tr>
</table>
</center>
</div>
</table>
</center>
</div>
<br>
<div align="center">
<center>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="350" id="AutoNumber2">
<tr>
<td width="100%">
<p align="center">
<font face="Verdana" size="1">
<strong>
<input type="hidden" name="ID_no" value="<% = rsGuestbook("ID_no") %>">
<input type="submit" name="Submit" value="Opdater tilmelding" class="Trykknap">
</strong>
</font>
</p>
</td>
</tr>
</table>
</center>
</div>
</form>
<!-- End form code -->
</body>
</html>
<%
'Reset server objects
rsGuestbook.Close
Set rsGuestbook = Nothing
Set adoCon = Nothing
%>
hvis jeg gør så der er 2 forskellige kodeord så skulle de gerne returnere til siden update_form.asp. Men så får jeg en fejl der siger :
Fejltype:
ADODB.Field (0x80020009)
Enten er BOF eller EOF sand, eller den aktuelle post er blevet slettet. Den anmodede handling kræver en aktuel post.
Så jeg kunne forestille mig at det var noget med at jeg ikke får id_no med tilbage eller lign ? Hjælp !!
