Posted by jbonifacejr on 11/30/06 22:27

If you look at the top post you will see where I put the code I am
using. I also tried to let people know what happened when I tried their
suggestions. But, thanks for the advice...and I'll look at those SQL
Books online.

Jan

Erland Sommarskog wrote:
> jbonifacejr (jbonifacejr@hotmail.com) writes:
> > Thank you for your help. Any chance you have a moment to help just a
> > little more? Here is what I did, but I still can't access the value
> > output by the stored proc...
> >
> > I removed the Return @sRetUPC line. I am guessing that I can rely on
> > the set @sRetUPC line to set the value of the output parameter
> >
> >>From there, I appended the parameters in the ASP code...like this
> > oSproc.Parameters.Append(oParam2)
> > oSproc.Parameters.Append(oParam1)
> > --originally I tried to do Param1 then Param2, but I got an error
> > about the parameter
> > --type being an output, so I just figured I had them in the wrong
> > order because the
> > --first parameter in the code was the output one.
> >
> > Then, I added the line oSproc.Execute()
> > After that is:
> > Dim res
> > res = oSproc.Parameters.Item("sRetUPC").Value.toString()
> >
> > This is not working. Do you know how I can get access to the value of
> > the parameter that is returned?
>
> Never say "not working" in newsgroup post with explaining what it
> means. Do you get an unexpected result? An error message? Something
> else?
>
> Since I don't even know how your code looks like right now, just two
> notes:
>
> 1) Use parameter names with leading @. The underlying provider may
> prefer that.
>
> 2) Use adParamInputOutput for the output value. T-SQL does not have any
> true output-only parameters. (Save the return value, but there is a
> separate enum value for return values as I recall.)
>
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
>
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]