Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › Nested Repeat Region - Nested SQL Query Loop

Nested Repeat Region - Nested SQL Query Loop

Thread began 10/13/2013 9:07 am by dlovas275157 | Last modified 10/14/2013 8:56 am by Jason Byrnes | 802 views | 1 replies |

10/13/2013 9:07 am | #1 dlovas275157

Nested Repeat Region - Nested SQL Query Loop

I need advice on how to best setup the following scenario for a real estate website.

I have two database tables of data "Properties" and "Open Houses".

Properties loop in a repeat region showing 1 property per table row (very simple).

Open Houses are assigned to properties via a "property foreign key" column named "propertyFK". So there may be more than 1 open house per property, and these would sit in a nested table with a repeating row for each open house for that individual property.

What is the easiest way to accomplish this?

Properties TBL
id_property
address
price
propDetails

OpenHouse TBL
id_openHouse
propertyFK (foreign key to id_property in Property TBL)
openHouseDate
openHouseTime

10/14/2013 8:56 am | #2 Jason ByrnesWebAssist

See the following tutorial for details on nested recordsets:
http://www.webassist.com/tutorials/Display-nested-recordsets

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.