Returns more than one resultset. How?

[umuayo]

I have a Stored Proc that returns 4 resultsets, how will I invoke them from a cfm page to get each resultset?
Below is my proc. The Proc is in a CFC

[-__cfSearching__-]

> how will I invoke them from a cfm page to get each resultset

What do you mean invoke? The code above should create four query objects: results1, result2, results3, results4. You can use them as you would any other query object (output, loop through them, etc..)

<cfoutput query="results1">
....
</cfoutput>
<cfoutput query="results2">
....
</cfoutput>
...

[umuayo]

Hi,

The Proc is in a CFC. I need to invoke the cfc from the cfm page to return cfstoredproc query results.

[Newsgroup_User · Accepted solution]

umuayo wrote:
> Hi,
>
> The Proc is in a CFC. I need to invoke the cfc from the cfm page to return cfstoredproc query results.

Then just do that.

Of course you can only return one value from a function so you will need
to put those four results into an array or structure or something to
group them together.

Then use the complex variable of your choice in the cfm page.

[umuayo]

Thanks thats basically what I have just done and it is getting all the desired results.
<!--- PASS RECORDS AS AN ARRAY --->
<cfset results = ArrayNew(1) />
<cfset results[1] = results1 />
<cfset results[2] = results2 />
<cfset results[3] = results3 />
<cfset results[4] = results4 />
<cfreturn results />