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

Reply via email to