put 'em in a struct and return the struct. <cfset var myStruct = structNew() /> <cfset var query1 = "" /> <cfset var query2 = "" />
<cfquery name="query1" ... </cfquery> <cfquery name="query2" ... </cfquery> <cfset myStruct.q1 = query1 /> <cfset myStruct.q2 = query2 /> <cfreturn myStruct /> On Wed, Oct 29, 2008 at 6:29 PM, Rick Faircloth <[EMAIL PROTECTED]>wrote: > Hi, all... > > If I'm running two queries inside a function, > how do I return both query values? > > Query 1: get_properties > Query 2: get_all_photos > > <cfreturn get_properties /> > <cfreturn get_all_photos /> > > Can there be two cfreturn's? > > or, perhaps, <cfreturn get_properties, get_all_photos /> > > ??? > > Rick > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314586 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4