http://www.remotesynthesis.com/blog/index.cfm/2006/2/17/Getting-Started-with-Reactor
~Dave
On 5/26/06, Pallavi Naresh <[EMAIL PROTECTED]> wrote:
I'm trying to understand how to perform joins with Reactor.
I have two tables, "Employee" and "Position". "Employee" has a positionId that corresponds to the employee's position. The "Position" table translates the positionID to a name (such as "Manager").
I want to display a list of all employees and their position. I can see how I could create an Employee gateway, and then iterate over each employee and query for its PositionName. This is somewhat tedious and inefficient. It would be more efficient to perform a SELECT that joins the two tables.
Is there a way to accomplish this with Reactor?
-- Reactor for ColdFusion Mailing List -- [email protected] -- Archives at http://www.mail-archive.com/reactor%40doughughes.net/
--
~Dave Shuck
[EMAIL PROTECTED]
www.daveshuck.com
www.worldwildweb.biz -- Reactor for ColdFusion Mailing List -- [email protected] -- Archives at http://www.mail-archive.com/reactor%40doughughes.net/
