probs on asp-sql command

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • MATTXtwo
    New Member
    • Sep 2006
    • 83

    probs on asp-sql command

    Code:
    dim val
    set rm = Server.CreateObject ("ADODB.Command")
    rm.ActiveConnection=OBJdbConnection
    rm.CommandText="exec get_user"
    
    rm.Parameters.Append rm.CreateParameter("RETURN",adInteger,adParamReturnValue,4)
    
    rm.Parameters.Append rm.CreateParameter("@user_id",adVarChar,adParamInput,8,NoStaf)
    
    rm.Parameters.Append rm.CreateParameter("@pwd",adVarChar,adParamInput,12,Pwd)
    rm.Execute 
    val=rm.Parameters("RETURN").Value
    ------------------------------------------------------------------------------------------------------------------ADODB.Command error '800a0bb9'

    Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.

    /Intranet/MainVal2.asp, line 14
    Last edited by acoder; Sep 24 '08, 01:44 PM. Reason: Added [code] tags
  • acoder
    Recognized Expert MVP
    • Nov 2006
    • 16032

    #2
    Moved from the Feedback forum to the ASP forum. Please post you questions in the correct forum and remember to use code tags when posting code.

    Moderator.

    Comment

    • MATTXtwo
      New Member
      • Sep 2006
      • 83

      #3
      Hi Hi, Gomenasai(Sorry )

      Comment

      Working...