Professional Web Applications Themes

elp with Multiple Result Sets inside a Stored Procedure - Coldfusion Database Access

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....

  1. #1

    Default elp with Multiple Result Sets inside a Stored Procedure

    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.


    ctrl+alt+delete Guest

  2. #2

    Default Re: elp with Multiple Result Sets inside a StoredProcedure

    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].
    mxstu Guest

  3. #3

    Default Re: elp with Multiple Result Sets inside a StoredProcedure

    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

    philh Guest

  4. #4

    Default Re: elp with Multiple Result Sets inside a StoredProcedure

    philh,

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

  5. #5

    Default Re: elp with Multiple Result Sets inside a Stored Procedure

    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" <webforumsusermacromedia.com> wrote in message
    news:denm3e$p84$1forums.macromedia.com...
    > philh,
    >
    > Oh geeez... I hate copy and paste... it never works right before my
    > coffee... thanks

    ctrl+alt+delete Guest

Similar Threads

  1. DataAdapter and multiple result sets
    By Michael C# in forum ASP.NET Web Services
    Replies: 2
    Last Post: May 10th, 06:05 PM
  2. Stored Procedure Result Variable
    By Two Tech Guys in forum Coldfusion Database Access
    Replies: 1
    Last Post: February 21st, 05:46 AM
  3. Replies: 0
    Last Post: September 11th, 04:35 PM
  4. Replies: 0
    Last Post: August 26th, 05:58 AM
  5. Replies: 0
    Last Post: August 20th, 01:37 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139