I have a table, members which I need to extract emails for a particular group. To get the emails I need to use reference tables. I might need to pull more information at a later date so I was going to return a query or an array of Beans to include everything from the members table. The query would look something like this.. select email, mem_id, ... from members m join members_group mg on m.mem_id = mg.mem_id join groups g on mg.group_id = g.group_id where g.group_id = 12
So in taking an OOP approach, would the best way be modifying the getAttributesByQuery function and throwing in a group_id argument in the Gateway, modifying the query to include these 2 reference tables in the argument is not null? Or creating a whole new function to populate a structure of Member beans, a getMemberByGroup function? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340030 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
