Passing information from one recordset into another - possible?
Posted on 2004-08-10
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
WHERE Title ='ActTit'
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?