My gut tells me this is not possible, but I thought I'd ask. Is there any way to find out how many resultsets the stored proc is returning in order to build the CFPROCRESULT tags?
My problem is this: My DBA has given me an SP that may return 1,2,3, or N resultsets depending on certain criteria. Obviously I need to have a CFPROCRESULT tag for each of the resultsets, but I don't know how many will be returned.
I think he's going to have to readress his SP since there's no way for me to handle this situation on my end.
Any thoughts?
My problem is this: My DBA has given me an SP that may return 1,2,3, or N resultsets depending on certain criteria. Obviously I need to have a CFPROCRESULT tag for each of the resultsets, but I don't know how many will be returned.
I think he's going to have to readress his SP since there's no way for me to handle this situation on my end.
Any thoughts?