I would do it differently (then returning a struct/array with both recordset). Please give comments/suggestions/whatevers as I'm just thinking out loud.
In essence, your SP returns two recordsets which don't hold the same data, they could be related but they are not the same. Why not create two methods for your CFC each returning one of these recordsets. They would both use another private method which would run the SP and then store its results in private variables. It would also ensure that the SP isn't run again and again if it's been run recently. Two me that's better encapsulation. The Application doesn't have to know how the CFC gets the recordsets all it knows is that by calling either of the methods it will get back the data it needs. -- Marc ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:197245 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
