HTML5 Data Bindings Support Product Page

Answered

Nested repeat region from database

10 years ago Jeff Powell posted:
I have reviewed the tutorial on nested repeat regions, but you never showed how to set up the database. I have a MySQL category table (ID, CatName) and a detail table (ID, CatID, DetailName). In your example of motorcycles and colors, how do I set up the data source so that the nested repeat is properly filtered within the category repeat region?

Replies

Replied 10 years ago
10 years ago Teodor Kuduschiev replied:
Replied 9 years ago
9 years ago Dik Hendriks replied:
Hello,
I am setting up a page with a list containing a repeat- and nested repeat region.
With the help of the tutorial this works fine, except for the sort-order i specified in the server connect action.
Is there a way to control the sort order?
Replied 9 years ago
9 years ago Dik Hendriks replied:
I found a 'work around' for this issue;
Two seperate server actions, i use a main repeat region, inside this region i a placed a second repeat region whitch i filtered with a 'where ( id == $value.id )'. Now i can control the order on both server actions.
Replied 9 years ago
9 years ago Teodor Kuduschiev replied:
Hi all,
With the new server connect you can created nested database queries, in a single server action file. I will setup a tutorial about this later this week!

Reply to this topic