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.
>>
>
>
4
Replies
AdChoices