Reactor For CF output relational recordset

[Brian Billings]

All, I have two tables. ACTIVITIES and SPONSORS. Each sponsor has many
activities.


When I use the gateway I get this output. How do I get the text value of the
sponsor to show in the activities list?


Output:
Name Sponsor Duration Code 
Test1 6 60 code1 
Teat2 3 30 code2



Controller function:


        <cffunction name="ListActivities" access="public" output="false"
returntype="ModelGlue.Core.Event">
                <cfargument name="event" type="ModelGlue.Core.Event"
required="true">
                        <cfset var local = structnew() />
                        <cfset local.gateway = variables.reactor />
                        <cfset local.gateway.creategateway('Activity') />

                        <cfset
arguments.event.setValue("Activities",local.gateway.getall()) />   
                <cfreturn  arguments.event />
        </cffunction>



Reactor config:
<reactor>
        <config>
                <dsn value="CCARC" />
                <type value="mssql" />
                <mapping value="/Reactor" />
                <mode value="development" />
        </config>
        <objects>
                <object name="activity">
                        <hasone name="sponsor">
                                <relate from="sponsor_id" to="sponsor_id" />
                        </hasone>
                </object>
        </objects>
</reactor>


Tables:
CREATE TABLE [dbo].[ACTIVITY] (
        [ACTIVITY_ID] [int] IDENTITY (1, 1) NOT NULL ,
        [SPONSOR_ID] [int] NOT NULL ,
        [ACTIVITY_CODE] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL ,
        [ACTIVITY_NAME] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS
NOT NULL ,
        [ACTIVITY_DESC] [varchar] (2000) COLLATE
SQL_Latin1_General_CP1_CI_AS NOT NULL ,
        [DURATION] [int] NOT NULL ,
        [ORIG_UPDATE] [smalldatetime] NOT NULL ,
        [LAST_UPDATE] [smalldatetime] NOT NULL ,
        [IS_ACTIVE] [bit] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[SPONSOR] (
        [SPONSOR_ID] [int] IDENTITY (1, 1) NOT NULL ,
        [CONTACT_NAME] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS
NOT NULL ,
        [CONTACT_PHONE] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL ,
        [SPONSOR_NAME] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS
NOT NULL ,
        [ORIG_UPDATE] [smalldatetime] NOT NULL ,
        [LAST_UPDATE] [smalldatetime] NOT NULL ,
        [IS_ACTIVE] [bit] NOT NULL 
) ON [PRIMARY]
GO