cfstoredproc

[Guest]

If you use cfstoredproc to call a stored procedure that has 2 que

ries in it, how do you display the results of both queries?

[ilssac · Accepted solution]

I would guess you would have to return each query as seperate "out," or maybe "in-out," parameters.

Then you would work with the name of each parameter.

[-__cfSearching__-]

It depends... You could use separate cfprocresult tags and assign a different name to each one. Then output the queries as usual.

cfprocresult name="query1"

cfprocresult name="query2"