Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2005
    Posts
    14

    Unanswered: Return values in SP

    hello,
    is it possible to return a return value as a numeric datatype

    I can successfully return as an integer, but when i change it to numeric i get this error

    Code:
    Error Type:
    Microsoft OLE DB Provider for ODBC Drivers (0x80040E21)
    [Microsoft][ODBC SQL Server Driver]Invalid scale value
    /output.asp, line 15
    my output value in my asp code is thus

    Code:
    Command1.Parameters.Append Command1.CreateParameter("@RETURN_VALUE", 131, 4)


    thanks
    Afrika

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Coo - just read this one on SQLTeam. I thought they sorted it....

    Anyhoo - what is your sproc code - that is probably more pertinent.
    Testimonial:
    pootle flump
    ur codings are working excelent.

Posting Permissions

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