RE: [Reactor for CF] Tables with multiple relationships to the same table

[Hayes, Kyle D]

Haha! Awesome! Thank you so much.   Kyle Hayes Web Developer / Programmer WebAID - Anaheim Boeing Information Technology 714.762.2894 [EMAIL PROTECTED]   From: João Fernandes [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 05, 2006 2:39 PM To: reactor@reactorframework.com Subject: RE: [Reactor for CF] Tables with multiple relationships to the same table Kyle,   Try something like this   <object name=”employeeStep”>             <hasOne name=”employee”>                         <relate from=”employeeid” to=”employeeid”>             </hasOne>             <hasOne name=”employee” alias=”leader”>                         <relate from=”leader” to=”employeeid”>             </hasOne> </object>   After your employeeStepRecord initialized you can use employeeStepRecord.getEmployee() and employeeStepRecord.getLeader().     HTH,   João Fernandes From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Hayes, Kyle D Sent: terça-feira, 5 de Setembro de 2006 22:32 To: reactor@reactorframework.com Subject: [Reactor for CF] Tables with multiple relationships to the same table   I have two tables that are related to each other in a couple of different ways. The first table is table "Employee" and the second is "EmployeeStep". Employee has a PK column called EmployeeId. EmployeeStep has two columns called EmployeeId and leader. These tables have more columns but I have only provided the relevant information.   Columns EmployeeId and leader in EmployeeStep both relate back to Employee's employeeId column. In reactor after initiating an employeeStep Object, is there anyway of getting an instance of an employeeRecord from the employeeId OR the leader column?   Kyle Hayes Web Developer / Programmer WebAID - Anaheim Boeing Information Technology 714.762.2894 [EMAIL PROTECTED]   -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- 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/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List reactor@doughughes.net Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --