Skip to main content
A
Anonymous
February 18, 2007
Question

Filter based on repeat region value

  • February 18, 2007
  • 4 replies
  • 333 views
I have a repeat region which outputs a list of lessons. Each lesson has a set of details.

I have 2 record sets

rslessonName (which contains the following columns) id, courseID, lessonID, lessonName

rslessonDetails (which contains the following columns) id, lessonID, description_1, description_2....to description_25

The repeat region is filtered by a URL Parameter courseID and is set to ascending order based on lessonID

so that part works fine

what I want to do is take the value lessonID during the repeat region and have the rslessonDetails record set display.

I have tried all types of filtering ... but I can't get anything to work

any suggestions???
This topic has been closed for replies.

4 replies

A
Anonymous
February 22, 2007
Dave thanks for the help..
N
Newsgroup_User
Inspiring
February 19, 2007
cdembek wrote:
> Thanks for info.. I am going to do a search to learn more about joining tables
>
> Any chance you can provide an example??

The syntax for joining tables depends on which database you're using.
However, a simple example is this:

SELECT * FROM table1, table2
WHERE table1.id = table2.id

--
David Powers, Adobe Community Expert
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/
A
Anonymous
February 19, 2007
Thanks for info.. I am going to do a search to learn more about joining tables

Any chance you can provide an example??
N
Newsgroup_User
Inspiring
February 18, 2007
cdembek wrote:
> I have a repeat region which outputs a list of lessons. Each lesson has a set
> of details.
>
> I have 2 record sets

You should join the tables to create a single recordset.

--
David Powers, Adobe Community Expert
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices