CODEWITHSUNDEEP
sqlasp-classic
user2938704
user2938704

Reputation:

ASP Classic with SQL - No value given for one or more parameters

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

Upvotes: 0

Views: 595

Answers (2)

Nagaraj S
Nagaraj S

Reputation: 13474

Try like this.Put ' for string value

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

Upvotes: 0

juergen d
juergen d

Reputation: 204756

You need quotes around strings

readsql = "UPDATE [post] SET pos_content = 'bob' WHERE pos_ID = 136"
                              here---------^---^

Upvotes: 1

Related Questions