In this case, I would probably just create a denormalized recordset rather than multiple structures.
This recordset would have redundant information for the order and order parts such as: OrderID CustomerID OrderDate OrderPartID OrderPartInfo OrderLineItemID OrderLineItemDesc OrderLineItemPrice Then, use CFOUTPUT's GROUP attribute to remove the redundancy. m!ke -----Original Message----- From: Ian Rutherford [mailto:[EMAIL PROTECTED] Sent: Monday, July 14, 2008 5:05 PM To: CF-Talk Subject: Re: Multiple queries from a CFC? Drop in Array? But since each order can have multiple parts which can have multiple line items, how would that go into a structure? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:309045 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
