cfstoredproc

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?

This topic has been closed for replies.

Correct answer ilssac

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.

Inspiring

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"

ilssacCorrect answer

Inspiring

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.

Sign up