Nested repeat regions

[xag]

Hello folks. I was wondering if there was anything in DataAssist for doing nested repeat regions of in any product to help do this. I currently have a record set that has all of my tables joined just the way I like it. The thing I am doing to do is to dump the data out in a region that is specified by the recordset. Ex.

I have two regions Left and Main

I want all data that has the property of Left regions to be in the left region and all data with property of Main region to be in the main regions.

Any help or direction in the right direction would be helpful.

Thanks

[Ray Borduin]

Yes, DataAssist includes a repeat selection that can be nested inside itself, or nested inside a DW repeat region.

[xag]

Is there any way to tell the Level 2 to stop and move to the next record and start populating that region with the remaing data? I'm starting to think this is a SQL thing.

[Ray Borduin]

It will automatically move to the next record if you specify the recordset to repeat on. I'm not sure but I think that is your question. What is it you are trying to do?

[xag]

I'm trying to dynamically populate different Div tags across my page. I have my
<div id="<%=(rsDIVREGIONS.Fields.Item("PF_DIV_REGION").Value)%>"> where DIVREGIONS(PF_DIV_REGION) holds #LEFT and #MIDDLE which are my two div's on the page. then I have <%=(rsDIVREGIONS.Fields.Item("FACT_CONTENT").Value)%> where FACT_CONTENT just hold LEFT HEADER and MIDDLE HEADER. All I'm trying to figure out is how to do a loop where if PF_DIV_REGION = LEFT and FACT_CONTENT=LEFT to display LEFT HEADER and vice versal for MIDDLE. I did the joins in SQL and they come out fine there but DWCS3 is telling me nested loops are not supported so i'm trying to do it with dataassist.

[Ray Borduin]

Seems similar to:

http://www.webassist.com/forums/showthread.php?t=1222

[xag]

yup pretty much Ray. Any examples of this in ASP? Not that well versed in PHP, still learning. Also for the subcontent how would he repeat that accorind to what DIV he set it to if all the subcontent was all different.

Thanks Ray

[Ray Borduin]

The iteration code is on any admin results page created by DataAssist, so you can take it from that page.

Maybe apply dataassist wizard a second time with a forward facing page that has a 3 x 3 grid of results.

It is really the same in asp and php.