I am trying to move some of my database access to cfcs and am trying to figure out how to get a set of five query results in a stored procedure out of a cffunction. I think I would use an array but am having a hard time visualizing how it would work.
The stored proc returns: An order. Each order can have n parts. Each part can have n line items. The order can also have multiple gift certificates and status comments attached to it. I could loop through the order parts calling another cffunction to get each piece but that would result in a lot of database calls that I don't think I need to make. Am I right about using an array? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308991 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
