sql error

[Andy6666uk]

Hi there

I keep getting an error telling me that there are "too few parameters" in the second sql statement below. But the table name and all the db field names are correct. Also the two strings being used are making it to the line of code.

Dim oCmd, sql3
Set oCmd = Server.CreateObject("ADODB.Command&quot
sql3 = "UPDATE Person SET Groups = '" & strGroups & "' WHERE (((Person.PersonID)=" & strPersonID & &quot);"
oCmd.CommandText = sql3
oCmd.CommandType = adCmdText
Set oCmd.ActiveConnection = db
oCmd.Execute

sql3 = "UPDATE Groups SET Members = '" & strMembers & "' WHERE (((Groups.GroupID)=" & strGroupID & &quot);"
oCmd.CommandText = sql3
oCmd.Execute

Any help appreciated
Thanks Andy!

 

[GIGN]

Do a response.write of the statement in question, you'll soon find the problem ;-)