Posted by Erland Sommarskog on 06/16/05 00:42

Axel (realraven2000@hotmail.com) writes:
>>I can tell you should do it in ASP, since I don't know how you call the
>> procedure. Assuming that you use ADO, there is an adDirectionOutput
>>somewhere.

That was supposed to read "I can't tell". Nevermind, it's an ADO problem,
and ADO I know something about.

I believe that you are using a server-side cursor. At least when I tried
an example I was not able to retrieve the value of the output parameter
with a server-side cursor. Unless you have very compelling reasons, you
should anyway use client-side cursors, which use specify by setting
cnn.CursorLocation to adUseClient. In this case you get the output
parameter.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

[Back to original message]