Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Passing information from one recordset into another - possible?

Posted on 2004-08-10
3
Medium Priority
?
145 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
1 Comment
 
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

Ask an Anonymous Question!

Don't feel intimidated by what you don't know. Ask your question anonymously. It's easy! Learn more and upgrade.

Question has a verified solution.

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

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…
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

824 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