Okay, that makes sense. I made those changes and now get a new error message ...
ReactorAdapter: Unable to establish metadata for "hasOne" "contactaddress" relationship for "contact". I checked the database and all of the "names" match the database table and field names, so this does not appear to be a naming issue. I am using MySQL 5 and I even checked that the case for all of the table and field names matches the xml config as well. So, what does this error message really mean? Thanks -- Jeff -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Doug Hughes Sent: Saturday, June 24, 2006 8:16 PM To: [email protected] Subject: RE: [Reactor for CF] Basic Object Relationship Issue I haven't had time to review the parent email, but I can say that sean's wrong here. The linking object needs to have a hasOne relationship to the two objects that are being linked. The two objects being linked need hasMany relationships to the linked object with the link tag specifying the linking object. IE: <object name="User> <hasMany name="Address"> <link name="UserAddress" /> </hasMany> </object> <object name="UserAddress"> <hasOne name="User"> <relate from="userId" to=" userId " /> </hasOne> <hasOne name="Address"> <relate from="addressId" to="addressId" /> </hasOne> </object> <object name=" Address "> <hasMany name="User"> <link name="UserAddress" /> </hasMany> </object> Doug -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sean Corfield Sent: Saturday, June 24, 2006 8:56 PM To: [email protected] Subject: Re: [Reactor for CF] Basic Object Relationship Issue On 6/24/06, Jeff Chastain <[EMAIL PROTECTED]> wrote: > I have a simple db with 5 tables ... contact, address, state, country, > and contactAddress. The contact can have one or more addresses and > vice versa (hence the linking table contactAddress). The address then > has a state and > a country. So what have I missed here ... I think the <link> tag needs a <relate> child to specify which columns key in/out of the link table. > <hasMany name="address"> > <link name="contactAddress" /> ... need <relate> tag here? ... > </hasMany> -- 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/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List [email protected] Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
