I am getting a better grasp on this OOP stuff everyday (but it is taking a while) and now I am at the point where I can't figure out how to interact with 1-to-many and many-to-many relationships.
Example: I have two tables (product & productitems). The productitems table contains a foreign key field so there is one product to many product items. I need to loop through the productitems where the foreign key matches the productid in the product table. Do I create an method in my gateway with an INNER JOIN query. If so, would that go in the product gateway or the productitems gateway? Also, I am using services to further abstract things. So would I create a new service component to get at the method in my gateway or would I add a method in one of my existing services. Maybe I am completely wrong and all I need to do is add a couple getters and setters in my products bean. I really don't have a clue... Any help would be appreciated! -Aaron ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262982 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
