|
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 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 -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- 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 CF] Tables with multiple relationships to the... Hayes, Kyle D
- RE: [Reactor for CF] Tables with multiple relationshi... João Fernandes
- RE: [Reactor for CF] Tables with multiple relationshi... Hayes, Kyle D
