Hi there,
Total Reactor newbie, and I'm having troubles. Problem is don't know
if I'm expecting something of Reactor that it cannot do, or im just
missing something(more than likely)
Puesdo Code:
I have two table which are link by a column called idContact.
Order
-orderid
-orderItem
-idContact
Customer Address
-idContact
-Customer_name
-Customer_address
In the reactor XML i have set these up as a linked table
<object name="order">
<hasMany name="customer">
<link name="customerOrder" />
</hasMany>
</object>
<object name="customer">
<hasMany name="order">
<link name="customerOrder" />
</hasMany>
</object>
<object name="customerOrder">
<hasOne name="customer">
<relate from="idContact" to="idContact" />
</hasOne>
<hasOne name="order">
<relate from="idContact" to="idContact" />
</hasOne>
</object>
I thought that when I used createRecord() it would affectivley treat
this as a single table.
Instead when I use the following and see whats being generated via
_getTo() I only get the information from the "order" table.
<cfset newOrder = variables.reactor.createRecord('order')>
Is this right? Is there a way that I can treat two tables as one??
Well its 1:30am (which probaly isnt helping my brain) so im gonna
switch off from here, go to bed and catch up on House.
Cheers
Andy J
www.andyjarrett.co.uk
-- Reactor for ColdFusion Mailing List -- [email protected]
-- Archives at http://www.mail-archive.com/reactor%40doughughes.net/