Re: Stored procedure output problem in ASP


> but when i am running through the ASP it is giving the followign result:
>
0000,01023,01135,01359,01388,01390,01420,01426,01432,01492,01494,01496,01498
,01501,01504
>
> I have checked and debug throughly. what may be the reason for this
> difference..

I think the ASP version is such that the 0 is the return value from the
Stored Procedure. I think you want as the very first parameter:

Set objParam =
dbcmd.CreateParameter("@RETURN_VALUE",adInteger,adParamReturnValue,4)
dbcmd.Parameters.Append objParam

You have not said anything about what database you are attached to.
I am presuming SQL Server.

Stephen Howe


.