Problems with ado output parameters

Results 1 to 2 of 2

Thread: Problems with ado output parameters

  1. #1
    Join Date
    Dec 1969

    Default Problems with ado output parameters

    I wrote a stored proc that takes 2 output parameters :<BR>@RowField varchar(50) output,<BR>@ColField varchar(50) output<BR><BR>Then I create ado command in my asp page with 2 output parameters :<BR>cdRep.Parameters.Append cdRep.CreateParameter( "@RowField", adVarChar, adParamOutput,50)<BR>cdRep.Parameters.Append cdRep.CreateParameter( "@ColField",adVarChar, adParamOutput,50)<BR><BR>but the results I get after executing the command are very confusing, sometimes I get the output right and other times I don&#039;t .<BR>I checked the stroed proc , but there is nothing wrong and so is the data.<BR>I don&#039;t know what is wrong.

  2. #2
    Jeremy_D Guest

    Default Code of sp??? <eop>


Posting Permissions

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