---
title: "Item cannot be found in the collection corresponding to the requested name or ordinal"
type: "forum-thread"
url: "https://www.webforum.nu/amne/asp/43590-item-cannot-be-found-in-the-collection-corresponding-to-the-requested-name-or-ordinal"
topic: "ASP"
topic_url: "https://www.webforum.nu/amne/asp"
author: "StefanP"
published: "2002-05-12T23:23:47.000Z"
updated: "2002-05-13T08:27:32.000Z"
replies: 9
views: 298
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/43590-item-cannot-be-found-in-the-collection-corresponding-to-the-requested-name-or-ordinal"
---

# Item cannot be found in the collection corresponding to the requested name or ordinal

## #1 — StefanP, 2002-05-12T23:23Z

Halloj.
Jag försöker få till det så att prenumeranter kan ta bort sig själva ur nyhetsbrevet.

Jag har en sida som heter radera.asp

```

<form name="form1" method="post" action="deletemail.asp">
  <input type="text" name="email">
  <input type="submit" name="Submit" value="Submit">
</form>
```

Sen deletemail.asp

```

<!-- #include file="adovbs.inc" -->

<%	DBPath = "DBQ=" & Server.MapPath("newslettermain.mdb")
Set connect = Server.CreateObject("ADODB.Connection")
Connect.Open "DRIVER={Microsoft Access Driver (*.mdb)}; " & DBPath

   Set RecSet = Server.CreateObject("ADODB.Recordset")
   Radera = "SELECT * from email WHERE email='"& request.form("email") &"'"
   [b]IF len(RecSet("email")) >0 then[/b]
   response.write "Emailadressen finns inte"
   
   ELSE
   RecSet.Open Radera, Connect, adOpenStatic, adLockOptimistic 

   RecSet.Delete

	RecSet.Close
	Connect.Close 
        end if
%>
```

Men jag får felet 
"Item cannot be found in the collection corresponding to the requested name or ordinal"

line 9

"Line 9 är Bold"

Jag har kollat hur många ggr som helst att tabellen heter "email" och kollumnen heter "email"

Så jag förstår inte vad som är fel?

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

## #2 — solbulle, 2002-05-12T23:31Z

Du kan väl inte använda dig av RecSet("email") innan du öppnat ditt rs?

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

## #3 — solbulle, 2002-05-12T23:34Z

typ kanske:

```
<!-- #include file="adovbs.inc" -->

<%	DBPath = "DBQ=" & Server.MapPath("newslettermain.mdb")
Set connect = Server.CreateObject("ADODB.Connection")
Connect.Open "DRIVER={Microsoft Access Driver (*.mdb)}; " & DBPath

   Set RecSet = Server.CreateObject("ADODB.Recordset")
   Radera = "SELECT * from email WHERE email='"& request.form("email") &"'"

if not rs.eof then

   RecSet.Open Radera, Connect, adOpenStatic, adLockOptimistic 

   RecSet.Delete

	RecSet.Close
	Connect.Close 

else

   response.write "Emailadressen finns inte"

        end if
%>
```

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

## #4 — StefanP, 2002-05-12T23:35Z

hmm

Operation is not allowed when the object is closed. 

line 10
if not RecSet.eof then

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

## #5 — solbulle, 2002-05-12T23:43Z

Hupp, byt plats på dessa rader:

if not rs.eof then

   RecSet.Open Radera, Connect, adOpenStatic, adLockOptimistic 

till:

   RecSet.Open Radera, Connect, adOpenStatic, adLockOptimistic 

if not rs.eof then

så kanske det gårr bättre...

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

## #6 — StefanP, 2002-05-12T23:48Z

hmm

Nu säger den Emailadressen finns inte oavsett ifall den finns eller inte :(

```
<!-- #include file="adovbs.inc" -->

<%
DBPath = "DBQ=" & Server.MapPath("newslettermain.mdb")
Set Connect = Server.CreateObject("ADODB.Connection")
Connect.Open "DRIVER={Microsoft Access Driver (*.mdb)}; " & DBPath

   Set RecSet = Server.CreateObject("ADODB.Recordset")
   Radera = "SELECT * from email WHERE email='"& request.form("email") &"'"

   RecSet.Open Radera, Connect, adOpenStatic, adLockOptimistic 

   if not RecSet.eof then

   

   RecSet.Delete

	RecSet.Close
	Connect.Close 

else

   response.write "Emailadressen finns inte"

        end if
%>
```

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

## #7 — LarsG, 2002-05-13T07:44Z

Får du in korrekt värde  från request.form? Du kan ju lägga in en test-utskrift 

```
Radera = "SELECT * from email WHERE email='"& request.form("email") &"'"

response.write radera
response.end
```

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

## #8 — StefanP, 2002-05-13T08:24Z

hmm

I Adressen så kommer mailen med

deletemail.asp?email=stefan@uppdaterad.com

Men när jag skriver ut "radera" så får den inte med värdet
Såhär mycket får den me då
"SELECT \* from email WHERE email=''

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

## #9 — LarsG, 2002-05-13T08:26Z

```
Radera = "SELECT * from email WHERE email='"& request.querystring("email") &"'"
```

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

## #10 — StefanP, 2002-05-13T08:27Z

Nu fungerar det....  Jag tog bort name på form name="blabla"

Konstigt detta.

Men nu fungerar det varjefall.. tack!

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

---

Tråden på webben: https://www.webforum.nu/amne/asp/43590-item-cannot-be-found-in-the-collection-corresponding-to-the-requested-name-or-ordinal