dynamic select with nested repeat?

Hello all,
I just saw the nested repeat tutorial and it's easy to recreate.
But I need to create a nested repeat for a dynamic select so that I can separate select options by using the optgroup tag.

I would like to create something like this:

[category repeat]
<optgroup label="MyDynamicCategory">
[option repat]
<option value="MyDynamicOption">MyDynamicOption</option>
[/option repeat]
</optgroup>
[/category repeat]

Is there a sample about this?

TIA
tony

There is no sample or tutorial... you can do it with nested recordsets and avoid hand coding, or you could use a hand coded IF statement to add the optgroup tag whenever the group changes.

The nested recordset is probably the easiest:

[Recordset for Groups]
<select>
[Repeat Region for Groups]
<optgroup>
[Recordset for Options (filtered with Recordset for Group)]
[Repeat Region for Options]
<option>val</option>
[End Repeat Region for Options]
</optgroup>
[End Repeat Region for Groups

Originally Said By: Ray Borduin

  There is no sample or tutorial... you can do it with nested recordsets and avoid hand coding, or you could use a hand coded IF statement to add the optgroup tag whenever the group changes.

The nested recordset is probably the easiest:

[Recordset for Groups]
<select>
[Repeat Region for Groups]
<optgroup>
[Recordset for Options (filtered with Recordset for Group)]
[Repeat Region for Options]
<option>val</option>
[End Repeat Region for Options]
</optgroup>
[End Repeat Region for Groups  

Thanks for your reply, Ray.
Just a question: is there a way to intercept the group change? In the (really) old Adobe ADDT extensions there was a server behaviuor like this: "display field if changed."
I can't find anything similar in the WA databridge tools.
Is this doable only by hand coding?
TIA
Tony

What exactly are you trying to do? Select lists have an onchange event which will call javascript when the selection changes.

Hi Ray,
I would like to list all options in the select by category:

Example:

<select>
<optgroup label="cat1">
<option 1...>
<option 2...>
<option 3...>

</optgroup>
<optgroup label="cat2">
<option 4...>
<option 5...>
<option 6...>

</optgroup>
</select>

I have all options in a db table where one column holds the value and another column holds the category:

option - category
option 1 - cat1
option 2 - cat1
option 3 - cat1
option 4 - cat2
option 5 - cat2
option 6 - cat2

I would like to create a repeat region that holds the category and a nested repeat region that holds the options.

It seems the simplest solution, actually, is to create multiple recordset (one per category) and display them in the <optgroup> tags created manually.

Tony

You can nest one recordset inside of the repeat region and have it filtered by the current category to get the options and then repeat on that. It should be just 2 recordsets to support adding or removing categories dynamically. Give it a try and upload the file to a reply if you run into issues.