Please help me get this through my head...
I have two tables, Property and Owner. I have a form where a user can enter information on a real estate property, and information on its various owners. The form auto generates incremented form fields for multiple owners depending on how many owners the user chooses before they begin to fill in the form. For instance, when a user clicks 'add a real estate property', they are asked how many owners the property has, and all the associated form fields are generated by ColdFusion. Static property fields for the Property table ------------------------------------- form.propertyAddress form.propertyCity form.propertyState form.propertyZip etc... Generated fields for the Owner table ------------------------------------- form.OwnerName1 form.OwnerPhone1 form.OwnerName2 form.OwnerPhone2 form.OwnerName3 form.OwnerPhone3 etc.... So I have form fields that need to be saved to the Property table, and I have multiple owners (rows) that need to be inserted into the Owner table, but associated with the active PropertyID. I've been doing this with SQL for a while, so I have a lot of data in the Owners table. The getOwnerIterator() works fine, but how do I go about looping through the owners and saving them when I save the property in Reactor? In the docs, it states there's no setOwnerIterator, and then talks about linking tables (a PropertyOwner table). Would saving the multiple Owners be separate operation looping over Reactor set methods with ColdFusion (for each owner)? If so, how do I ensure referential integrity... maintaining the active PropertyID inserted/updated. A little confused, Thomas -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List [email protected] Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
