0

I am receiving this error message but can not see the problem, anyone spot it?

No value given for one or more required parameters.

set postRs=server.CreateObject("adodb.recordset") readsql = "UPDATE [post] SET pos_content=bob WHERE pos_ID = 136" postRs.Open readsql, conx, adOpenKeyset, AdLockOptimistic

Thanks

Improve this question

2 Answers 2

Reset to default
1

You need quotes around strings

readsql = "UPDATE [post] SET pos_content = 'bob' WHERE pos_ID = 136" here---------^---^
Improve this answer
Sign up to request clarification or add additional context in comments.

1 Comment

Thanks, sorry if the question was obvious, I'm still learning.
0

Try like this.Put ' for string value

readsql = "UPDATE [post] SET pos_content='bob' WHERE pos_ID = 136"
Improve this answer

Comments