Solved

Passing information from one recordset into another - possible?

Posted on 2004-08-10
3
136 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
3 Comments
 
LVL 23

Accepted Solution

by:
adilkhan 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Multi Step Form using jQuery 11 938
Dreamweaver FTP Access 12 86
Adobe Acrobat Pro top display text upside down? 5 106
Font: I need Lato on my Mac 10 187
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…
This article is very specific and is only intended to help if you are installing Dreamweaver 8 in a Windows 7 environment with Office 2007 installed.   I'm not sure why Microsoft tends to release OS' that should not be released but they do.  Windows…
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…

867 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now