I use structures to pass back multiple things from functions, but I'm not so sure you're right about not using an array. An array maps to the cfprocresult's resultset attribute(as it could equally to it's name attrib) but with the array you don't need to know the name used only the number of the resultset.
I hope that makes sense, I've just had a not so powerful power nap and I tell ya, it hasn't done anything for my thinking just this minute. Ade -----Original Message----- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] Sent: 03 March 2005 13:50 To: CF-Talk Subject: RE: Stored Procedures in a CFC > Good question, I believe you will have to enter the two > resultset objects > into a single CF complex object (such as a Structure) and > return that as a > single value. That would be my choice. I think a structure makes more sense for that as this code: <cfset data = myCFC.getQueries()> <cfloop query="data.getUsers">...</cfloop> <cfloop query="data.getRoles">...</cfloop> Is much more legible (and self-documenting) than this code: <cfset data = myCFC.getQueries()> <cfloop query="data[1]">...</cfloop> <cfloop query="data[2]">...</cfloop> s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://macromedia.breezecentral.com/p49777853/ http://www.sys-con.com/story/?storyid=44477&DE=1 http://www.sys-con.com/story/?storyid=45569&DE=1 http://www.fusiontap.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:197238 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
