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

x
?
Solved

Passing information from one recordset into another - possible?

Posted on 2004-08-10
3
Medium Priority
?
143 Views
Last Modified: 2010-04-25
Hi - I originally posted this in the Access area however my problem hasn't yet been addressed!

I have produced a webpage using Dreamweaver which uses VBScript and ASP to run the SQL query. I have used the VBScript functionality of Dreamweaver to step through each result rather than having repeating sections on each page. e.g: 10 results, page shows 1 of 10, and so on.

I am trying to write a page with two recordsets set up in dreamweaver with a persons name within a repeated region so that on each page there will be an activity with all the people taking part in the activity. e.g: Basketball, all team members associated with the activity 'Basketball'

However my problem is that only one person will show up against each activity at a time and as the pages are flicked through, (corresponding to rows of results produced by the query), the same activites show up however with different people connected with the activity as represented in the many to many joining table. e.g: Five pages for Basketball with a different team member on each page!

I have two recordsets - rsQryActivities and rsQryActivitesDetails

The closest I have come to working it out is using the activity title of the first recordset in the second recordset e.g: rsQryActivities.Title as part of an Sql statement like the following:

SELECT Name, Act, Title
FROM QryActivities
WHERE Title ='ActTit'

Name:ActTit
Default Value:%
Run-time Value: rsQryActivities.Title

The logic I am trying to use is that for the corresponding Activity Title of the current page display produced using the first recordset, display all associated individuals produced by running the query of the second recordset within a repeated region on the same page. However, I get the following error when displaying the page:

Microsoft VBScript runtime (0x800A01B6)
Object doesn't support this property or method: 'Name'
/NewConcept/activities.asp, line 27

Any suggestions where I go from here?
0
Comment
Question by:djnsh
[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
3 Comments
 
LVL 23

Accepted Solution

by:
Saqib Khan earned 1000 total points
ID: 11763161
Name is the Reserved Word, either Put it in Brackets [Name] Or rename it to something Else.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

For those who don't know, Adobe Dreamweaver is a popular commercial web editor that enables you to design, build and manage complex websites. The editor is a WYSIWYG (What You See Is What You Get) web editor, which means that you can create your web…
I still run into .cgi files every now and then. In some instances, I actually prefer the simplicity of a .cgi script to other options. Since I use DreamWeaver extensively, what I needed was a way to open .cgi scripts in Dreamweaver. And I wanted to …
Video by: ITPro.TV
In this episode Don builds upon the troubleshooting techniques by demonstrating how to properly monitor a vSphere deployment to detect problems before they occur. He begins the show using tools found within the vSphere suite as ends the show demonst…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Suggested Courses

670 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