On 3 Jul 2006, at 18:26, Ryan Everhart wrote:

I am working on a CFC where I need to return 2 queries from a stored proc to the page. Is it possbile to return two query sets from a CFC function?

If you really need to get both queries back in a single return, you could create an array to contain both:

<cfset result = arrayNew(1)/>
<cfset arrayAppend(result, queryOne)/>
<cfset arrayAppend(result, queryTwo)/>
<cfreturn result/>

You probably don't intend to make updates to the data inside the array, so it won't matter if the result is returned by reference or by value.

--
Joseph Lamoree


----------------------------------------------------------
You are subscribed to cfcdev. To unsubscribe, send an email to 
[email protected] with the words 'unsubscribe cfcdev' as the subject of the 
email.

CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting 
(www.cfxhosting.com).

An archive of the CFCDev list is available at 
www.mail-archive.com/[email protected]


Reply via email to