Josh, You need to use the join functionality when you create a query, and then use the getByQuery method, instead of the getAll method.
Do a search for getByQuery in the archives of this list and you should be able to find the syntax. Michael -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Joshua Scott Sent: Thursday, March 09, 2006 6:01 PM To: [email protected] Subject: [Reactor For CF] Relational Tables and GetAll() Hello, I am experimenting with Reactor and loving it. I am going to be using it (with model glue) for a huge project and it is going to save me a ton of time. My question is this I have a user table that is linked to a contactInfo table by the userid. So in my reactor.xml file I have... <object name="User"> <hasOne name="ContactInfo"> <relate from="userid" to="userid" /> </hasOne> </object> When I call the GetAll() method on the User object it only returns the fields in the user table not the ones in the contactInfo table. Any ideas? - Josh _________________________________________ Joshua Scott | www.resonantmedia.com [EMAIL PROTECTED] -- 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/
