---
title: "Object required: ''"
type: "forum-thread"
url: "https://www.webforum.nu/amne/asp/41304-object-required"
topic: "ASP"
topic_url: "https://www.webforum.nu/amne/asp"
author: "Mini"
published: "2002-04-10T16:30:39.000Z"
updated: "2002-04-10T16:42:28.000Z"
replies: 2
views: 177
page: 1
pages: 1
language: "sv-SE"
site: "webForum — webforum.nu"
rights: "Upphovsrätten till varje inlägg tillhör dess författare."
attribution: "Citera som: webForum, https://www.webforum.nu/amne/asp/41304-object-required"
---

# Object required: ''

## #1 — Mini, 2002-04-10T16:30Z

Error Type:
Microsoft VBScript runtime (0x800A01A8)
Object required: ''

code:

\<!-- #include file="adovbs.inc" --\>
\<%	Set Connect = Server.CreateObject("ADODB.Connection")
	Connect.Open "driver={Microsoft Access Driver (\*.mdb)};dbq=" & Server.MapPath("../db/members.mdb")&";pwd=losen"

visa = "SELECT \* FROM asp WHERE ID = " & Trim(Request.QueryString("id")) & " "
RecSet.Open Addera, Connect, adOpenStatic, adLockOptimistic
 %\>
\<form method="POST" action="redigera2.asp"\>
  \<input type="hidden" name="AD" value="\<% =Request.QueryString("ID") %\>"\>
  \<input type="text" size="30" name="fornamn" value="\<% =RecSet("EPOST") %\>"\>
  \<br\>
  \<input type="text" size="30" name="efternamn" value="\<% =RecSet("NAMN") %\>"\>
  \<p\> 
    \<textarea cols="30" name="adress"\>\<% =RecSet("INLAGG") %\>\</textarea\>
  \<p\> 
    \<input type="submit" value="Uppdatera"\>
\</form\>
\<%RecSet.CLOSE
Connect.CLOSE
Set RecSet = nothing
Set Connect = nothing
	%\>
\<p\>\<a href="default.asp"\>Redigera annan post!\</a\>

Permalänk: https://www.webforum.nu/p/41304

## #2 — LarsG, 2002-04-10T16:37Z

Du skapar aldrig något recordset.

```

addera = "SELECT * FROM asp WHERE ID = " & request.QueryString("id") 

set RecSet = Connect.execute(addera)
%>

<form method="POST" action="redigera2.asp"> 
<input type="hidden" name="AD" value="<% =Request.QueryString("ID") %>"> 
<input type="text" size="30" name="fornamn" value="<% =RecSet("EPOST") %>"> 
<br> 
<input type="text" size="30" name="efternamn" value="<% =RecSet("NAMN") %>"> 
<p> 
<textarea cols="30" name="adress"><% =RecSet("INLAGG") %></textarea> 
<p> 
<input type="submit" value="Uppdatera"> 
</form> 
<%RecSet.CLOSE 
Connect.CLOSE 
Set RecSet = nothing 
Set Connect = nothing 
%> 
<p><a href="default.asp">Redigera annan post!</a>
```

Du hade också blandat ihop variabelnamnen visa och addera

Permalänk: https://www.webforum.nu/p/640955

## #3 — Mini, 2002-04-10T16:42Z

Tack LarsG!

Funkade utmärkt!

Permalänk: https://www.webforum.nu/p/640958

---

Tråden på webben: https://www.webforum.nu/amne/asp/41304-object-required