elp with Multiple Result Sets inside a Stored Procedure

[ctrl+alt+delete]

I have a stored procedure that returns an output variable as well as a
result set. It is one that works fine with a .NET application and I am
trying to use it with ColdFusion.

Can someone tell me how to retrieve the output variable or multiple result
sets from one call to a stored procedure using ColdFusion?

The only result set I get returned is the one last processed in the stored
procedure.

[mxstu]

Take a look at CFSTOREDPROC. You should be able to retrieve output parameters with [url]http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-b16.htm#wp1102102[/url].

[philh]

Hey mxstu, it's Stealer's Wheel (Gerry Rafferty on vocals), not Dylan: :D


[url]http://groups.google.com/group/rec.music.dylan/browse_thread/thread/88dcd4b68abb[/url]
8b9e/d0f287cf8aaeb641?lnk=st&q=stuck+in+the+middle+with +you+author&rnum=4&hl=en#
d0f287cf8aaeb641

[mxstu]

philh,

Oh geeez... I hate copy and paste... it never works right before my coffee... thanks

[ctrl+alt+delete]

Thanks for the help guys. I guess I was having a brain fade and wasn't using
the attributes in my cfprocparam correctly. I wasn't using the variable and
dbvariable attributes properly.

"mxstu" <webforumsuser@macromedia.com> wrote in message
news:denm3e$p84$1@forums.macromedia.com...

> philh,
>
> Oh geeez... I hate copy and paste... it never works right before my
> coffee... thanks