I'd return a struct. Put each query result into one key of the struct. On Mon, Jul 14, 2008 at 12:43 PM, Ian Rutherford <[EMAIL PROTECTED]> wrote: > 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?
-- mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:308992 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4