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/


Reply via email to