Solved

Easy Syntax Question

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

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

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

Learn by example how to specify CSS selectors for Selenium WebDriver test automation software.
I've been asked to discuss some of the UX activities that I'm using with my team. Here I will share some details about how we approach UX projects.
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.

910 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now