Or you can just create one method in your gateway object to execute a query or stored procedure and your are done.
Teddy On 12/5/06, Aaron Roberson <[EMAIL PROTECTED]> wrote: > > 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:262985 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
