ASP Parameters

[jpchenot]

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.

 
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
 

[jeffstl]

Do you have these at the top of your .aspx page in which you are working with?

<% @Import Namespace="System.IO" %>
<% @ Import Namespace="System.Data" %>
<% @ Import Namespace="System.Data.SqlClient" %>

That is required to import the librarys needed for your code. I think the 3rd one is all you need but the other 2 are also for some pretty basic functions.

[jhardman]

Could you clarify please? you state you are an ASP.NET developer, but your error message appears to come from an ASP page. Is this ASP or ASP.NET? (The file extension for ASP.NET should be .aspx)

Jared

[jhardman]

 
sqlRegistrantUser.Paratemers.Append objparam 
 

Maybe the issue is that you misspelled "Parameters".

Jared

[Curtis Rutland]

Maybe the issue is that you misspelled "Parameters".

Jared

Nice catch. I never would have noticed that.