Passing multiple cfprocresults out of a CFC

[leontova]

Hi All. I have a stored procedure which returns two datasets. If I wasn't
using a CFC, I'd just use two cfprocresult tags and access each as needed. But
it is my understanding that a function can only return one query(among other
datatypes) and it is assigned one variable name. How do I access multiple
record sets from one CFC function? (I'm using CFMX 6.1) Thanks for your help!
-Andy

[danilocelic *TMM*]

leontova wrote:

> Hi All. I have a stored procedure which returns two datasets. If I wasn't
> using a CFC, I'd just use two cfprocresult tags and access each as needed. But
> it is my understanding that a function can only return one query(among other
> datatypes) and it is assigned one variable name. How do I access multiple
> record sets from one CFC function? (I'm using CFMX 6.1) Thanks for your help!

How about returning a struct that has two memebers, one for each result?

--
Danilo Celic
| Extending Knowledge, Daily [url]http://CommunityMX.com/[/url]