Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ADODB.Recordset error '800a0cc1'

Status
Not open for further replies.
guyphil

guyphil

Programmer
Nov 2, 2004
27
IL
Hi I keep getting:

ADODB.Recordset error '800a0cc1'

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


The code is:

sql="SELECT * FROM USERS WHERE EML=" & eml

Now Iv'e double and triple checked the spelling of table "USERS" and the field "EML" in my access table,
also eml is a variable that does pass through from the last page.
I can't think of anything else.


Guyphil
 
Sort by date Sort by votes
Hi

Its your asp response.write or rs("whatever") thats causing the problem.

Post the rest of the code and i'll have a look.

Thanks


Glen
Conception | Execution
 
Upvote 0 Downvote
sql="SELECT * FROM USERS WHERE EML=[COLOR=black red]'[/color]" & eml & "[COLOR=black red]'[/color]"

you didn't encase the string value in the query in text qualifiers ( single quotes )

[thumbsup2]DreX
aKa - Robert
if all else fails, light it on fire and do the happy dance!
 
Upvote 0 Downvote
To newmediaguy

Thanks for the help.

Here is the rest of the code....
I would have e-mailed privately but couldn't find your e-mail...
I inherited this web site and as someone who knows absolutely NOTHING about ASP, I'm totally lost!!!

SteveM


<%@LANGUAGE="JAVASCRIPT"%>
<!--#include file="Connections/store_locations.asp" -->
<%
var states = Server.CreateObject("ADODB.Recordset");
states.ActiveConnection = MM_store_locations_STRING;
states.Source = "SELECT * FROM States ORDER BY States ASC";
states.CursorType = 0;
states.CursorLocation = 2;
states.LockType = 3;
states.Open();
var states_numRows = 0;
%>
<%
var Repeat1__numRows = -1;
var Repeat1__index = 0;
states_numRows += Repeat1__numRows;
%>
<% var MM_paramName = ""; %>
<%
// *** Go To Record and Move To Record: create strings for maintaining URL and Form parameters

// create the list of parameters which should not be maintained
var MM_removeList = "&index=";
if (MM_paramName != "") MM_removeList += "&" + MM_paramName.toLowerCase() + "=";
var MM_keepURL="",MM_keepForm="",MM_keepBoth="",MM_keepNone="";

// add the URL parameters to the MM_keepURL string
for (var items=new Enumerator(Request.QueryString); !items.atEnd(); items.moveNext()) {
var nextItem = "&" + items.item().toLowerCase() + "=";
if (MM_removeList.indexOf(nextItem) == -1) {
MM_keepURL += "&" + items.item() + "=" + Server.URLencode(Request.QueryString(items.item()));
}
}

// add the Form variables to the MM_keepForm string
for (var items=new Enumerator(Request.Form); !items.atEnd(); items.moveNext()) {
var nextItem = "&" + items.item().toLowerCase() + "=";
if (MM_removeList.indexOf(nextItem) == -1) {
MM_keepForm += "&" + items.item() + "=" + Server.URLencode(Request.Form(items.item()));
}
}

// create the Form + URL string and remove the intial '&' from each of the strings
MM_keepBoth = MM_keepURL + MM_keepForm;
if (MM_keepBoth.length > 0) MM_keepBoth = MM_keepBoth.substring(1);
if (MM_keepURL.length > 0) MM_keepURL = MM_keepURL.substring(1);
if (MM_keepForm.length > 0) MM_keepForm = MM_keepForm.substring(1);
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">
<html>
<head>
<meta http-equiv="PICS-Label"
content='(PICS-1.1 " l gen true comment "RSACi North America Server" by "webmaster@kipusa.com" for " on "1997.11.24T10:20-0800" r (n 0 s 0 v 0 l 0))'>
<meta HTTP-EQUIV="distribution" CONTENT="Global">
<meta NAME="keyword"
content="bread, bakery, sour dough, food, pigs, gourmet, sandwiches, wine, cheese, beer, maine, york, ogunquit, boston, flour, king arthurs, raving, wheat, when, fly, brains, portsmouth, rye, oats, cinnamon, recipie, dinner, lunch, breakfast, toast, croutons, salads, restaurants, hungry, starving, portland, new england, crust, cookies, cider, organic, natural, pizza, fresh, artisan, hearth, bake, crackers, apples, cornmeal, kemper, beach, ski, roche brothers, star market, whole foods, bicad, ciscey, hannaford, shaws, demoulas, market basket, new york, onion, dill, olive, honey, potato, garlic, molasses, pumpernickel, anadama, harvest, coconut, granola, cranberries, florida crystals, non fat, rolls, french, foccacia, almonds, walnuts, sunflower, sesame, jewish, delivery, seacoast, hot, wholesale, retail, mail, fedex, ups, crunchy, soft, texture, heart, cholesterol, fiber, sodium, yeast, salt, sponge, slice, parbake, fancy, dessert, appetizer, reubin, pastrami, corned beef, toast, seafood, salmon, chicken, poultry, dairy, delicatesson, subs, hogie, stale, flavor, cheese, montana, minnesota, carbill, hobart, oliver, plastics,cocoa, tomatos, coffee, citrus, tea, café, diner, starbucks,wilberts, natures heartland, globe, best, mayonaise, mustard, yahoo, fennel, pepper, kosher, swine, farmer, silo, charity, kbsystems, kwik lock, rosemary, eggs, salt, pesto, italian, spaghetti, monte cristo, toaster, ham, turkey, stuffing, thanksgiving, christmas, party, champagne, caviar, basket, italy, stonewall, ll bean, kennebunk, acadia, vermont, all 50 states, cuisinart, william sonoma, jalapeno, sponge, ferment, water, hog, heaven, buckwheat, pumpkin seed">
<meta NAME="description"
content="We bake old-world style artisan breads using the finest organic, natural ingredients. Experience what over 1 million people in New England have enjoyed for years.">
<meta NAME="robots" content="index, follow">
<meta NAME="ratings" content="General">
<meta NAME="resource-type" CONTENT="Document">
<title>Where to find our Breads</title>
</head>
<body bgcolor="#008080">
<div align="center">
<center>
<table border="0" cellpadding="3" width="651" bgcolor="#FFFFFF"
style="border: 2 ridge rgb(0,0,0)" background="images/back.gif">
<tr>
<td width="100%">
<div align="center">
<center>
<table border="0" cellpadding="3"
width="100%">
<tr>
<td width="50%" valign="top" align="left"><img src="images/title.gif"
alt="title.jpg (13826 bytes)" WIDTH="369" HEIGHT="37">
<div align="center">
<center>
<table
border="0" cellpadding="3" width="100%">
<tr>
<td width="100%"></td>
</tr>
<tr>
<td width="100%">
<form>
<div align="center">
<center>
<p>&nbsp;
<select name="list" size="1">
<option value="main.htm">About Us</option>
<option value="breads.htm">Our Breads</option>
<option value="history.htm">Our History</option>
<option value="shop.htm">Buy our bread</option>
<option value="store.htm">Shop our store</option>
<option value="contact.htm">Contact Us</option>
<option value="links.asp">Where to find
our Breads</option>
</select>
<input TYPE="button" VALUE="Go"
onClick="parent.location.href=this.form.list.options[this.form.list.selectedIndex].value">
</p>
</center>
</div>
</form>
</td>
</tr>
</table>
</center>
</div>
</td>
<td width="50%"><img src="images/all_natural.gif" alt="all_natural.jpg (8242 bytes)"
WIDTH="250" HEIGHT="98"></td>
</tr>
</table>
</center>
</div>
<div align="center">
<center>
<table border="0" cellpadding="3" width="100%">
<tr>
<td width="50%" valign="top" align="left">If you would like
to know where you can go to buy some of our breads from a
local store, please choose the state in which you live and
we will let you know where we are.</td>
<td width="50%" style="border-left: 3px groove rgb(0,128,128)" valign="top" align="left">
<table width="75%" border="0" cellspacing="0" cellpadding="3">
<% while ((Repeat1__numRows-- != 0) && (!states.EOF)) { %>
<tr>
<td><b><A HREF="detail.asp?<%= MM_keepURL + ((MM_keepURL!="")?"&":"") + "States=" + states.Fields.Item("States").Value %>"><%=(states.Fields.Item("States").Value)%></A></b></td>
</tr>
<%Repeat1__index++; states.MoveNext();}%>
</table>
</td>
</tr>
</table>
<a href="main.htm"><br>
About Us</a> | <a href="breads.htm">Our Breads</a> | <a href="history.htm">Our
History</a> | <a href="shop.htm">Buy our Bread</a><br>
<a href="links.asp">Where to find our Breads</a> | <a href="store.htm">Shop
our Store</a> | <a href="contact.htm">Contact Us</a><br>
<br>
Copyright © When Pigs Fly 1999 - 2004<br>
This site produced by: <a href=" target="_blank">911
PC Rescue</a>
</center>
</div>
</td>
</tr>
</table>
</center>
</div>
</body>
</html>
<%
states.Close();
%>
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Krus1972
  • Locked
  • Question
msxml3.dll error '80072f7d' - An error occurred in the secure Channel support
Replies
7
Views
541
Krus1972
Krus1972
leifoet
  • Locked
  • Question
Using date picker gives an error message, only at application start
Replies
1
Views
336
MarkSweetland
MarkSweetland
chikwendu
  • Locked
  • Question
OraOLEDB error '80040e4b'
Replies
1
Views
517
xwb
xwb
dwg23
  • Locked
  • Question
ADODB.Recordset error '800a0cc1' Item cannot be found in the collection corresponding to the reques
Replies
3
Views
257
gmmastros
gmmastros
evr72
  • Locked
  • Question
formatting error
Replies
3
Views
142
evr72
evr72

Part and Inventory Search

Sponsor

Back
Top