Solved

Passing information from one recordset into another - possible?

Posted on 2004-08-10
3
140 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 250 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: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say 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

Suggested Solutions

Title # Comments Views Activity
Debug application start 2 285
Dreamweaver CS6 Audio File Autoplay Always Plays 2 121
Adobe Photoshop CC 2015 action script help 2 240
Adobe Acrobat Pro: Is this a known bug? 9 162
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…
Adobe Dreamweaver CS5 is a WYSIWYG web page editor that has advanced HTML, CSS, and Javascript rendering functionality and is probably the most well-known HTML editor available. Much of Dreamweaver's appeal centers around the Design View interfac…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…

734 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