Never mind, I guess I'm good... found this interesting website/wiki http://www.objectorientedcoldfusion.org/wiki/Gateway <http://www.objectorientedcoldfusion.org/wiki/Gateway>Pretty good info
On Mon, Dec 13, 2010 at 11:10 AM, Greg Morphis <gmorp...@gmail.com> wrote: > 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:340032 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
