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
    Dec 2004
    Location
    California, USA
    Posts
    93
    No, not through the return code. This is always an integer. Parameters can be speccified as being for OUTPUT. These can be of other data types, such as NUMERIC.
    Whoever imagines himself a favorite with God holds others in contempt. - Robert Green Ingersoll, lawyer and orator (1833-1899)

Posting Permissions

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