1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

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