Below is a snippet of coding. I keep receiving the error: 450 wrong number of argument or invalid property assignment"
In the table:
ClientName is nvarchar(65)
MonthlyPaid is nvarchar(1)
ExpireDate is datetime
I know my connection string is valid as are the values, vowners, vexpire, vpaid. I made sure with date using CDATE function.
vsep = "'"
set rsH = Server.CreateObject("ADODB
.Connectio
n")
rsH.Open vconnect
sqltxt = "Update Clients.dbo.ClientInfo set ClientName = " & vsep & vowners & vsep & _
'",MonthlyPaid = " & vsep & vpaid & vsep & _
",ExpireDate = " & vsep & vexpire& vsep & _
" where RecId = " & vsep & vrecid & vsep
rsH.Execute(sqltxt)
Why am I getting this error? I sometimes recieve it when using a select statement and then the connection to execute the sql statement. This is very confusing as it executes correctly in QA.
Any help appreciated....
Start Free Trial
