Access/ASP, Join tables, error on Response.Write

	Home Register Search Help Login

Sponsors

Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.

Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Search Forums

Recent Posts

Todays Posts
Most Active posts
Posts since last visit
My Recent Posts
Mark posts read

Access/ASP, Join tables, error on Response.Write

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> Web Development >> ASP and Database >> Access/ASP, Join tables, error on Response.Write

Page: [1]


aaronwiles Posts: 200 Joined: 7/5/2004 From: Aaron Wiles Status: offline	Access/ASP, Join tables, error on Response.Write - 7/19/2004 13:40:09 HELP! I've unable to figure this out for almost two weeks. Basically I am developing a chat site for friends etc, & have never needed to join tables before & display the data. I have run this query in MS Access & it displays the data I expect it to, but when running it from & web page I am recieving the following error. I am recieving the error message: ADODB.Recordset (0x800A0CC1) Item cannot be found in the collection corresponding to the requested name or ordinal. /visitors.asp, line 65 The query seems to work ok but it's the displaying the data on the page that I am having problems with, the db field 'Profiles.NickName' is the correct spelling, anyone who could possibly tell me what I am doing wrong? I would be very gratful. '#DB connection <!--#include virtual="common/dbcon/members.asp"--> '#Open db connection call openCon() '#SQL Query Set rsMyChat = adoCon.Execute("SELECT Visitors.VisitorID, Visitors.ProfileID AS Visitors_ProfileID, Visitors.VisitDateTime, Profiles.ProfileID AS Profiles_ProfileID, Profiles.NickName, Profiles.Image1, Profiles.Gender FROM Profiles RIGHT JOIN Visitors ON Profiles.ProfileID = Visitors.ProfileID;") '#Line 65 Response.Write (rsMyChat("Profiles.NickName")) '#Close db connection Set rsMyChat = Nothing call closeCon()


Spooky Posts: 26606 Joined: 11/11/1998 From: Middle Earth Status: offline	RE: Access/ASP, Join tables, error on Response.Write - 7/19/2004 15:13:02 Response.Write (rsMyChat("NickName")) _____________________________ If you arent part of the solution, then there is good money to be made prolonging the problem ��k� Database / DRW help Check out the Tutorials for Frontpage Databases Forum FAQ' s Developers Edition Spooky Login User Registration and Management tool Personalized Frontpage Hosting (in reply to aaronwiles)


aaronwiles Posts: 200 Joined: 7/5/2004 From: Aaron Wiles Status: offline	RE: Access/ASP, Join tables, error on Response.Write - 7/20/2004 12:01:32 Oh my word. I do not believe that was it! I am sure I tried that . How silly do I feel, thanks very much for ur help. (in reply to Spooky)


Spooky Posts: 26606 Joined: 11/11/1998 From: Middle Earth Status: offline	RE: Access/ASP, Join tables, error on Response.Write - 7/21/2004 4:46:21 no problems _____________________________ If you arent part of the solution, then there is good money to be made prolonging the problem ��k� Database / DRW help Check out the Tutorials for Frontpage Databases Forum FAQ' s Developers Edition Spooky Login User Registration and Management tool Personalized Frontpage Hosting (in reply to aaronwiles)