Re: [Reactor for CF] has one object not working

[[EMAIL PROTECTED]]

I'm not sure it's absolutely required, but try adding an <object>  
definition for the "tblAdvTrack" table (and call it as such in the  
"tblStreamMedia" definition):

        <objects>
                <object name="tblStreamMedia">
                        <hasOne name="tblAdvTrack">
                                <relate from="track_id" to="id" />
                        </hasOne>
                </object>
                <object name="tblAdvTrack" />
        </objects>

Wouter



On Dec 12, 2006, at 15:43, Andrew Davis wrote:

Well, Ive been working on this a little, but not too much success.  
I went
thru the quickstart and changed a few things in my setup, hoping it  
was
something small I was msissing... Any suggestions folks?


[tables]

tblStreamMedia
-----------
id (prim.key)
title
track_id (foreign key)


tblAdvTrack
--------------
id (Prim.key)
hit_count



[setup]

<reactor>
        <config>
                <project value="advtracking" />
                <dsn value="tempdb" />
                <type value="mssql" />
                <mapping value="/scratch" />
                <mode value="always" />
        </config>
        <objects>
                <object name="tblStreamMedia">
                        <hasOne name="tblDevAdvTrack">
                                <relate from="track_id" to="id" />
                        </hasOne>
                </object>
        </objects>
</reactor>



[index.cfm]

<cfset Reactor = CreateObject("Component",
"reactor.reactorFactory").init(expandPath("reactor.xml")) />

<!--- create a record --->
<cfset StatsRecord = Reactor.createRecord("tblStreamMedia") />
<cfset StatsRecord.id(748)/>
<cfset StatsRecord.load() />

<cfdump var="#StatsRecord#" expand="yes">

<cfoutput>
        #statsrecord.gettitle()# , #StatsRecord.gethit_count()#
</cfoutput>





-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --  
-- -- -- -- --
Reactor for ColdFusion Mailing List
reactor@doughughes.net
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --  
-- -- -- -- --




-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
reactor@doughughes.net
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --