I did that yesterday once I realized that the getXyzRecord() method wasn't working. I completely removed the Reactor directory and retrieved the latest BER from the SVN. Attached are the the SQL Create Statements for MSSQL. The Events Table also has a bunch of hasMany relationships which seem to work fine, but the hasOne isn't loading the relevant record.
~Jeff~
On 3/30/06, Chris Phillips <[EMAIL PROTECTED]> wrote:
I would try two things.
One, get the latest files from SVN and delete all the generated files in the reactor folder under projects.
If that doesn't work. Maybe, you could generate the sql Create statements for the 2 tables so that we can see the actual fields, types, and relationships.
I have the same relationships working just fine in SQL Server 2000 with both int and guid keys.On 3/29/06, Jeff Lester < [EMAIL PROTECTED]> wrote:Hey guys,
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/--
Chris Phillips
www.dealerpeak.com
Senior Application Developer -- Reactor for ColdFusion Mailing List -- [email protected] -- Archives at http://www.mail-archive.com/reactor%40doughughes.net/
ÿþC R E A T E T A B L E [ d b o ] . [ E v e n t C a t e g o r i e s ] (
[ C a t e g o r y I D ] [ i n t ] N O T N U L L ,
[ C a t e g o r y ] [ v a r c h a r ] ( 5 0 ) C O L L A T E
S Q L _ L a t i n 1 _ G e n e r a l _ C P 1 _ C I _ A S N U L L
) O N [ P R I M A R Y ]
G O
ÿþC R E A T E T A B L E [ d b o ] . [ E v e n t s ] (
[ E v e n t I D ] [ i n t ] I D E N T I T Y ( 1 , 1 ) N O T
N U L L ,
[ D a t e O c c u r r e d ] [ d a t e t i m e ] N U L L ,
[ E v e n t T y p e I D ] [ i n t ] N U L L ,
[ C l a s s i f i c a t i o n I D ] [ i n t ] N U L L ,
[ C a t e g o r y I D ] [ i n t ] N U L L ,
[ I n c i d e n t I D ] [ i n t ] N U L L ,
[ I d e n t i f i c a t i o n ] [ v a r c h a r ] ( 1 0 0 )
C O L L A T E S Q L _ L a t i n 1 _ G e n e r a l _ C P 1 _ C I _ A S
N U L L ,
[ R i s k A s s e s s m e n t C o d e ] [ v a r c h a r ] ( 6 )
C O L L A T E S Q L _ L a t i n 1 _ G e n e r a l _ C P 1 _ C I _ A S
N U L L ,
[ D e p a r t m e n t I D ] [ i n t ] N U L L ,
[ A l e r t T i t l e ] [ v a r c h a r ] ( 5 0 ) C O L L A T E
S Q L _ L a t i n 1 _ G e n e r a l _ C P 1 _ C I _ A S N U L L ,
[ I n c i d e n t D e s c r i p t i o n ] [ t e x t ]
C O L L A T E S Q L _ L a t i n 1 _ G e n e r a l _ C P 1 _ C I _ A S
N U L L ,
[ S a f e t y S u g g e s t i o n s ] [ t e x t ] C O L L A T E
S Q L _ L a t i n 1 _ G e n e r a l _ C P 1 _ C I _ A S N U L L ,
[ F i l e R e f e r e n c e ] [ v a r c h a r ] ( 5 0 )
C O L L A T E S Q L _ L a t i n 1 _ G e n e r a l _ C P 1 _ C I _ A S
N U L L ,
[ S e c t i o n I D ] [ i n t ] N U L L ,
[ D e p a r t m e n t C a t e g o r y I D ] [ i n t ] N U L L ,
[ F a c i l i t y ] [ v a r c h a r ] ( 5 0 ) C O L L A T E
S Q L _ L a t i n 1 _ G e n e r a l _ C P 1 _ C I _ A S N U L L ,
[ W o r k i n g W e e k ] [ t i n y i n t ] N U L L ,
[ A c t i v e ] [ b i t ] N U L L ,
[ F i n a l i s e d ] [ d a t e t i m e ] N U L L ,
[ P o l i c y I D ] [ i n t ] N U L L ,
[ D e d u c t i b l e ] [ m o n e y ] N U L L ,
[ C u r r e n t E s t i m a t e ] [ m o n e y ] N U L L ,
[ T o t a l C o s t ] [ m o n e y ] N U L L ,
[ T o t a l C l a i m e d ] [ m o n e y ] N U L L ,
[ T o t a l D a y s L o s t ] [ i n t ] N U L L ,
[ C o m p l e t e d ] [ d a t e t i m e ] N U L L ,
[ C o m p l e t e d B y ] [ v a r c h a r ] ( 5 0 )
C O L L A T E S Q L _ L a t i n 1 _ G e n e r a l _ C P 1 _ C I _ A S
N U L L ,
[ S t a t u s ] [ i n t ] N U L L ,
[ D a t e E n t e r e d ] [ d a t e t i m e ] N U L L ,
[ E n t e r e d B y ] [ i n t ] N U L L ,
[ R e p o r t e d T o ] [ v a r c h a r ] ( 5 0 ) C O L L A T E
S Q L _ L a t i n 1 _ G e n e r a l _ C P 1 _ C I _ A S N U L L ,
[ R a i s e d B y ] [ v a r c h a r ] ( 5 0 ) C O L L A T E
S Q L _ L a t i n 1 _ G e n e r a l _ C P 1 _ C I _ A S N U L L ,
[ E m p l o y e r ] [ v a r c h a r ] ( 3 0 ) C O L L A T E
S Q L _ L a t i n 1 _ G e n e r a l _ C P 1 _ C I _ A S N U L L
) O N [ P R I M A R Y ] T E X T I M A G E _ O N [ P R I M A R Y ]
G O
