Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Easy Syntax Question

Posted on 1998-08-21
2
Medium Priority
?
181 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 100 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

Simplify Your Workload with One Tool

How do you combat today’s intelligent hacker while managing multiple domains and platforms? By simplifying your workload with one tool. With Lunarpages hosting through Plesk Onyx, you can:

Automate SSL generation and installation with two clicks
Experience total server control

Question has a verified solution.

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

This article will inform Clients about common and important expectations from the freelancers (Experts) who are looking at your Gig.
FAQ pages provide a simple way for you to supply and for customers to find answers to the most common questions about your company. Here are six reasons why your company website should have a FAQ page
This video teaches users how to migrate an existing Wordpress website to a new domain.
The viewer will learn how to dynamically set the form action using jQuery.
Suggested Courses

688 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