Solved

Easy Syntax Question

Posted on 1998-08-21
2
180 Views
Last Modified: 2013-12-25
I am trying to retrieve data from 2 tables in the same database, but I can't figure out the syntax problem.  The error I get is:
ADODB.Recordset error '800a0cc1'
Item not found in this collection.
/History.asp, line 36

The following is my script and the syntax problem should be the last line.
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.ConnectionTimeout = 15
Conn.CommandTimeout = 30
Conn.Open "DSN=RP"
strSQL = "SELECT Inventory.ID, Inventory.Type, Inventory.Brand, Inventory.Model, Inventory.Comment, History.Username, History.BT, History.Price FROM History INNER JOIN Inventory ON History.Bid = Inventory.ID WHERE History.Username='" & User & "' ORDER BY Inventory.ID,  History.Price, Inventory.Type, Inventory.Brand, Inventory.Model"
Set RS = Conn.Execute(strSQL)
Resonse.write RS("Inventory.ID")

Thanks for helping!  Greatly appreciated!
0
Comment
Question by:dangel
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
2 Comments
 
LVL 2

Accepted Solution

by:
vendrig earned 50 total points
ID: 1854504
You wrote Resonse instead of Response.
Oh oh;-)
0
 
LVL 2

Expert Comment

by:vendrig
ID: 1854505
My experience tells me never to trust an ASP error message, but looking again at this case I wonder if you have good code, just made a typo here on EE. Are you sure RS is not empty? It may be a good idea to check for EOF first anyhow.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When it comes to write a Context Sensitive Help (an online help that is obtained from a specific point in state of software to provide help with that state) ,  first we need to make the file that contains all topics, which are given exclusive IDs. …
Does your audience prefer people in photos or no people? How can you best highlight what you’re selling? What are your competitors doing, and what can you do that is different and unique from them?  Continue reading to learn how to make your images …
This tutorial demonstrates how to identify and create boundary or building outlines in Google Maps. In this example, I outline the boundaries of an enclosed skatepark within a community park.  Login to your Google Account, then  Google for "Google M…
Any person in technology especially those working for big companies should at least know about the basics of web accessibility. Believe it or not there are even laws in place that require businesses to provide such means for the disabled and aging p…

622 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question