SunQuest
 
           ASP Free Lounge
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
 
User Name:
Password:
Remember me
Go Back   ASP Free ForumsOtherASP Free Lounge

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread ASP Free Forums Sponsor:
SlickEdit: Code in over 40 languages across 7 platforms. SlickEdit’s unmatched power, speed, and flexibility allows even the most accomplished developers to write better code faster. Download a free trial today!
  #1  
Old September 22nd, 2003, 04:35 PM
kpsga kpsga is offline
Registered User
ASP Free Newbie (0 - 499 posts)
 
Join Date: Sep 2003
Posts: 2 kpsga User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
ASP code to access query in MS Access

I am having a problem accessing data in a query in MS Access.
I have created a query, and the field heading is: members.firstname

Using ASP, I have:

Response.write ObjRS("Members.FirstName")

I am getting an error:

ADODB.Recordset error '800a0cc1'
Item cannot be found in the collection corresponding to the requested


Can anyone help?
K

Reply With Quote
  #2  
Old September 22nd, 2003, 05:33 PM
Soky's Avatar
Soky Soky is offline
Contributing User
ASP Free Newbie (0 - 499 posts)
 
Join Date: Sep 2003
Location: Bowling Green KY
Posts: 77 Soky User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 5 h 49 m 15 sec
Reputation Power: 5
Send a message via Yahoo to Soky
Try

Response.write ObjRS("FirstName")
__________________
David Francis
Web Application Developer

Air Force trained web designer since 1995 specializing in ASP/SQL online applications for business and organizations.
Partnership with clients for long term and ongoing creation, hosting, marketing and website management.

Reply With Quote
  #3  
Old September 23rd, 2003, 11:23 AM
kpsga kpsga is offline
Registered User
ASP Free Newbie (0 - 499 posts)
 
Join Date: Sep 2003
Posts: 2 kpsga User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Unfortunately, there are several fields called firstname, from different tables, in this query.

Reply With Quote
Reply

Viewing: ASP Free ForumsOtherASP Free Lounge > ASP code to access query in MS Access


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 2 hosted by Hostway