Thanks for the help, Sean's right, my problem isn't loading without a primary key, its that the getXyzRecord() function only returns a blank record object, even though a record does exist in the table. I have checked my keys, my data, and my xml object configuration in the Reactor config file. I will send some more details when I get to work, but for now I'll try to give a bit more detail. On the reactor Documentation on pages 29 & 30 I followed those instructions to make my config look like the following:
<reactor>
<config>
<project value="campIncident" />
<dsn value="ER" />
<type value="mssql" />
<mapping value="/camp/data/Incident/" />
<mode value="development" />
</config>
<objects>
<object
name="Events">
<hasOne
name="EventCategories">
<relate
from="CategoryID" to="CategoryID" />
</hasOne>
</object>
</objects>
</reactor>
Now I can do a createRecord just fine set the EventID and load the Record and that works. However, when I call getEventCategoriesRecord() it loads a blank record even though CategoryID in the Events Table does link to an existing record in the EventCategories Table. What other files can I supply to help?Cheers,
Jeff
On 3/30/06, Sean Corfield <[EMAIL PROTECTED]
> wrote:
On 3/29/06, Cody Caughlan <[EMAIL PROTECTED]> wrote:
> No, I think he is referring to the whole primary-key-foreign-key issue that
> stumped me too. Remember, Sean how you suggested I tweak my XSL to refer to
> the proper column in the getFooRecord() method??
>
> If you search the archives for "mapping question" I think it will point you
> in the right direction. Here is my original post, let me know if its the
> same issue:
Doug fixed that in the SVN repo a while back, based on my suggested
change (to add the keys into the load() call, in the XSL).
If you ensure you have the latest version from SVN and blow away your
project/* files, you should find you original example works.
So I do not believe that is Jeff's problem.
--
Sean A Corfield -- http://corfield.org/
Got frameworks?
"If you're not annoying somebody, you're not really alive."
-- Margaret Atwood
-- Reactor for ColdFusion Mailing List -- [email protected]
-- Archives at http://www.mail-archive.com/reactor%40doughughes.net/
-- Reactor for ColdFusion Mailing List -- [email protected] -- Archives at http://www.mail-archive.com/reactor%40doughughes.net/
