forLoop
Posts: 20
|
| Posted: 04/15/2006, 11:07 PM |
|
Hi all,
I'm using CCS to create the backend for an XML driven Flash application. I've figured out how to write the XML but I can't figure out how to have 2 tables in 1 list.
I have 2 tables called Villas and VillaFloors. I want to make a query that shows a list of the Villas. Inside each list would be a list of VillaFloors associated with the Villa. Make sence?
Here's and example of what I mean.
http://www.visual23.com/combineGrids.jpg
Here's what the XML will look like.
<Villa available='1' detailTemplatePath='villaDetailTemplate.swf' fpTemplatePath='villaFPTemplate.swf' number='1' title='VILLAS 1'>
<Floor fpSWFPath='vFP_l1_1-2.swf' detailView='vDetail-l1.swf'>
<PlanName>Main Floor</PlanName>
<Bedrooms>0</Bedrooms>
<Baths>1/2</Baths>
<AreaSqFt>997</AreaSqFt>
<TerraceSqFt>668</TerraceSqFt>
<TotalSqFt>1,665</TotalSqFt>
</Floor>
<Floor fpSWFPath='vFP_l1_1-2.swf' detailView='vDetail-l2.swf'>
<PlanName>2nd Floor</PlanName>
<Bedrooms>0</Bedrooms>
<Baths>1/2</Baths>
<AreaSqFt>997</AreaSqFt>
<TerraceSqFt>668</TerraceSqFt>
<TotalSqFt>1,665</TotalSqFt>
</Floor>
<Floor fpSWFPath='vFP_l1_1-2.swf' detailView='vDetail-l3.swf'>
<PlanName>3rd Floor</PlanName>
<Bedrooms>0</Bedrooms>
<Baths>1/2</Baths>
<AreaSqFt>997</AreaSqFt>
<TerraceSqFt>668</TerraceSqFt>
<TotalSqFt>1,665</TotalSqFt>
</Floor>
</Villa>
Thanks in advance for any help!
Robb
|
 |
 |
|
