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
Solved

Easy Syntax Question

Posted on 1998-08-21
2
176 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
  • 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

The New “Normal” in Modern Enterprise Operations

DevOps for the modern enterprise offers many benefits — increased agility, productivity, and more, but digital transformation isn’t easy, especially if you’re not addressing the right issues. Register for the webinar to dive into the “new normal” for enterprise modern ops.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Website Interactive tool that will do calculations 3 59
ASP.NET MVC 2 40
what are list of ebay api errors 1 28
Forms that calculate points for wordpress 10 51
Read about why website design really matters in today's demanding market.
Any business that wants to seriously grow needs to keep the needs and desires of an international audience of their websites in mind. Making a website friendly to international users isn’t prohibitively expensive and can provide an incredible return…
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

860 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