ASP Parameters

Discussion in 'C#' started by jpchenot, Jun 26, 2008.

  1. #1
    Hi guys. When executing the following code, i get this error:

    Microsoft VBScript runtime error '800a01b6'

    Object doesn't support this property or method: 'sqlRegistrantUser.Paratemers'

    /register.asp, line 211

    Anyone can help please. I am a asp.net developer and i don't understand why this is happening.

    Code: ( text )
    Set conn = server.CreateObject("ADODB.Connection")
    Set sqlRegistrantUser = server.CreateObject("ADODB.Command")
    Set objparam = server.CreateObject("ADODB.Parameter")
    conn.ConnectionString = Application ("ALloyd")
    conn.Open
    sqlRegistrantUser.CommandText = "dbo.usp_InsertRegisteredUser"
    sqlRegistrantUser.CommandType = adCmdStoredProc
    sqlRegistrantUser.ActiveConnection = conn

    Set objparam = sqlRegistrantUser.CreateParameter("@titleChecked", adVarChar, adParamInput, 4, titleChecked)
    sqlRegistrantUser.Paratemers.Append objparam
    Set objparam = sqlRegistrantUser.CreateParameter("@firstNameChecked", adVarChar, adParamInput, 50, firstNameChecked)
    sqlRegistrapntUser.Paratemers.Append objparam
    Set objparam = sqlRegistrantUser.CreateParameter("@lastNameChecked", adVarChar, adParamInput, 50, lastNameChecked)
    sqlRegistrantUser.Paratemers.Append objparam
    Set objparam = sqlRegistrantUser.CreateParameter("@emailChecked", adVarChar, adParamInput, 200, emailChecked)
    sqlRegistrantUser.Paratemers.Append objparam
    Set objparam = sqlRegistrantUser.CreateParameter("@passwordChecked", adVarChar, adParamInput, 50, passwordChecked)
    sqlRegistrantUser.Paratemers.Append objparam

    sqlRegistrantUser.Execute

    Set conn = Nothing
    Set sqlRegistrantUser = Nothing
    Set objparam = Nothing
     
    jpchenot, Jun 26, 2008 IP
  2. Sleeping Troll

    Sleeping Troll Peon

    Messages:
    217
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Try sqlRegistrantUser.Append objparam
     
    Sleeping Troll, Jun 26, 2008 IP