nested repeat regions? Data from two separate database tables.

Thanks Lee,

I've spent a bit of time on that, and I've finally got it to work.
I think I had the child recordset wrong, whereby I had to do a SELECT *
rather than SELECT onefieldname.

Coming at it from a different angle has, indeed, resolved that for me.

Regards
Nath

"lee" <lfairban_nospam@amep.com> wrote in message
news:e7c922$foc$1@forums.macromedia.com...
> Perhaps the error has something to do with what you are putting it around.
>
> I used this extension and it got me out of a very bad situation.
>
> The concept behind it is rather odd. You basically set up a repeat region
> and apply TomMuck's extension to the section that you DON'T want
> repeated. In other words, anything that is a child gets repeated while
> everything that is a parent is enclosed by the TMs extension.
>
> Perhaps coming at a different angle will help fix it. Good luck.
>

Perhaps the error has something to do with what you are putting it around.

I used this extension and it got me out of a very bad situation.

The concept behind it is rather odd. You basically set up a repeat region
and apply TomMuck's extension to the section that you DON'T want repeated.
In other words, anything that is a child gets repeated while everything that
is a parent is enclosed by the TMs extension.

Perhaps coming at a different angle will help fix it. Good luck.

Hi PizzaGood!

http://www.tom-muck.com/extensions/help/simulatednestedregion/
...when I attempt to add this to the page, I'm getting this (I'm using
DWMX):
JavaScript error while loading NestedRepeat:
Unable to open script file "../../DynamicCmn.js" (error 2).
I notice a couple of other references to this error in the newsgroups, but
there doesn't appear to be a solution offered and I don't have UD anymore in
order to do that code in there.

http://www.dmxzone.com/showDetail.asp?TypeId=2&NewsId=394
..have tried, and re-tried, this, but it only seems to repeat the 1st
Parent's child items (which is a shame, because it seems to be what I
want!). So I'm getting:
Parent 1
Child, Child Child
Parent 2
Parent 3

I've double checked my database and Parent 2 definitely has "children"! Any
ideas why it wouldn't be displaying them? Here's my code:
<%
While ((Repeat1__numRows <> 0) AND (NOT rsOpenOrders.EOF))
%>
<table width="100%" border="0" cellspacing="0" cellpadding="6">
<tr>
<td><%=(rsOpenOrders.Fields.Item("orderID").Value)%></td>
</tr>
<tr>
<td>
<%
FilterParam = rsOpenOrders.Fields.Item("orderID").Value
rsQuotes.Filter = "orderID = " & FilterParam
While (NOT rsQuotes.EOF)
%>
<%=(rsQuotes.Fields.Item("vanopID").Value)%><br />
<%
rsQuotes.MoveNext()
Wend
%>
</td>
</tr>
</table>
<%
Repeat1__index=Repeat1__index+1
Repeat1__numRows=Repeat1__numRows-1
rsOpenOrders.MoveNext()
Wend
%>

Data Shaping
http://www.asp101.com/articles/chris/datashaping/default.asp
Looks like my only option, but I'll admit that this seems really complicated
for what I'm trying to do.
Also, I'm not sure whether the code detailed on these pages should be placed
above or below the HEAD tag. If it's above, then I'm not sure how it
displays the results. If it's below, then I'm not sure I should have my
connection string on display? Here's some code I eventually settled on,
from the 4guysfromrolla site:
http://www.4guysfromrolla.com/webtech/code/ds.shapecode.html

It's a really well explained article
( http://www.4guysfromrolla.com/webtech/092599-1.shtml), but I'm struggling
to implement it on my page, mainly because I need the "Professor" table to
display a lot of fields. I also have a very set page layout and I'm
struggling to add it into that.

Are nested repeat regions really that uncommon?
I guess I haven't really used them before right enough, but considering what
I'm using it for, it seems to me to be something that would be on most
database driven web sites.

Thanks for your help Pizza.
Regards
Nath.

"PizzaGood" <PizzaGood@earthlink.com> wrote in message
news:e76jmu$a65$1@forums.macromedia.com...
> Try:
>
> http://www.tom-muck.com/extensions/help/simulatednestedregion/
>
> or
>
> http://www.dmxzone.com/showDetail.asp?TypeId=2&NewsId=394
>
> AND MY FAVORITE AND VERY EFFICIENT WAY:
>
> Data Shaping
> http://www.asp101.com/articles/chris/datashaping/default.asp
>
>
>
> "Nathon Jones" <sales@NOSHPAMtradmusic.com> wrote in message
> news:e76b60$rtj$1@forums.macromedia.com...
>> ASP/VB
>>
>> I have two tables in our database
>>
>> Orders
>> orderID
>> customerID
>> title
>> date..etc
>>
>> Quotes
>> quoteID
>> orderID
>> price...etc
>>
>> I want to be able to create a repeat region that shows all orders that
>> match the specified customerID - this works fine.
>>
>> Within that repeat region though I then need to show all quotes relating
>> to each particular order, but when I attempt to add a repeat region,
>> within a repeat region, DWMX doesn't like it - "Nested repeated regions
>> are not supported".
>>
>> I have Google'd this but all of the solutions seem to relate to
>> displaying data from one table.
>> Hope someone can help. Thanks.
>> Nath.
>>
>
>

Try:

http://www.tom-muck.com/extensions/help/simulatednestedregion/

or

http://www.dmxzone.com/showDetail.asp?TypeId=2&NewsId=394

AND MY FAVORITE AND VERY EFFICIENT WAY:

Data Shaping
http://www.asp101.com/articles/chris/datashaping/default.asp



"Nathon Jones" <sales@NOSHPAMtradmusic.com> wrote in message
news:e76b60$rtj$1@forums.macromedia.com...
> ASP/VB
>
> I have two tables in our database
>
> Orders
> orderID
> customerID
> title
> date..etc
>
> Quotes
> quoteID
> orderID
> price...etc
>
> I want to be able to create a repeat region that shows all orders that
> match the specified customerID - this works fine.
>
> Within that repeat region though I then need to show all quotes relating
> to each particular order, but when I attempt to add a repeat region,
> within a repeat region, DWMX doesn't like it - "Nested repeated regions
> are not supported".
>
> I have Google'd this but all of the solutions seem to relate to displaying
> data from one table.
> Hope someone can help. Thanks.
> Nath.
>